Skip to Main Content

Database Software

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!

Looking for information on scheduler table SCHEDULER$_SAVED_OIDS

user7237490May 4 2020 — edited Jul 7 2020

I'm looking for information on scheduler table SCHEDULER$_SAVED_OIDS.  This table and PK index are consuming 2.5 G of a 3G system tablespace.  I've already executed the scheduler purge with no effect.   Is there a init parameter to control the size of this table?  Does oracle provide a script/job to purge this table?  Can the data be deleted or can the table be truncated?

Comments

Post Details

Added on May 4 2020
11 comments
381 views