AWR Report - Database Performance Troubleshooting
checkout my blog
http://sapfreelancing.com/blog/detail/id/u253r2/flag/PB
checkout my blog
http://sapfreelancing.com/blog/detail/id/u253r2/flag/PB
AWR – Automatic Workload Repository
AWR Report is
built in report from Oracle which helps to drill down the performance related
issues in Database.
This report gives
you overall statistical load on the database. You can easily point out the
query / program which is putting highest load on the database or which is
consuming highest CPU resources.
Enter user-name:
Password:
#su – oraxyz
#xyzadm> sqlplus
"/as sysdba"
#SQL> @?/rdbms/admin/awrrpt.sql
#html
#1
#Enter value for begin_snap: 29386
#Enter value for end_snap: 29387
#Enter value for report_name: awr.html
xyzadm> sqlplus "/as
sysdba"
No comments:
Post a Comment