Scheduler log table too large
Hello,
in my db the tables SYS.SCHEDULER$_EVENT_LOG, SYS.SCHEDULER$_JOB_RUN_DETAILS became too large due to the big log of a chain job in loop.
in my db the tables SYS.SCHEDULER$_EVENT_LOG, SYS.SCHEDULER$_JOB_RUN_DETAILS became too large due to the big log of a chain job in loop.
I removed the big log and now I'd like to release the exceeding space of the two table.
May I use these commands
alter table SYS.SCHEDULER$_EVENT_LOG enable row movement;
alter table SYS.SCHEDULER$_EVENT_LOG shrink space;
even if the tables are used by scheduler?
Thank in advance,
Alessio Rossi
0