Showing posts from July, 2015
Tablespace sizes in Oracle --- Gives the output in MB SELECT Total.name "Tablespace Name", nvl(Free_space, 0) Free_space, nvl(total_space-Free_space, 0) Used_space, total_space FROM (select tablespace_name, sum(by…
Note : - Replace UNDOTBS1 with your UNDO TABLESPACE NAME and execute the following statements SELECT DISTINCT STATUS,TABLESPACE_NAME, SUM(BYTES)/1024/1024 "Mb", COUNT(*) FROM DBA_UNDO_EXTENTS GROUP BY STATUS, TABLESPACE_NAME; select max(…
USEFUL UNIX COMMANDS COMMAND DESCRIPTION OUTPUT Ctrl-s Stops scrolling display Ctrl-q Rusume scrolling display Ctrl-u Kills the current line Ctrl-d or exit …
