Issue with SYSTEM Tablespace Size in ebs 12.1

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Issue with SYSTEM Tablespace Size in ebs 12.1

Yahia
Hello Sir,

I have an issue with an excessive number of entries in the obj$ table:

SELECT COUNT(*) FROM obj$;
-- Result:
1312913423

Is there a method to correct this and purge data from the SYSTEM tablespace?
Could this be related to the cleanup_non_exist_obj purge process?

Regards,
Reply | Threaded
Open this post in threaded view
|

Re: Issue with SYSTEM Tablespace Size in ebs 12.1

ErmanArslansOracleBlog
Administrator