ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] ...

Mon Oct 21 17:37:21 2013

Errors in file /oracle/admin/orcl/udump/orcl_ora_7485.trc:

ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] [Address not mapped to object] [0x000000018] [] []

*** SERVICE NAME:(orcl) 2013-10-21 17:37:21.705

*** SESSION ID:(429.9319) 2013-10-21 17:37:21.705

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x18, PC: [0x3c3ef01, kgghstfel()+15]

*** 2013-10-21 17:37:21.777

ksedmp: internal or fatal error

ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] [Address not mapped to object] [0x000000018] [] []

Current SQL statement for this session:

 select count(*)  from user$ u, xdb.xdb$schema s  where u.user# = :1  and   u.name  = s.xmldata.schema_owner  and  (xdb.xdb$Extname2Intname(s.xmldata.schema_url, s.xmldata.schema_owner) = :2)

----- PL/SQL Call Stack -----

  object      line  object

  handle    number  name

0xf23af1c0         1  function XDB.XDB$EXTNAME2INTNAME

0xf21c2e28         1  anonymous block

0xe8d3b758        17  package body SYS.XML_SCHEMA_NAME_PRESENT

----- Call Stack Trace -----

calling              call     entry                argument values in hex      

location             type     point                (? means dubious value)     

-------------------- -------- -------------------- ----------------------------

Cannot find symbol

Cannot find symbol

Cannot find symbol

ksedst()+31          call     ksedst1()            000000001 ? 000000001 ?

                                                   000000000 ? 000000000 ?

                                                   000000000 ? 000000001 ?

ksedmp()+610         call     ksedst()             000000001 ? 000000001 ?

                                                   000000000 ? 000000000 ?

                                                   000000000 ? 000000001 ?

ssexhd()+630         call     ksedmp()             000000003 ? 000000001 ?

                                                   000000000 ? 000000000 ?

                                                   000000000 ? 000000001 ?

<0x396380dd40>       call     ssexhd()             00000000B ? 2AAAAC79CD70 ?

                                                   2AAAAC79CC40 ? 000000000 ?

                                                   000000000 ? 000000001 ?

 

--------------------- Binary Stack Dump ---------------------

...

...

...

----- End of Call Stack Trace -----

===================================================

PROCESS STATE

-------------

Process global information:

     process: 0xf371bc78, call: 0xead82998, xact: (nil), curses: 0xf3997780, usrses: 0xf3997780

  ----------------------------------------

  SO: 0xf371bc78, type: 2, owner: (nil), flag: INIT/-/-/0x00

  (process) Oracle pid=329, calls cur/top: 0xead82998/0xead8b470, flag: (0) -

            int error: 0, call error: 0, sess error: 0, txn error 0

  (post info) last post received: 0 0 0

              last post received-location: No post

              last process to post me: none

              last post sent: 0 0 0

              last post sent-location: No post

              last process posted by me: none

    (latch info) wait_event=0 bits=0

    Process Group: DEFAULT, pseudo proc: 0xf3771200

    O/S info: user: oracle, term: UNKNOWN, ospid: 7485

    OSD pid info: Unix process pid: 7485, image: oracleorcl@localhost.localdomain

Dump of memory from 0x00000000F36637F8 to 0x00000000F3663A00

0F36637F0                   00000006 00000000          [........]

0F3663800 EAC86600 00000000 00000010 0003139D  [.f..............]

0F3663810 EAD8B470 00000000 00000003 0003139D  [p...............]

0F3663820 F3D25D58 00000000 0000000B 0003139D  [X]..............]

0F3663830 F3997780 00000000 00000004 00031291  [.w..............]

0F3663840 F0580E18 00000000 00000007 0003139D  [..X.............]

0F3663850 F0580EF8 00000000 00000007 0003139D  [..X.............]

