image

How to know the size of oracle database?

Oracle database consist of datafiles,redo log files, control files and temp files. And sum of all these file is the size of the oracle database. i.e   select ( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) + ( select nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) + ( select sum(bytes)/1024/1024/1024 redo_size from sys.v_$log ) + ( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 … continue reading

image

how to find current size, available size, used size and total size in a Tablespace .

For used size: select sum(bytes) from dba_segments where tablespace_name=”; For available size: select sum(bytes) from dba_datafiles where tablespace_name=”; select df.tablespace_name “Tablespace”, totalusedspace “Used MB”, (df.totalspace – tu.totalusedspace) “Free MB”, df.totalspace “Total MB”, round(100 * ( (df.totalspace – tu.totalusedspace)/ df.totalspace)) “Pct. Free” from (select tablespace_name, round(sum(bytes) / 1048576) TotalSpace from dba_data_files where tablespace_name like ‘%xxxxxxxxxxxxxx%’ group … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube