OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » database slow

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database slow [message #176916]

Mon, 12 June 2006 00:26

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

Report message to a moderator

Re: database slow [message #176923 is a reply to message #176916]

Mon, 12 June 2006 00:51

Frank Naude
Messages: 4581
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.

Report message to a moderator

Re: database slow [message #176930 is a reply to message #176923]

Mon, 12 June 2006 01:23

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 05:47:15 CST 2024