select inst_id,sessions_current,sessions_highwater from gv$license;

----sessions_current表示除開Oracle本身進程之外的用戶進程

select sid,event,p1,p1text from v$session_wait;

-----進程等待事件

select TABLE_NAME,avg_row_len,num_rows from dba_tables where avg_row_len*num_rows

-----高水位線

select * from gv$resource_limit where resource_name = 'sessions';

select * from dba_objects where status='INVALID' and object_type <> 'SYNONYM'

ITPub博客

session 上线 ---012