ALTER TABLE ... SHRINK and enq: KO - fast object checkpoint
11.2.0.2 DB, with Dataguard on RHEL 5
I hit a problem doing an ALTER TABLE <MYTABLE> SHRINK SPACE CASCADE COMPACT
where most other sessions ended up waiting on enq: KO - fast object checkpoint
The other sessions were not querying the table that was being shrunk, but the average wait was between 1 and 2 minutes.
I killed the shrink when it was about half way through (after about 2 hours), and the other sessions immediately went back to normal.
The table being shrunk is 80GB, and I'd just deleted 31m of the 32m rows that had been in it.
I've raised an SR, but wondered if anyone else had seen anything similar.
I hit a problem doing an ALTER TABLE <MYTABLE> SHRINK SPACE CASCADE COMPACT
where most other sessions ended up waiting on enq: KO - fast object checkpoint
The other sessions were not querying the table that was being shrunk, but the average wait was between 1 and 2 minutes.
I killed the shrink when it was about half way through (after about 2 hours), and the other sessions immediately went back to normal.
The table being shrunk is 80GB, and I'd just deleted 31m of the 32m rows that had been in it.
I've raised an SR, but wondered if anyone else had seen anything similar.
0