Purging tables getting stuck?
Oracle 10.1.0.3 & 10.1.0.4 (Linux AMD64).
I have an often occurring problem on several Oracle SE platforms - a data management PL/SQL job that among other things, create new tables and drop old tables. Yeah I know this is not the best of ideas, but without partitioning this is the only way to create and maintain a sliding window period - by creating individual tables instead of adding new partitions...
Regularly, such a job will spin forever on a wait even called enq: RO - fast object reuse.
Metalink and Google searches have not turned up anything much. Nor has posting about the problem here... Seems like a pretty much unknown event.
Recently doing some stuff on an Oracle EE platform and I start to butt my head into this again.. and only when using the PURGE clause for the DROP TABLE statement. And that is exactly what those SE data management jobs do too - they drop and purge tables outside the sliding window period.
Thus it would seem that the problem is related to the PURGE clause.
Anyone with similar experiences or ideas as to what the underlaying problem can be? Any special disclaimers/technical issues raised via Metalink notes regarding the PURGE clause?
Thanks.