Home » RDBMS Server » Performance Tuning » Application Turns Slow
Application Turns Slow [message #175360] Thu, 01 June 2006 23:36 Go to next message
shilpa.rajput
Messages: 31
Registered: May 2006
Location: Pune
Member

Hi..I'm dealing with the production databases(oracle 9i).Our D2k based application turns dead slow some times and it has become quite frequent from some days.What could be the possible reasons from database side?
I know this much wont be enough to depict the scenario but expect the generalised reason.
Thanks in advance.
Re: Application Turns Slow [message #175375 is a reply to message #175360] Fri, 02 June 2006 00:58 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
- Read the sticky (first post of this forum) for some general guidelines
- Read up on how to install and use statspack (it's included with your database)
- Find out what changed, shortly before problems started.
Previous Topic: Implement Partitioning & Purging of Partitions
Next Topic: Advice on shared_pool and block_size on 9i
Goto Forum:
  


Current Time: Thu Apr 25 04:37:54 CDT 2024