Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CKPT blocks session that dropped table with EXECUTE IMMEDIATE

437959Jan 28 2009 — edited Jan 29 2009
RDBMS 10.2.0.4 on Linux RHEL5 Update 2 x86-64
init param RECYCLE_BIN=off

this is an intermittent problem
a session that drops a table is blocked by CKPT indefinitely; the table is dropped but the session is not allowed to end
wait event is enq: RO - fast object reuse

If we kill the blocked session then CKPT blocks SMON

So far the only way we have found to clear the system is to bounce the instance
We have changed the PL/SQL to include "Purge"
execute immediate 'drop table <mytable> purge'

Any ideas on how to deal with this

thanks in advance,

Peter
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2009
Added on Jan 28 2009
#general-database-discussions
5 comments
4,178 views