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: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
