Error in alert log: sys.mon_mods$ "DROP_SEGMENTS": invalid identifier
Posted on 2011-05-03
We are having some peformance issues in an Oracle database V188.8.131.52.0.
We had to recreate the Oracle Alert Log due to its size 3 days ago.
When looking into this alert log now, it displays this error every 10 seconds (and nothing else but this error):
Tue May 03 11:17:59 2011
Errors in file d:\oracle\admin\v8\bdump\v_smon_5816.trc:
ORA-00904: "DROP_SEGMENTS": invalid identifier
By looking at the solutions, I can see the cause of it: column drop_segments missing from sys.mon_mods$.
I wonder if this error can also be the cause of a performance issue?
Thanks and Kind Regards