what is ORA$AT_SQ_SQL_SW_1055 does?
ski123Aug 8 2012 — edited Aug 9 2012Oracle 11.2. What is ORA$AT_SQ_SQL_SW_1055 does? it runs every day at 1pm. Sometimes, not always it caused errors like this:
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x10] [PC:0x115035E, kokscfac()+232] [flags: 0x0, count: 1]
Errors in file /oracle/xxx/xxxxx/trace/ORADEV_j001_31781.trc (incident=14994):
ORA-07445: exception encountered: core dump [kokscfac()+232] [SIGSEGV] [ADDR:0x10] [PC:0x115035E] [Address not mapped to object] []
Incident details in: xxxxxx/xxxxx/xxxxx_j001_31781_i14994.trc
Tue Aug 07 22:00:28 2012
*** 2012-08-07 22:00:24.869
*** SESSION ID:(157.2005) 2012-08-07 22:00:24.869
*** CLIENT ID:() 2012-08-07 22:00:24.869
*** SERVICE NAME:(SYS$USERS) 2012-08-07 22:00:24.869
*** MODULE NAME:(DBMS_SCHEDULER) 2012-08-07 22:00:24.869
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_1055) 2012-08-07 22:00:24.869
Dump continued from file: /oracle/xxxx/xxxx/trace/xxxx_j001_31781.trc
ORA-07445: exception encountered: core dump [kokscfac()+232] [SIGSEGV] [ADDR:0x10] [PC:0x115035E] [Address not mapped to object] []
I did research. It seems like the job ORA$AT_SQ_SQL_SW_1055 caused this problem. It this internal job and scheduled by Oracle production?
Any help would appreciate.
S.