Below query to check the wait events in the database
col EVENT for a50
set head on feed on
set lines 134 pages 2000
select event,count(*) from gv$session where event not like 'Streams%' and wait_class <> 'Idle' group by event order by 2;
AWS, Database, ETL, Integration, Data Reporting & Automation Expert
Below query to check the wait events in the database
col EVENT for a50
set head on feed on
set lines 134 pages 2000
select event,count(*) from gv$session where event not like 'Streams%' and wait_class <> 'Idle' group by event order by 2;
Comments
Post a Comment