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:
----------------------------------------
*** ACTION NAME:() 2011-01-31 09:27:17.765
*** MODULE NAME:(Spotlight.exe) 2011-01-31 09:27:17.765
*** SERVICE NAME:(SYS$USERS) 2011-01-31 09:27:17.765
*** SESSION ID:(511.1966) 2011-01-31 09:27:17.765
*** 2011-01-31 09:27:17.765
ksedmp: internal or fatal error
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
Current SQL statement for this session:
SELECT p.name, --CloseCursor (1856332)
SUBSTR(quest_soo_pkg.translate_parameter(value),1,200) value,
NVL(quest_soo_pkg.translate_parameter(value), 0) num_value,
p.isdefault
FROM v$system_parameter p
UNION ALL
SELECT 'log_mode',
TO_CHAR(DECODE(log_mode,'ARCHIVELOG',1,0)) log_mode,
'' num_value,
'TRUE'
FROM v$database