0F3663860 00000000 00000000 00000000 00000000  [................]

  Repeat 25 times

    (FOB) flags=2 fib=0xf09d84b0 incno=0 pending i/o cnt=0

     fname=/oracle/oradata/orcl/system02.dbf

     fno=17 lblksz=4 fsiz=86309856

    (FOB) flags=2 fib=0xf09d4a50 incno=0 pending i/o cnt=0

     fname=/oracle/oradata/orcl/system01.dbf

     fno=1 lblksz=4 fsiz=86309856

    ----------------------------------------

    SO: 0xf3997780, type: 4, owner: 0xf371bc78, flag: INIT/-/-/0x00

    (session) sid: 429 trans: (nil), creator: 0xf371bc78, flag: (8000041) USR/- BSY/-/-/-/-/-

              DID: 0001-0149-000001AC, short-term DID: 0000-0000-00000000

              txn branch: (nil)

              oct: 3, prv: 0, sql: 0xf29a2938, psql: 0xf221c6f8, user: 0/SYS

    O/S info: user: zyw, term: DELL-PC, ospid: 6528:6828, machine: WORKGROUP\DELL-PC

              program: plsqldev.exe

    application name: plsqldev.exe, hash value=0

    last wait for 'latch: shared pool' blocking sess=0x(nil) seq=249 wait_time=121 seconds since wait started=0

                address=600e3d08, number=d5, tries=1

    Dumping Session Wait History

     for 'latch: shared pool' count=1 wait_time=121

                address=600e3d08, number=d5, tries=1

     for 'latch: shared pool' count=1 wait_time=10

                address=600e3d08, number=d5, tries=0

     for 'latch: shared pool' count=1 wait_time=5

                address=600e3d08, number=d5, tries=0

     for 'latch: shared pool' count=1 wait_time=941

                address=600e3d08, number=d5, tries=0

     for 'latch: shared pool' count=1 wait_time=14

                address=600e3d08, number=d5, tries=0

     for 'latch: library cache' count=1 wait_time=6

                address=eff3e460, number=d6, tries=0

     for 'latch: shared pool' count=1 wait_time=127

                address=600e3d08, number=d5, tries=0

     for 'latch: shared pool' count=1 wait_time=107

                address=600e3d08, number=d5, tries=0

     for 'latch: shared pool' count=1 wait_time=93

                address=600e3d08, number=d5, tries=0

     for 'latch: shared pool' count=1 wait_time=80

                address=600e3d08, number=d5, tries=0

    temporary object counter: 0

      ----------------------------------------

      Virtual Thread:

      kgskvt: 0xf27439b0, sess: 0xf3997780, vc: (nil), proc: 0xf371bc78

      consumer group cur: OTHER_GROUPS (upd? 0), mapped: DEFAULT_CONSUMER_GROUP, orig: 

      vt_state: 0x200, vt_flags: 0x30, blkrun: 0

      is_assigned: 1, in_sched: 0 (0)

      vt_active: 0 (pending: 1)

      used quanta: 0 (cg: 0)

      cpu start time: 0, quantum status: 0x0

      quantum checks to skip: 0, check thresh: 0

      idle time: 0, active time: 0 (cg: 0)

      cpu yields: 0 (cg: 0), waits: 0 (cg: 0), wait time: 0 (cg: 0)

      queued time outs: 0, time: 0 (cur 0, cg 0)

      calls aborted: 0, num est exec limit hit: 0

      undo current: 0k max: 0k

      ----------------------------------------

      UOL used : 0

      KGX Atomic Operation Log 0xe8eaab60

       Mutex (nil)(0, 0) idn 0 oper NONE

       Cursor Parent uid 429 efd 47 whr 13 slp 0

       oper=NONE pt1=0xecb43998 pt2=0xecb43a00 pt3=(nil)

       pt4=(nil) u41=0 stt=0

      KGX Atomic Operation Log 0xe8eaaba8

       Mutex 0xf27c3c78(0, 1) idn 0 oper NONE

       Cursor Stat uid 429 efd 65 whr 1 slp 0

       oper=NONE pt1=0xf27c3b48 pt2=(nil) pt3=(nil)

       pt4=(nil) u41=0 stt=8

      KGX Atomic Operation Log 0xe8eaabf0

       Mutex (nil)(0, 0) idn 0 oper NONE

       Cursor Stat uid 429 efd 0 whr 0 slp 0

       oper=NONE pt1=(nil) pt2=(nil) pt3=(nil)

       pt4=(nil) u41=0 stt=0

      ----------------------------------------

      SO: 0xea838cc0, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00

      LIBRARY OBJECT LOCK: lock=ea838cc0 handle=f250d200 mode=N

      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000

      htl=0xea838d40[0xedad6b88,0xedad6b88] htb=0xedad6b88 ssga=0xedad5f30

      user=f3997780 session=f3997780 count=0 flags=LRU/[4000] savepoint=0x1ad1

      LIBRARY OBJECT HANDLE: handle=f250d200 mutex=0xf250d330(0)

      name=XDB.XDB$DERIVATIONCHOICE 

      hash=835b639a7ca7231b761b05003b2e12b5 timestamp=10-22-2005 22:08:23

      namespace=TABL flags=KGHP/TIM/SML/[02000000]

      kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0714 hlc=0714

      lwt=0xf250d2a8[0xf250d2a8,0xf250d2a8] ltm=0xf250d2b8[0xf250d2b8,0xf250d2b8]

      pwt=0xf250d270[0xf250d270,0xf250d270] ptm=0xf250d280[0xf250d280,0xf250d280]

      ref=0xf250d2d8[0xf250d2d8,0xf250d2d8] lnd=0xf250d2f0[0xe8d6f0e8,0xf23e9358]

        LIBRARY OBJECT: bject=e7927780

        type=TYPE flags=EXS/LOC[0005] pflags=/PRP[0080] status=VALD load=0

        DEPENDENCIES: count=1 size=16

        DATA BLOCKS:

        data#     heap  pointer    status pins change whr

        ----- -------- -------- --------- ---- ------ ---

            0 f25e3170 e79278d8 I/-/A/-/-    0 NONE   00 

            6 e7927a30 e71f73f0 I/-/A/-/-    0 NONE   00 

      ----------------------------------------

      SO: 0xdedf1980, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00

      LIBRARY OBJECT LOCK: lock=dedf1980 handle=f25de0f8 mode=N

      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000

      htl=0xdedf1a00[0xedad6238,0xedad6238] htb=0xedad6238 ssga=0xedad5f30

      user=f3997780 session=f3997780 count=0 flags=LRU/[4000] savepoint=0x1ad1

      LIBRARY OBJECT HANDLE: handle=f25de0f8 mutex=0xf25de228(0)

      name=XDB.XDB$XMLTYPE_REF_LIST_T 

      hash=4bfe6f9a3d8968775b28533e119ffd20 timestamp=10-22-2005 22:08:23

      namespace=TABL flags=KGHP/TIM/SML/[02000000]

      kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=4 hpc=08ec hlc=08ec

      lwt=0xf25de1a0[0xf25de1a0,0xf25de1a0] ltm=0xf25de1b0[0xf25de1b0,0xf25de1b0]

      pwt=0xf25de168[0xf25de168,0xf25de168] ptm=0xf25de178[0xf25de178,0xf25de178]

      ref=0xf25de1d0[0xf25de1d0,0xf25de1d0] lnd=0xf25de1e8[0xe8186688,0xf21ff290]

        LIBRARY OBJECT: bject=e7a945d0

        type=TYPE flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0

        DEPENDENCIES: count=2 size=16

        ACCESSES: count=1 size=16

        DATA BLOCKS:

        data#     heap  pointer    status pins change whr

        ----- -------- -------- --------- ---- ------ ---

            0 e8dd70b8 e7a94728 I/-/A/-/-    0 NONE   00 

            6 e7a94160 e43d1000 I/-/A/-/-    0 NONE   00 

      ----------------------------------------

      SO: 0xedd40158, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00

      LIBRARY OBJECT LOCK: lock=edd40158 handle=f22c6b70 mode=N

      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000

      htl=0xedd401d8[0xedad6cc8,0xedad6cc8] htb=0xedad6cc8 ssga=0xedad5f30

      user=f3997780 session=f3997780 count=0 flags=LRU/[4000] savepoint=0x1ad1

      LIBRARY OBJECT HANDLE: handle=f22c6b70 mutex=0xf22c6ca0(0)

      name=XDB.XDB$UNION_T 

      hash=458611b793105ccdb7148290ba3993c9 timestamp=10-22-2005 22:08:24

      namespace=TABL flags=KGHP/TIM/SML/[02000000]

      kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=00d0 hlc=00d0

      lwt=0xf22c6c18[0xf22c6c18,0xf22c6c18] ltm=0xf22c6c28[0xf22c6c28,0xf22c6c28]

      pwt=0xf22c6be0[0xf22c6be0,0xf22c6be0] ptm=0xf22c6bf0[0xf22c6bf0,0xf22c6bf0]

      ref=0xf22c6c48[0xf22c6c48,0xf22c6c48] lnd=0xf22c6c60[0xe8255e00,0xe83d3b28]

        LIBRARY OBJECT: bject=ecdb2f90

        type=TYPE flags=EXS/LOC[0005] pflags=/PRP[0080] status=VALD load=0

        DEPENDENCIES: count=4 size=16

        ACCESSES: count=3 size=16

        DATA BLOCKS:

        data#     heap  pointer    status pins change whr

        ----- -------- -------- --------- ---- ------ ---

            0 e8329028 ecdb30e8 I/-/A/-/-    0 NONE   00 

            6 ecdb2bd8 e7d29e78 I/-/A/-/-    0 NONE   00 

      ----------------------------------------

      SO: 0xeef22950, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00

      LIBRARY OBJECT LOCK: lock=eef22950 handle=e8285d40 mode=N

      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000

      htl=0xeef229d0[0xedad6a38,0xedad6a38] htb=0xedad6a38 ssga=0xedad5f30

      user=f3997780 session=f3997780 count=0 flags=LRU/[4000] savepoint=0x1ad1

      LIBRARY OBJECT HANDLE: handle=e8285d40 mutex=0xe8285e70(0)

      name=XDB.XDB$QNAME 

      hash=0dd4ddb94dedc16622c112ff2f4dfca0 timestamp=10-22-2005 22:08:23

      namespace=TABL flags=KGHP/TIM/SML/[02000000]

      kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=2 hpc=0dc0 hlc=0dc0

      lwt=0xe8285de8[0xe8285de8,0xe8285de8] ltm=0xe8285df8[0xe8285df8,0xe8285df8]

      pwt=0xe8285db0[0xe8285db0,0xe8285db0] ptm=0xe8285dc0[0xe8285dc0,0xe8285dc0]

      ref=0xe8285e18[0xe8285e18,0xe8285e18] lnd=0xe8285e30[0xf26feb50,0xe8286040]

        LIBRARY OBJECT: bject=e723cae8

        type=TYPE flags=EXS/LOC[0005] pflags=/PRP[0080] status=VALD load=0

        DEPENDENCIES: count=1 size=16

        DATA BLOCKS:

        data#     heap  pointer    status pins change whr

        ----- -------- -------- --------- ---- ------ ---

            0 f279ba88 e723cc40 I/-/A/-/-    0 NONE   00 

            6 e723cd98 ec8989a0 I/-/A/-/-    0 NONE   00 

      ----------------------------------------

      SO: 0xea796c30, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00

      LIBRARY OBJECT LOCK: lock=ea796c30 handle=f22c6d80 mode=N

      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000

      htl=0xea796cb0[0xedad67c8,0xedad67c8] htb=0xedad67c8 ssga=0xedad5f30

      user=f3997780 session=f3997780 count=0 flags=LRU/[4000] savepoint=0x1ad1

      LIBRARY OBJECT HANDLE: handle=f22c6d80 mutex=0xf22c6eb0(0)

      name=XDB.XDB$LIST_T 

      hash=9d0fb30f16e92c9e243a0be6729b7379 timestamp=10-22-2005 22:08:24

      namespace=TABL flags=KGHP/TIM/SML/[02000000]

      kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=3 hpc=0150 hlc=0150

      lwt=0xf22c6e28[0xf22c6e28,0xf22c6e28] ltm=0xf22c6e38[0xf22c6e38,0xf22c6e38]

      pwt=0xf22c6df0[0xf22c6df0,0xf22c6df0] ptm=0xf22c6e00[0xf22c6e00,0xf22c6e00]

      ref=0xf22c6e58[0xf22c6e58,0xf22c6e58] lnd=0xf22c6e70[0xe8cee7f8,0xf21695d0]

        LIBRARY OBJECT: bject=e7160e18

        type=TYPE flags=EXS/LOC[0005] pflags=/PRP[0080] status=VALD load=0

        DEPENDENCIES: count=4 size=16

        ACCESSES: count=4 size=16

        DATA BLOCKS:

        data#     heap  pointer    status pins change whr

        ----- -------- -------- --------- ---- ------ ---

            0 e82ace10 e7160f70 I/-/A/-/-    0 NONE   00 

            6 e7160a78 e73ec458 I/-/A/-/-    0 NONE   00 

      ---------------------------------------- 

      SO: 0xeddaf208, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00

      LIBRARY OBJECT LOCK: lock=eddaf208 handle=f2a86088 mode=N

      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000

      htl=0xeddaf288[0xedad6b98,0xedad7a10] htb=0xedad6b98 ssga=0xedad5f30

      user=f3997780 session=f384b1f8 count=1 flags=[0000] savepoint=0x14e2

      LIBRARY OBJECT HANDLE: handle=f2a86088 mutex=0xf2a861b8(5)

      name=

