How to Analyze an AWR Report in Oracle -3

Hi,

I will continue to explain How to Analyze or Interpret an AWR report in Oracle in this article.

 

 

Read previous Articles before this.

 

 

 

Foreground Wait Class

You can detect which wait class are foreground in the database. Sessions are in CPU or they are performing I/O or They are waiting for Network, Commit, Concurrency wait event.

%1-3 values are not big problem for following wait events. But If Network, Commit,Concurrency and etc. wait class are more than %3-5, probably you will feel as slowness in the Database.

 

Foreground Wait Events

You can find out which wait events and how much they affect your database with this section. For example if db file sequential read is TOP, then Probably a user tries to perform a Physical I/O while doing sequential reads on the Buffer cache.

This wait event usually result from single block readings when the data on the table is accessed using index rather than full table scan.

and If Direct path read event occurs if the Oracle Instance access data asynchronously from the Datafiles and places this data in the PGA rather than the Buffer Cache.

 

Background Wait Events

You can detect which wait events are background in the database. Background Sessions are in CPU or they are performing I/O or They are waiting for Network, Commit, Concurrency wait event.

Background sessions or processes are generally executed from Oracle and they are internall processes or sessions.

 

 

 

 

Wait Event Histogram

You can see wait event details as histogram in this section like following. For example; enq: TX – row lock contention occurred so much in the database. It means any two sessions are blocking each other.

 

 

 

If library cache lock wait event occurred so much like above, then we need to solve this problem. You can read following article to solve library cache lock wait event.

 

 

I will continue to explain How to Analyze an AWR Report in Oracle in the next article.

 

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.