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!

Tablespace / Datafile Migration: enq: RO - fast object reuse

michael_kAug 5 2009 — edited Apr 20 2010

Hello!

I am migrating a (lot of) tables out of a (huge) tablespace into bigfile tablespaces one by one.

I am using SQL> alter table trullala move tablespace trullala_tbs;

In my test environments everything went fine. In the production system with 2 TB on structured data, I am facing a contention "enq: RO - fast object reuse". My session is blocked by a checkpoint-process.

Here are the technical data:
- Windows OS, Oracle 10.2.0.4, ARCHIVELOG, Backup by RMAN every day incrementally, Backup of Archivelogs every 3 h.

What does this enq-event mean?
How can I systematically avoid this?
What Information do I need to avoid these contentions?

Thank you for your help!

Sincerely

Michael_k

Locked Post

New comments cannot be posted to this locked post.

Locked on May 18 2010

Added on Aug 5 2009

#database, #general-database-discussions, #sql

5 comments

1,801 views