session id
Hi All,
Some batch job caused ORA-03113.so how to track the session and any step to resolve the issue
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]
*** SESSION ID:(1309.43800) 2011-06-23 10:24:47.639
ORA-03113: end-of-file on communication channel Dump of memory fromDump 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]
0