Vivek: Oracle Support is right. THis is a typical LGWR problem.
The first thing you should do is.. You need to reduce the size of Log Buffer (it should be in KBs.. NEVER configure log buffer in MBs) Try setting log buffer in KBs. Best Regards, K Gopalakrishnan Bangalore, INDIA -----Original Message----- VIVEK_SHARMA Sent: Wednesday, May 22, 2002 2:04 PM To: Multiple recipients of list ORACLE-L O.S. Solaris 8 Oracle 8.1.7.2 + 3 Stand Alone Patches CASE - On Database SHUTDOWN Got the Error ora-600 [3708 ] Messages ALTER DATABASE CLOSE NORMAL Tue May 21 01:30:36 2002 SMON: disabling tx recovery SMON: disabling cache recovery Tue May 21 01:46:23 2002 Errors in file /oracle734/ver817/rdbms/userlog/bby01_ora_19332.trc: ORA-00600:internal error code,arguments:[3708], [910], [], [], [], [], [], [] Tue May 21 01:46:39 2002 SMON: enabling cache recovery SMON: enabling tx recovery NOTE Shutdown process took about 15 Minutes to Complete & gave this Error EXPLANATION By Oracle Corp. :- Basically this error is raised because LGWR timmed out. While shutdown, Oracle routine (kcttsc()) sends a message to LGWR to change the state of a redo thread and waits for confirmation. If the return message never comes, then LGWR times out after 15 minutes which is the second argument in the ora-600 (910 secs ie. 15mins.) In the situation we faced , lgwr had RT enqueue and waiting for 'direct path read' on file 197. Becuase of some OS issues the read took more than 15 minutes and lgwr gave a timeout. There is a workaround to keep a underscore init parameter to overcome any OS issues and tell lgwr to wait for more time. But this is suggested only after checking OS for any performance issues. SOLUTION / Suggestion by Oracle Corp :- - Remove the REDO log files from RAID5 - Check OS & H/W, RAID for any performance issues specifically during that time. GENERAL INFO :- log_buffer = 4M (High Volume OLTP / Batch Transactions 3 Million in a 5 Hours Window Exist) Size of online Redo Logfile = 500M ( Is This Excessive ?) Logfiles are Multiplexed . All Datafiles & Online Redo logfiles Exist on a SINGLE RAID 5 Volume All Hard Disks Clubbed into a Single RAID 5 Volume Storage Box = HP having VXFS Filesystems mounted thereon even though O.S. = Solaris 8 Any Advice for approach / resolution ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
