Database slow down at particular time [message #65239] |
Mon, 28 June 2004 03:25 |
Ravi
Messages: 251 Registered: June 1998
|
Senior Member |
|
|
I have a production database, there is constant transaction going on 24hrs. But the database response goes down drastically from 10am to 12noon everyday. During other time the performance is very good. How do i find out what is the problem.
Thanks
Ravi
|
|
|
Re: Database slow down at particular time [message #65241 is a reply to message #65239] |
Wed, 30 June 2004 04:25 |
Daljit Singh
Messages: 290 Registered: October 2003 Location: Texas
|
Senior Member |
|
|
Hi,
According to me first of all u have to find out wht types of transactions going on in that time period and whether that transactions are facing any waits or contentions.
U can use the command column of v$session view to find out what type of work the users are doing in that period. If they are doing select than check the SGA hit ratios. And if u find low hit ratio than it means due to lot of selects the statements are flushing out from the SGA rapidly. On the basis of detailed analysis try to resolve the SGA memory issue.
And if u find that the transactions are doing lots of updated than check the contention of Rollback segments and redo and disk IO. you can use various v$ views for that. and concentrate on removing the issues related to this contention/waits.
By this approach you will get a way of finding the root of the cause, which is the main thing in performance tuning.
I hope that will help.
Daljit Singh
|
|
|
Re: Database slow down at particular time [message #65303 is a reply to message #65239] |
Tue, 27 July 2004 11:10 |
Master P
Messages: 6 Registered: July 2004
|
Junior Member |
|
|
Install and Run Statspack and look at your reports to find out what is the slowdown. It's quite easy to setup Statspack and find out the top 5 wait events, top 5 queries by Read, Logical I/O etc and go directly to the root of your problem.
|
|
|