select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$ 

      hash=1d4a51a2c89ab6b07a3c64bebc5573b6 timestamp=09-10-2013 16:49:23

      namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/KST/DBN/MTX/[100100d4]

      kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=2 hpc=c8c6 hlc=c8c6

      lwt=0xf2a86130[0xf2a86130,0xf2a86130] ltm=0xf2a86140[0xf2a86140,0xf2a86140]

      pwt=0xf2a860f8[0xf2a860f8,0xf2a860f8] ptm=0xf2a86108[0xf2a86108,0xf2a86108]

      ref=0xf2a86160[0xf2a86160,0xf2a86160] lnd=0xf2a86178[0xf2a34a78,0xf2a9cb60]

        LIBRARY OBJECT: bject=ecf07178

        type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0

        CHILDREN: size=16

        child#    table reference   handle

        ------ -------- --------- --------

             0 ecf06c40  ecf068b0 f2a85e60

             1 ecf06c40  ecf06b50 f2a7c200

             2 ecf06c40  ecf88d38 f2a3e620

             3 ecf06c40  ecd64fa8 f24a7e80

             4 ecf06c40  e4228c28 e83237f0

             5 ecf06c40  e7a4dd60 e8c9d4b0

             6 ecf06c40  e7c111c8 e89bfe58

        DATA BLOCKS:

        data#     heap  pointer    status pins change whr

        ----- -------- -------- --------- ---- ------ ---

            0 f2a85fc8 ecf07290 I/P/A/-/-    0 NONE   00 

      ----------------------------------------

      SO: 0xedad7488, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00

      LIBRARY OBJECT LOCK: lock=edad7488 handle=e8997f10 mode=N

      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000

      htl=0xedad7508[0xedad6b58,0xea826e50] htb=0xedad6b58 ssga=0xedad5f30

      user=f3997780 session=f3997780 count=1 flags=[0000] savepoint=0x14d9

      LIBRARY OBJECT HANDLE: handle=e8997f10 mutex=0xe8998040(1)

      name=select value(p$) from "XDB"."XDB$ELEMENT"                 as of snapshot(:2) p$ where SYS_NC_OID$ = :1

      hash=7fe95d7e6f370b394c1f932d9b587ab2 timestamp=10-21-2013 10:41:57

      namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]

      kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=5 hpc=0002 hlc=0002

      lwt=0xe8997fb8[0xe8997fb8,0xe8997fb8] ltm=0xe8997fc8[0xe8997fc8,0xe8997fc8]

      pwt=0xe8997f80[0xe8997f80,0xe8997f80] ptm=0xe8997f90[0xe8997f90,0xe8997f90]

      ref=0xe8997fe8[0xe8997fe8,0xe8997fe8] lnd=0xe8998000[0xe8a9ed58,0xf26fed60]

        LIBRARY OBJECT: bject=e4d77b50

        type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0

        CHILDREN: size=16

        child#    table reference   handle

        ------ -------- --------- --------

             0 e78a8638  e78a82a8 f21fe830

        DATA BLOCKS:

        data#     heap  pointer    status pins change whr

        ----- -------- -------- --------- ---- ------ ---

            0 e81f1668 e4d77c68 I/P/A/-/-    0 NONE   00 

      ----------------------------------------