Re: Table Locking Problem

Graeme, Mark

As per my understanding:- when you kill a process its status appear to be as killed but the process is actually cleaned by SMON. SMON cleans up processes at regular intervals (which is around 3 minutes). Cant remember the parameter that sets smon timings (if any).

you can perhaps try to write some shell script in unix that will trigger smon process thereby clearing up the process.

s_c_99_at_hotmail.com

Graeme Farmer wrote:
>
> 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