Re: Table Locking Problem

From: Graeme Farmer <g_farmer_at_halas.com.au>
Date: 2000/04/19
Message-ID: <HB5L4.4087$E4.8562@newsfeeds.bigpond.com>#1/1

Mark,

It definately took a lot longer for Oracle to release the lock on the table than it did to lock it. As for the user process I did check it and it was still there as KILLED but I wouldn't know if the serial# was changing.

Can you, or anyone else, answer the question as to what Oracle was doing when I issued the shutdown immediate command and throughout 15 minutes there was zero CPU/DISK activity? Surely if the db wasn't shutting down due to the locks being removed there would be some CPU activity as the locks were being removed.
Ta,
Graeme. Received on Wed Apr 19 2000 - 00:00:00 CDT