| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database connections hanging--Critical Production issue.
I thought this was fixed by version 8i, but this sounds a lot like an old
bug that occurred when otrace was set on and the *.dat files got too big in
$ORACLE_HOME/otrace/admin. You might want to check the date and filesize
for these files.
Good luck!
Jay Miller
x48355
-----Original Message-----
Sent: Wednesday, January 29, 2003 3:29 AM
To: Multiple recipients of list ORACLE-L
I am running an Oracle v 8.1.7.3.0 version db on Sun solaris 2.6 and the problem I face is that all of a sudden all new connections to the database just hang [ the conn is not made ] and if at all a connection can be established using svrngrl [ only this ] I find that no queries can be executed [ all of them hang ].No alert messages, no trace files generated and the machine is low on usage.A database reboot solves the problem for a few hours .The number of processes accessing the database at point of problem is about 300 and this is well less than the processes parameter value.The machine has 4 G of Ram an SGA size close to 1G. Any ideas would be appreciated.
--
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Girijan Puthran
INET: girijan.puthran_at_db.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 04 2003 - 13:44:34 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |