oracle运维05监视执行sql正在执行已执行执行性能查看

1.正在执行的sql

select a.username, a.sid,b.SQL_TEXT,b.SQL_FULLTEXT,b.sql_id,b.EXECUTIONS  from v$session a, v$sqlarea b where a.sql_address = b.address

2.执行过的sql

select b.SQL_TEXT,b.FIRST_LOAD_TIME,b.SQL_FULLTEXTfrom v$sqlarea bwhere b.FIRST_LOAD_TIME between '2020-06-20/01:52:00' and '2020-06-22/13:52:02'order by b.FIRST_LOAD_TIME desc;

3.查找前10条性能最差sql;

SELECT *  FROM (select PARSING_USER_ID,               EXECUTIONS,               SORTS,               COMMAND_TYPE,               DISK_READS,               sql_text,               sql_fulltext,               parsing_schema_name          FROM v$sqlarea         order BY disk_reads DESC) where ROWNUM < 10;