AWR REPORT PERFORMANCE TUNING
-----------------------------------------------------
Introduction
---------------
Automatic work load Repository report or AWR report collects,processes and maintain performance statistics for problem detection and self tuning process.This gathered data is stored both in memory and in the database,and is dispalyed in both reports and views.
AWR was introduced in oracle 10g and it is still being used in present versions and AWR is comes with enterprise edition
Performance Tuning in oracle database
The AWR is a source for information and other oracle feature it includes
Wait events for identity performance problems
Time model statstics
AWR is used to collect performance statastics
Storing dataabase statastics performance tuning
Active session history (ASH)
AWR Snapshots performance and dash board database load instanse status and top wait events( snapshot exactly tells the what happening in database in particular time)
AWR snapshot everthing will be recorded in snapshot id like we taking any RMAN backups,blockings,deadlock) for that snapshotid we can take exact time what happening
AWR Report will be genated database should be coninuos running .
AWR Report comes with enterprsie addition (licencesing that diagnostics and performance)
AWR reports will be stored in sysaux tables when the time of installation.
every hour snapshot will taken
let us go the process
---------------------------------------------
whether my database is up and running
$ ps - ef | grep pmon
let us connect with sql plus
$ sqlplus '/as sysdba'
check my database version
sql>select * from v$ version;
sql >oracle database 12c enterprise edition release 12.1.0.2.0 64 bit production
parameter statastics_level
sql>show parameter control_management_pack_access;
value -->DIAGNOSTIC+TUNING
$ cd $ /ORACLE_HOME
$ cd /data/oracle/app/oracle/product/12.1.0/db_home/rdbms/admin/
$ ls - ltr
$ ls - lrt | grep awrrpt *
@ awrrpt.sql lets run the sequel
it will shows the current instance---->DBID 22850381 DBNAME -->prod instnum-->1
AWR report can be genated in the following formats like html,txt
enter the value of report type : html
enter the value of num days :2
specify the begin snapshot and end snapshot id
enter the value of begin snapshot id :135
enter the value for end snaphot id :137
enter the value for report _name :dcc.html
exit
$ cd /data/oracle/app/oracle/product/12.1.0/db_home/rdbms/admin/
$ ls -ltr
dcc.html
sql>$ oracle_home/dbms/admin/awrrpt.sql
we cannot see htmll file here in linux platform so that we can go winscp toool copy that file to desktop you will see the dcc.html and open the report in windows platform
Note : info on AWR report performance tuning it may be differ from your environment like production,testing,development directory structures
THANKS FOR VIEWING MY BLOG FOR MORE UPDATES FOLLOW ME OR SUBSCRIBE ME
