oracle表空间
-
编辑 删除
ORA-01652错误解决
SQL> conn / as sysdbaConnected.SQL> grant select on dba_objects to a;Grant succeeded.SQL> conn a/a Connected.SQL> select count(*) from dba_objects; COUNT(*)---------- &n...
-
编辑 删除
oracle查看表空间使用情况
SELECT tablespace_name,sum_m as total_m, ( sum_m- free_m) as used_m,free_m,to_char(100*(sum_m-free_m)/sum_m, '99.99') || '%' AS pct_used,to_char(100*free_m/sum_m, '99.99') || '%' AS pct_free FROM ( SE...
