select inst_id,sessions_current,sessions_highwater from gv$license;
----sessions_current表示除開Oracle本身進程之外的用戶進程
select sid,event,p1,p1text from v$session_wait;
-----進程等待事件 -----高水位線 select * from gv$resource_limit where resource_name = 'sessions'; select * from dba_objects where status='INVALID' and object_type <> 'SYNONYM'
select TABLE_NAME,avg_row_len,num_rows from dba_tables where avg_row_len*num_rows
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25850100/viewspace-703057/,如需转载,请注明出处,否则将追究法律责任。