Is PMON still rolling back ?

[khussain]

We are on 9.2.0.2 on TRU64 UNIX.

I was deleting about 6 million rows, but I had to kill the process because more resources were required for some other processing.

First I killed the process from Oracle, and then did a kill -9 from UNIX.

Where do I look to see if PMON is still rolling back, or is it done ?
Since the process is gone, I dont have any info on it.

I guess what I am looking for is to see if there is any rolling-back PMON is doing.

[julian]

Originally posted by khussain
We are on 9.2.0.2 on TRU64 UNIX.

I was deleting about 6 million rows, but I had to kill the process because more resources were required for some other processing.

First I killed the process from Oracle, and then did a kill -9 from UNIX.

Where do I look to see if PMON is still rolling back, or is it done ?
Since the process is gone, I dont have any info on it.

I guess what I am looking for is to see if there is any rolling-back PMON is doing.

Check v$fast_start_transactions and Note 144332.1

[Mr.Hanky]

This might be a job for orakill

http://www.dbazine.com/moore3.shtml

MH