本文探讨了SQL查询语句的使用，包括等待事件分析、Rollstat查询、Session等待分析等，以及如何通过优化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';
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';
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
