Re: Regarding SHUTDOWN Options

From: HansF <News.Hans_at_telus.net>
Date: Tue, 28 Mar 2006 20:04:08 GMT
Message-Id: <pan.2006.03.28.20.04.17.222201@telus.net>

On Tue, 28 Mar 2006 10:22:28 -0800, Giridhar wrote:

> Hi,
> while reading Fundamentals certification guide, i read the following
> question.
>
> while shutdown option will waits for users to complete their
> uncommitted transactions?
> Answer given is "Shutdown Transactional."
>
> Wont "Shutdown NORMAL" also wait for the users to complete their
> transactions?

Yes. And wait a bit longer as well - committing or rolling back a transaction does not imply the user has released their session.

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231/start.htm#sthref573

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***

Received on Tue Mar 28 2006 - 14:04:08 CST