Warning: include_once(/home/tabrez/www/talk/mtrefsearch.php) [function.include-once]: failed to open stream: No such file or directory in /home/tabrezsyed/mandalivia.com/talk/archives/000480.php on line 118
Warning: include_once() [function.include]: Failed opening '/home/tabrez/www/talk/mtrefsearch.php' for inclusion (include_path='.:/usr/local/lib/php:/usr/local/php5/lib/pear') in /home/tabrezsyed/mandalivia.com/talk/archives/000480.php on line 118
June 17, 2003
size of an oracle database
Allocated Tablespace in MB :
-----------------------------
SELECT tablespace_name ,SUM(bytes)/(1024*1024) MB_TOTSPACE
FROM dba_data_files GROUP BY tablespace_name
DB size in GB:
------------
select sum(bytes)/1024000000 "Size in GB" from dba_data_files;