Re: Fourth shutdown option

It seems a little unlikely (.. Oracle 9 perhaps) as

    shutdown transactional
puts a share enqueue (mode 4) on each of the TX locks in turn until is terminates as a way of being notified at low cost that transactions are complete. Since there is no public facility for the same thing (select for update or wait 2 minutes for the lock) I suspect that the OEM thing is probably a double session:

    shutdown transactional in session 1
    shutdown immediate after N minutes in session 2.

I don't have OEM installed anywhere convenient to test this though.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison Wesley Longman
Book bound date now 1st Dec 2000

Van Messner wrote in message ...


>What made me think there was a timing element is the message in OEM when

 you


>select this option.

>

>Van

>

>