Oracle Database Wait Event Scripts -2

Hi,

When you take many complaints from customer about slowness of database, you should check Oracle database wait events.

 

You can check Top Oracle database wait events at specific intervals. You should type date and SNAP_ID

select snap_id,begin_interval_time,end_interval_time
from dba_hist_snapshot
where to_char(begin_interval_time,'DD-MON-YYYY')='20-FEB-2019'
and EXTRACT(HOUR FROM begin_interval_time) between 8 and 10;

select * from (
select active_session_history.event,
sum(active_session_history.wait_time +
active_session_history.time_waited) ttl_wait_time
from dba_hist_active_sess_history active_session_history
where event is not null
and SNAP_ID between 34411 and 34431
group by active_session_history.event
order by 2 desc)
where rownum<10;

 

Query result is like below screenshot.

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

4 thoughts on “Oracle Database Wait Event Scripts -2

  • April 29, 2019 at 3:27 pm
    Permalink

    I pay a quick visit each day some web sites and websites to read content,
    except this web site presents feature based content.

    Reply
  • May 12, 2019 at 10:26 am
    Permalink

    Hello! I understand this is kind of off-topic but I needed to ask. Does building a well-established blog such as yours require a massive amount work? I’m completely new to operating a blog however I do write in my diary everyday. I’d like to start a blog so I can easily share my personal experience and views online. Please let me know if you have any recommendations or tips for new aspiring blog owners. Thankyou!|

    Reply
  • May 22, 2019 at 1:50 am
    Permalink

    Heya i am for the first time here. I found this board and I find It truly useful
    & it helped me out much. I hope to give something back and aid others like
    you helped me.

    Reply