目的:计算oracle数据库总的空间大小
1. 计算数据文件的大小
SQL> select sum(bytes)/(1024*1024) "Size In MB" from dba_data_files;
Size In MB
----------
960
2. 计算临时文件的大小
SQL> select sum(bytes)/(1024*1024) "Size In MB" from dba_temp_files;
Size In MB
----------
目的:计算oracle数据库总的空间大小
1. 计算数据文件的大小
SQL> select sum(bytes)/(1024*1024) "Size In MB" from dba_data_files;
Size In MB
----------
960
2. 计算临时文件的大小
SQL> select sum(bytes)/(1024*1024) "Size In MB" from dba_temp_files;
Size In MB
----------