Home » RDBMS Server » Server Administration » possible causes of database hung (9i,10g,Linux)
possible causes of database hung [message #326169] Tue, 10 June 2008 07:17 Go to next message
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.
Re: possible causes of database hung [message #326176 is a reply to message #326169] Tue, 10 June 2008 07:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: possible causes of database hung [message #326178 is a reply to message #326169] Tue, 10 June 2008 07:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: possible causes of database hung [message #326179 is a reply to message #326178] Tue, 10 June 2008 07:40 Go to previous messageGo to next message
pablolee
Messages: 2834
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


Very Happy
Re: possible causes of database hung [message #326188 is a reply to message #326179] Tue, 10 June 2008 09:25 Go to previous messageGo to next message
ThomasG
Messages: 3189
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.
Re: possible causes of database hung [message #326349 is a reply to message #326188] Wed, 11 June 2008 02:49 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Is 42a related to Global warming or that someone left the tap running Smile
Previous Topic: Error ORA-12528 (merged)
Next Topic: Connectivity Error Oracle 8i in windows server 2003
Goto Forum:
  


Current Time: Sat Dec 03 22:19:48 CST 2016

Total time taken to generate the page: 0.09673 seconds