This content has been marked as final. Show 3 replies
Are the results different if the log isn't the current one?
log 10 is current log for instance
You need to disable the thread, then you can drop the groups:
alter database disable thread 3;
It seems that Group 10 of Thread 3 is still used as its status is current.
Please try to do
And see whats the status for thread 3 and also verify if really thread 3 is now required.
alter system switch logfile; alter system checkpoint;
And you can always disable this thread if now required.