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.

 

 

If you don’t know What are the Wait Events in the Oracle Database and their solution, you can read the following article.

Oracle Wait Events and Their Solutions in Oracle Database

 

 

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 should be such as follows.

 

 

 

Do you want to learn Oracle Database Performance Tuning detailed, then read the following articles.

https://ittutorial.org/oracle-database-performance-tuning-tutorial-12-what-is-the-automatic-sql-tuning-and-how-to-automated-sql-tuning/ 

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and 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 [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

4 comments

  1. Stunning story there. What happened after? Good
    luck!

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

  3. 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!|

  4. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *