| Database slow down [message #174515] |
Mon, 29 May 2006 07:43  |
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
|
Member |
|
|
Hi Gurus,
I have a typical problem. My database works fine in the morning but slows down as the day goes on. I dont understande the reason for this. Developers complain that the database becomes very slow late in the night. I dont know how to solve this problem. Can you please suggest that what are the major areas that must be causing this problem.
Please provide your suggestions as soon as possible.
DB version:- Oracle 9.2.0.5
OS:-Windows 2003
Day before yesterday in order to resolve this i dropped and re-create the temp tablespace which resolved the problem. But, today again we faced the same problem even when temp tablespace was not at all used.
Waiting for your suggestions.
Thanks in advance.
Milind.
|
|
|
|
|
|
| Re: Database slow down [message #174588 is a reply to message #174515] |
Mon, 29 May 2006 23:17  |
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
|
Member |
|
|
Hi,
Thanks for your reply.
I understand that there are many reasons for DB slowdown.
But, i needed help regarding what are the areas that can be considered for diagnosis of the reason.
Your reply was great. Certainly i liked it. But, a forum is designed actually understand the problem and not to humiliate people. I am a member of this site since last 2 to 3 years and nobody has replied this way. I would suggest the moderator of this site to look into this issue.
i suppose i have to look for any other forum where i can get the help in a proper way.
|
|
|
|
| Re: Database slow down [message #174595 is a reply to message #174588] |
Tue, 30 May 2006 00:43 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
Check for ratios.. the hit ratios in shared pool, & data buffer cache.
Check for wait events.
Take statspack snaps at different times, generate reports using them, & compare them.
Check system statistics... cpu usage, ram usage, disk i/o.
I hope after that you should be able to identify the bottleneck & work on performance of DB.
-Girish
|
|
|
|
| Re: Database slow down [message #174730 is a reply to message #174588] |
Tue, 30 May 2006 07:11 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
@OP
I agree that the lampoon could have been avoided. But, A satire free online forum/community is utopian.
>> I am a member of this site since last 2 to 3 year
And still not asking questions in a proper way?
Did you get to read those stickies?
http://www.orafaq.com/forum/t/59966/42800/
http://www.orafaq.com/forum/t/51267/42800/
and
http://www.catb.org/~esr/faqs/smart-questions.html
>>Day before yesterday in order to resolve this i dropped and re-create the temp tablespace which resolved the problem.
Resolve what?
What made you think temp tablespaces are the problem?
Did you take a statspack/trace or anything measurable? Did you check waitevents? If so, please post them.
With the wealth of information provided, we cannot move further.
>> i suppose i have to look for any other forum where i can get the help in a proper way.
Could you please define 'proper way'?
www.orafaq.com is not a paid service.
The only 'proper way' i know to get a solution to an oracle related problem is to raise a ticket with Oracle support.
Regards~
[Updated on: Tue, 30 May 2006 07:17] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Database slow down [message #175125 is a reply to message #174515] |
Wed, 31 May 2006 18:26 |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Are you seeing signs of RAM Leakage by an application? I do not believe it can not be Oracle processes that leak memory.
I assume you shutdown and startup the database each morning and it works better for awhile?
Is your memory footprint for Oracle so large that it does not fit into real memory.
Your system RAM must have room for the O/S plus Oracle processes and current sessions.
Your disk must contain an O/S plus an Oracle product stack, plus your data, plus your indexes, plus temp tablespace, plus system tablespace, plus archive logs, plus control files, plus logfiles, plus dumps, plus other stuff.
I assume you would never put your data in the system tablespace, or mix it with your indexes?
[Updated on: Wed, 31 May 2006 18:27] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
