RE: Waiting for smon to disable tx recovery.

A number of things you could look at including Temporary Tablespace since this is often due to Temporary Tablespace issues also -  

1. Make sure no users are assigned the SYSTEM table space for Temporary table space usage
2. Look at your SGA size - try to limit it to be not greater than 30%-50% of your real memory (opinion on this varies)
3. Try the following order (assuming the you are able to shutdown with 'Shutdown abort):
   1. Shutdown abort
   2. Startup Restrict
   3. Shutdown immediate
   4. Do our backups f . Startup

(Just a side note - I have often read that a 'shutdown normal' is best before a backup - so that is what we do)  

4) If you have the Oracle Intelligent Agent, any other process, or monitoring tool running then close that process before your attempted shutdown.  

Please post the success/failure of all this.  

Vikram Khushalani
Oracle DBA

-----Original Message-----
From: Terrian, Thomas [mailto:Thomas.Terrian_at_standardregister.com] Sent: Thursday, June 15, 2000 7:55 AM
To: 'oracledba_at_quickdoc.co.uk'; 'ORACLE-L_at_fatcity.com' Subject: Waiting for smon to disable tx recovery.

Does anyone else see this in their alert log file when they bounce their database?:

Waiting for smon to disable tx recovery.

It is happening more and more at my site. Last night we got it 18 times. We do the following each night:

1.  Shutdown abort.
2.  Startup
3.  Shutdown immediate
4.  Do our backups
5.  Startup
 

We get the warning messages during step 3. Each time we get the message there is a 5 minute delay so it took us over an hour to bounce the database last night.  

AIX 4.3.2, Oracle 8.1.6.1.0  

Any ideas?

Tom Terrian
Oracle DBA Received on Thu Jun 15 2000 - 09:46:35 CDT