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 SMON event enq: RO - fast object reuse

437959Oct 7 2008
version is 10.2.0.4 on Linux x86-64
default temporary tablespace is temp, alive and well

we sqlldr into staging tables, process the data and drop the staging table
sometimes CKPT blocks SMON on event enqueue RO - fast object reuse
row wait file# and block# point to a temporary segment in the tablespace used for staging tables
from dba_segments, segment name is 70.5087, header_file is 70, header block is 5087, segment_type is temporary
the datafile 70 is in the tablespace for our staging tables

this blocking session hangs indefinitely

how can I break this deadlock?

thanks in advance,

Peter
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2008
Added on Oct 7 2008
#general-database-discussions
0 comments
321 views