select sql_id,parsing_schema_name,service,module,FIRST_LOAD_TIME,last_load_time,sql_fulltext Active Session History (ASH) was introduced in Oracle 10g. Oracle Wait Events And Their Solutions - ORACLEAGENT BLOG The performance page or top activity may show high I/O waits but it won't indicated if the latency of I/O is unusually high . There is no wait event that accounts for using the CPU for processing. But If Network, Commit,Concurrency and etc. Oracle I/O latency monitoring. Oracle provides wait events that allow you to understand the total time a query spends in the database. col total_waits head "Total|Waits" format 999,999. col tw_ms head "Waited|for (ms)" format 999,999.99. col aw_ms head "Average|Wait (ms)" format 999,999.99. The main reason why this value is high is that the archives sent to the Standby side arrive late due to the network. Same with SGA memory. The most common wait events related to this are gc cr request and gc buffer busy. How to find long running queries in Oracle - orahow How many times did you find yourself reviewing the "Top 5 Timed Events" in an AWR report, and wondering if some specific wait event occured more then usual in the report you are looking at and if the average wait time is unusual? 2 mname varchar2 (200); 3 begin. You can find the top 5 wait events in the AWR reports. Oracle Wait Events - direct path read - Toad This DMV shows the names, counts, and wait times of wait events encountered by the SQL Server engine, or to be exact the SQLOS. For example, the PGA advisor would tell you "hey, if you increase the PGA target by X, then you would expect to see Y less sorts to disk". Query to find Top 5 wait events in Database | OracleFunda Concurrency wait event - Ask TOM - Oracle This is Bug 11800170 - ASM IN KSV WAIT AFTER APPLICATION OF 11.2.0.2 GRID PSU. . How to find the waitevent History of the Oracle session There is no wait event that accounts for using the CPU for processing. For this we use TOP command. Your session is most likely using the CPU. Oracle Performance queries - Devops Tutorials People often forget this. We can analyze the top waits during the query by viewing the database load and choosing the Top waits tab. This has been tested and verified . Beginning Performance Tuning: Diagnose the Past - Oracle Descriptions of Wait Events Information about wait events is displayed in three dynamic performance views: V$SESSION_WAIT displays the events for which sessions have just completed waiting or are currently waiting. From the above output you can further check the sql_id, sql_text and the wait event for which query is waiting for. Operating System tools show very high utilization or saturation of disks used for storage of database files. SQL> commit; Commit complete.