How to Read or Analyze an AWR ( Automatic Workload Repository ) Report in Oracle -2

Hi,

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

 

 

Read first Article before this.

How to Read or Analyze an AWR ( Automatic Workload Repository ) Report in Oracle -1

 

 

 

Host CPU

You can find how many CPUs,Cores and Sockets are there in the Database Server with this section.

Host and Instance CPU Utilization Statistics are also in this section like following.

 

IO Profile

You can find out how much IO ( Total Requests, Database Requests,Database (blocks), Direct (blocks) and etc. ) are there in the Database with this section.

 

Memory Statistics

You can find out the value ( Begin-End)  of the Host Memory, SGA, PGA.

 

Cache Sizes

You can find out the value ( Begin-End)  of the Buffer Cache, Shared Pool and Log Buffer of the Database and the Standard Block Size information

 

Shared Pool Statistics

You can find out some Shared Pool Statistics in this section.

 

Main Report

You can access all sections via using related links in this section.

 

 

 

 

Time Model Statistics

You can find some special statistics in this section like sql execute elapsed time, RMAN cpu time (backup/restore), hard parse elapsed time, PL/SQL execution elapsed time.

These statistics are very important to detect performance problem or load of database.

For example; If RMAN cpu time (backup/restore) is at TOP, then you can change RMAN Backup date as IDLE time of Database like Night.

 

Operating System Statistics

You can find out Average Busy, IDLE, SYS and User time statistics of operating system in this section. Thus, you can decide database busy ? or operating system is busy ?.

 

 

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

 

 

You can access the third post of AWR report with the following link.

How to Read or Analyze an AWR ( Automatic Workload Repository ) Report in Oracle -3

 

 

 

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.

Leave a Reply

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