2.根据sql_id,在dba_hist_sqltext中查看相关sql语句 select command_type,sql_text from dba_hist_sqltext where sql_id='d5bcqvumxr4y4'; command_type sql_text 3 select count(id) from bom 注:command_type=3表示这是select命令,完整的command_type可以select * from audit_actions; 3.查看之前命令的...
from DBA_HIST_SQLSTAT s, DBA_HIST_SNAPSHOT p, DBA_HIST_SQLTEXT t where 1=1 and s.SNAP_ID = p.SNAP_ID and s.SQL_ID = t.SQL_ID and EXTRACT(HOUR FROM p.END_INTERVAL_TIME) between 8 and 16 and t.COMMAND_TYPE != 47 –- Exclude PL/SQL blocks from output and p.END_INTERVAL...
from DBA_HIST_SQLSTAT s, DBA_HIST_SNAPSHOT p, DBA_HIST_SQLTEXT t where 1=1 and s.SNAP_ID = p.SNAP_ID and s.SQL_ID = t.SQL_ID and EXTRACT(HOUR FROM p.END_INTERVAL_TIME) between 8 and 16 and t.COMMAND_TYPE != 47 –- Exclude PL/SQL blocks from output and p.END...
b.sql_text, b.command_type, a.sample_timeFROMdba_hist_active_sess_history aJOINdba_hist_sqltext bONa.sql_id=b.sql_idJOINdba_users cONa.user_id=c.user_idWHEREa.sample_timeBETWEENSYSDATE-3ANDSYSDATEANDb.command_typeIN(7,85)ORDERBYa.sample_timeDESC;...
b.command_type,a.sample_time FROM dba_hist_active_sess_history a JOIN dba_hist_sqltext b ON a.sql_id = b.sql_id JOIN dba_users c ON a.user_id = c.user_id WHERE a.sample_time BETWEEN SYSDATE - 3 AND SYSDATE AND b.command_type IN (7, 85)ORDER BY a.sample_ti...
html SQL> !pwd /home/oracle 1.1 查看oracle容器内生成的AWR报告 代码语言:javascript 代码运行次数:0 运行 AI代码解释 [root@test ~]# docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 3edfba76f476 registry.aliyuncs.com/helowin/oracle_11g "/bin/sh -c '/home/o…" 2 months ago...
FROM v$sqltext q, v$session s WHERE q.address = s.sql_address AND s.sid = &sid -- 这个&sid 是第一步查询出来的 ORDER BY piece; 1. 2. 3. 4. 执行后,输入对应的sid即可查看对应的sql. 查看谁锁了谁 SELECT s1.username || '@' || s1.machine || ' ( SID=' || s1.sid || ...
dba_hist_active_sess_history (根据wrh$_active_session_history生成的视图) 对于局部的,比如某个页面列表sql,我们可以使用Oracle的执行计划进行sql调优,但是对于整个系统来说,你可以知道哪些sql比较耗时?当然可以通过查Oracle的共享池得到,不过Oracle系统本身就提供了几种性能分析报告,比如AWR、ASH、ADDM、AWRSRPT等等报...
where sql_id = '1jakys7m6avc3' --other good SQL ID或者当前有问题的SQL id and plan_hash_value = 835069737 --这个是判断出来的比较优化的执行计划 and other_xml is not null)) d; SELECT sql_text INTO clsql_text FROM dba_hist_sqltext ...
select b.username username,a.disk_reads reads,a.executions exec,a.disk_reads / decode(a.executions, 0, 1, a.executions) rds_exec_ratio,a.command_type,a.sql_text Statementfrom v$sqlarea a, dba_users bwhere a.parsing_user_id = b.user_idand a.disk_reads > 100000order by a.disk_read...