Database Administration (MOSC)

MOSC Banner

Recycling Object_id mechanism in 19.19

edited Apr 23, 2023 7:25PM in Database Administration (MOSC) 2 commentsAnswered

Hi all!

Released recently Oracle database 19.19 has Object_id recycling mechanism.

When max object_id in obj$ is close to max permitted value (about 4.3 billion) we can solve problem of potential database unfunctionality using

Mechanism to Recycle Database Object Identifiers (Doc ID 2923706.1)

For that purpose I was trying to build a test environment, but got some issues.

I cloned one of production databases into test. This database has current object_id equal to 3.2 billion. So for testing 19.19 recycling object_id feature I need to increase object_id by 1.1 billion. I developed scripts which created deferred segments tables, sequences and synonyms. After 10 days of running I was almost at object_id = 4.3 billion, and then decided to back-up test database. It was running in noarchivelog mode, so I stopped id. When I tried to start database after backup, I got hang. Reason was simple - 'alter database open' runs some recursive statements, which can not complete

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center