JAVA

select num_rows * avg_row_len/1024/1024 "实际表占用空间数(M)" from user_tables where table_name = 'ALP_LOGISTICS_TRACE_TBDCY'; 容量单位换算： 1KB=1024字节，就是1024个英文字母 是512个中文字 其他还有 1GB=1024MB 1MB=...

select b.owner,b.object_name,a.session_id,a.locked_mode,c.serial#,c.sid||','||c.serial# from v$locked_object a,dba_objects b ,v$session c where b.object_id = a.object_id And a.session_id = c.sid ...