We recently upgraded one of our databases from Oracle 9 to Oracle 10. The connection to this database from the Spotlight monitor causes the following trace to be generated over and over:
----------------------------------------
That database has the event initialization parameter set to "4030 trace name errorstack forever, level 10:6502 trace name errorstack forever, level 12:3113 trace name errorstack level 3:3114 trace name errorstack level 3" which is causing Oracle to create a trace file every time an ORA-06502 error is generated.
WORKAROUND
Try putting the following in the spotlight.ora (located at C:\Program Files\Quest Software\Spotlight\Plug-ins\SoO)...
Note: May need to re-evaluate whether this setting in the initialization parameter file is intentional as this is normally something set to track down an issue rather than permanently having it on. If it is required, then the workaround mentioned in this solution should resolve the issue.
