查看sql

select event,count(*) from v$session_wait where wait_class<>'Idle' group by event;




select * from v$rollstat;


select p1,p2,p3, a.* from v$session a where a.event='db file sequential read';
select * from v$sql where sql_id='8yf5rxx93hq0b';


select sum(bytes/1024/1024),tablespace_name from dba_free_space group by tablespace_name;


select file_name,bytes/1024/1024,maxbytes/1024/1024 from dba_data_files;
select sum(bytes/1024/1024) from dba_segments where segment_name='T_GL_ASSISTBALANCE';