Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what is ORA$AT_SQ_SQL_SW_1055 does?

ski123Aug 8 2012 — edited Aug 9 2012
Oracle 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.
This post has been answered by vlethakula on Aug 8 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2012
Added on Aug 8 2012
4 comments
4,021 views