Home » RDBMS Server » Performance Tuning » database slow
database slow [message #176916] Mon, 12 June 2006 00:26 Go to next message
chidellanr
Messages: 5
Registered: April 2006
Location: Hyderabad, India
Junior Member

Hi, friends
I am working on oracle 9i R2. the performance of the database suddenly slowdown can any one tell me the reason.
thanks
Re: database slow [message #176923 is a reply to message #176916] Mon, 12 June 2006 00:51 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Strange questions. It's like asking: My car doesn't want to drive fast this morning, do you know why?

Some general pointers:

- Machine resources are depleted (you run out of CPU, IO or memory)
- Too many users connected/ Too many jobs running
- Locks on the database
- Some SQL queries are slow (look at sql plans, gather stats, add hints, etc)
- Database is in archivelog mode and archiver is stuck
- Etc.

You need to check all the above. If you cannot, get a DBA to help you.
Re: database slow [message #176930 is a reply to message #176923] Mon, 12 June 2006 01:23 Go to previous message
chidellanr
Messages: 5
Registered: April 2006
Location: Hyderabad, India
Junior Member

Hi,
Frank
thanks for prompt reply I have checked up every thing.
I have cleared the Locks on the database. I didn't gather the stats. i' ll do it now.

Previous Topic: OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING
Next Topic: is unique index helpful in making query fast?
Goto Forum:
  


Current Time: Thu Mar 28 07:58:57 CDT 2024