Dear Experts,
We are using oracle 12.1.0.2 version
What is the best query or view to check all the events of a session and its time waited on each event
SQL> select event,time_Waited from v$session_event where sid=84;
EVENT TIME_WAITED
------------------------------------------ -----------
Disk file operations I/O 0
latch: cache buffers chains 0
buffer busy waits 0
log file sync 0
db file sequential read 8
db file scattered read 0
db file parallel read 0
gc cr multi block request 67
gc cr block 2-way 25
gc cr block busy 0
gc current block 2-way 26
gc cr grant 2-way 3
gc current grant 2-way 4
gc current grant busy 29
latch: row cache objects 1
row cache lock 0
latch: shared pool 1
library cache pin 0
library cache lock 0
resmgr:cpu quantum 0
utl_file I/O 0
SQL*Net message to client 0
SQL*Net message from client 1
enq: UL - contention 0
events in waitclass Other 0
25 rows selected.
When i check in ash,it shows
SQL> select event,count(sample_id) from v$active_session_history where sql_id='dnms9yjkrkygv' group by event order by count(sample_id) desc;
EVENT COUNT(SAMPLE_ID)
------------------------------------------ ----------------
9160------------------------------------I understand this is on cpu
Thank you