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 cwhere b.object_id = a.object_id And a.session_id = c.sid ...