Re: Can't shutdown immediate ??

> Let's get things straigt here:
> Shutdown comes in three flavors
> -normal : waits for everything to complete and users to log off and then
> shuts down.
> -immediate : disallows new logons, and waits for active jobs/queries to
> complete (does NOT abort/rollback running queries) and then shuts down.

According to Oracle documentation:

"Immediate database shutdown proceeds with the following conditions:

Current client SQL statements being processed by Oracle are terminated immediately.
Any uncommitted transactions are rolled back. (If long uncommitted transactions exist, this method of shutdown might not complete quickly, despite its name.)
Oracle does not wait for users currently connected to the database to disconnect; Oracle implicitly rolls back active transactions and disconnects all connected users. "

So a shutdown immediate does not wait for active jobs/queries to complete. Any uncommitted active transactions are rolled back.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================