www.dbatoolz.com › ORACLE DBA Forums › Ask DBA › Question Id: 4061 | Permalink

Application is slow during peak hours

Question ID: 4061
Created By:	2010-JUL-08 08:00:02 [Muddu5640]
Updated By:	2010-JUL-08 13:32:49 [Vitaliy]
Status:	Open
Severity:	Normal
Read Only:	No

11556

2010-JUL-08 08:00:02

Muddu5640

User

Registered On: Jul 2010

Total Posts: 7

Our front end application responses too slow when the number of users accessing 
it is high specially during the peak hours, i.e., in the morning. Since I am 
the DBA in the backend, is there any troubleshooting I have got to do or it is 
the developers and system admins who have look into it?
If yes, what all things I got to look for?

Thanks!
Muddu

11559

2010-JUL-08 13:32:49

Vitaliy

Moderator

Registered On: Mar 2006

Total Posts: 289

refer to:  Things to monitor in Oracle Database Server

specifically, pay close attention to:

  ASH (Active Session History)
  AWR (Automatic Workload Repository)

- Vitaliy

Permalink