Link to home
Start Free TrialLog in
Avatar of ralph_rea
ralph_rea

asked on

database performance

Hi,
I've noticed significantly degrade database performance from 00:00 to 08:00 in the last month
I must Identifying High-Load SQL Statements that may consume a disproportionate amount of system resources.

I have created a series of WORKLOAD REPOSITORY report (AWR). In attach one extract for the 18-October.

I need help to read/understand this AWR to identifies high-load SQL statements that may be causing systemwide performance degradation.

I'd like to create a report with 3 column "CRITICAL" - "WARNING" - "OK" for each SQL Statement.

Can you help me for this example in attach and tell me if I must investigate other (DBA_HIST?).
awr-extract.docx
ASKER CERTIFIED SOLUTION
Avatar of MikeOM_DBA
MikeOM_DBA
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial