Database Administration (MOSC)

MOSC Banner

session id

edited Jun 24, 2011 1:38AM in Database Administration (MOSC) 3 commentsAnswered
 Hi All, Some batch job caused ORA-03113.so how to track the session and any step to resolve the issue

*** SESSION ID:(1309.43800) 2011-06-23 10:24:47.639

ORA-03113: end-of-file on communication channel Dump of memory from
Dump of memory from 0x0700000038A8CF68 to 0x0700000038A8DE11
700000038A8CF60                   57495448 20626174          [WITH bat]
700000038A8CF70 63685F72 756E2041 53202820 53454C45  [ch_run AS ( SELE]
700000038A8CF80 43542061 2E626174 63685F6B 65792C20  [CT a.batch_key, ]
700000038A8CF90 612E6C64 5F646566 6E5F6B65 792C2020  [a.ld_defn_key,  ]
700000038A8CFA0 20202020 20204445 434F4445 2028612E  [      DECODE (a.]
700000038A8CFB0 6C645F64 65666E5F 6B65792C 20202020  [ld_defn_key,    ]
700000038A8CFC0 20202020 20202020 20202020 312C2061  [            1, a]

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center