OraFAQ Forum: Server Administration » possible causes of database hung

Home » RDBMS Server » Server Administration » possible causes of database hung (9i,10g,Linux)

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

possible causes of database hung [message #326169]

Tue, 10 June 2008 07:17

Creems
Messages: 70
Registered: July 2007
Location: Johannesburg

Member

Hi,

Can someone please tell me what are all the possible causes of database hung?

Thanks.

Report message to a moderator

Re: possible causes of database hung [message #326176 is a reply to message #326169]

Tue, 10 June 2008 07:29

Michel Cadot
Messages: 68667
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No one can give you that list.
In addition, what is for you a "database hung"?

Regards
Michel

Report message to a moderator

Re: possible causes of database hung [message #326178 is a reply to message #326169]

Tue, 10 June 2008 07:32

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Too many to list.
Could be archiving,locks or the database may just be slow.
Depends on how you define 'hanging'.
Post your scenario. Somebody might help.

Report message to a moderator

Re: possible causes of database hung [message #326179 is a reply to message #326178]

Tue, 10 June 2008 07:40

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Mahesh Rajendran wrote on Tue, 10 June 2008 13:32

Post your scenario. Somebody might help.

Likely Scenario no. 1

Quote:

For the next part of your homework assignment, please list the reasons that a database might hang

Report message to a moderator

Re: possible causes of database hung [message #326188 is a reply to message #326179]

Tue, 10 June 2008 09:25

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Reason 42a:
Rising water levels.

Reason 42b:
And some dumba** has plugged everything BUT the fibrechannel switches into the emergency power outlets.

Report message to a moderator

Re: possible causes of database hung [message #326349 is a reply to message #326188]

Wed, 11 June 2008 02:49

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Is 42a related to Global warming or that someone left the tap running Smile

Report message to a moderator

Previous Topic:	Error ORA-12528 (merged)
Next Topic:	Connectivity Error Oracle 8i in windows server 2003

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 24 22:57:40 CDT 2024