Re: Problem ( ORA-03113) when dropping user with drop user cascade

From: Lorenzo del Río <lorenzo_del_rio_at_hotmail.com>
Date: 18 Mar 2002 01:49:13 -0800
Message-ID: <e4dbd2e9.0203180149.76dd3ab@posting.google.com>

Ron Reidy <rereidy_at_indra.com> wrote in message news:<3C91FE83.9F3C38AB_at_indra.com>...
> Lorenzo del Río wrote:
> >
> > When trying to drop an user in an Oracle 8.1.6 database with no
> > materialized views I do:
> > drop user xxxx cascade;
> >
> > And I get the error ORA-03113 (end of communication channel).
> >
> > Doing the same with other users in the database caused no problem.
> >
> > Anyone can help?. Thanks.
> What did the alert log say?

Ron:

The alert log says:
Errors in file /opt/app/oracle/product/8.1.6/rdbms/log/ora_14163_sigre.trc: ORA-00600: internal error code, arguments: [15266], [], [], [], [], [], [], []

At the end of the post you can find some pieces of the trace file (I have choosen the parts that make some sens to me).

The problem seems to be related to a trigger. Currently it seems that the drop user has worked to some extent, as tables and triggers for the user being dropped cannot be seen in the all_tables or all_triggers views, but although the trigger cannot be seen in the all_triggers view if I try to drop it manuall y I do not receive the message 'trigger do not exist', I receive the same message that appears in the trace file (ORA-00600: internal error code, arguments: [15266], [], [], [], [], [], [], ).

Thanks a lot for your interest.

Lorenzo.

The referenced trace file says:
ump file /opt/app/oracle/product/8.1.6/rdbms/log/ora_14163_sigre.trc Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option
JServer Release 8.1.6.0.0 - Production
ORACLE_HOME = /opt/app/oracle/product/8.1.6 System name: HP-UX

Node name:      idcux03
Release:        B.11.00
Version:        A
Machine:        9000/800

Instance name: sigre
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 14163, image: oracle_at_idcux03 (TNS V1-V3)

SESSION ID:(11.1349) 2002-03-18 10:09:53.583
2002-03-18 10:09:53.583 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [15266], [], [], [], [], [], [], [] Current SQL statement for this session: drop trigger TR_S_6324_1_EMPLEADOS ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- --------------------
ksedmp + 164 ???? ksedst 155C3B0 ? B5C10CA3 ? AA784FE4 ? AA78501F ? ksfdmp + 32 ???? ksedmp 7BFF5928 ? 7BFF590C ? 1 ? 400A7460 ? ksfdmp + 8 ???? ksfdmp 400061E4 ? C653E198 ? 0 ? 2 ? kgeasi + 148 ???? kgeriv 10 ? 40066C80 ? 1546130 ? 21 ? kkdllk + 1680 ???? kgeasi 400054C0 ? 400A7460 ? 3BA2 ? 2 ? kktlktrg + 532 ???? kkdllk 7BFF5644 ? 2A69 ? 2 ? 7BFF57BC ? kktdrp + 80 ???? kktlktrg 3D ? 1 ? 40004DF0 ? 72FFF ? opiexe + 12044 ???? kktdrp 7BFF53B0 ? 7BFF422C ? ----- Argument/Register Address Dump ----- Argument/Register addr=155c3b0. Dump of memory from 0x155C370 to 0x155C4B0 155C370 4F52415F 4E50495F 4552524F 52000000 [ORA_NPI_ERROR...] 155C380 46617461 6C20496E 7465726E 616C2045 [Fatal Internal E] 155C390 72726F72 20256420 696E2070 726F6365 [rror %d in proce] 155C3A0 73732025 73000000 55534552 00000000 [ss %s...USER....] 155C3B0 6B736564 6D703A20 696E7465 726E616C [ksedmp: internal] 155C3C0 206F7220 66617461 6C206572 726F720A [ or fatal error.] 155C3D0 00000000 00000000 3D3D3D3D 3D3D3D3D [........========] 155C3E0 3D3D3D3D 3D3D3D3D 3D3D3D3D 3D3D3D3D [================] Repeat 1 times 155C400 3D3D3D3D 3D3D3D3D 3D3D3D0A 00000000 [===========.....] 155C410 46696C65 73206375 7272656E 746C7920 [Files currently ] 155C420 6F70656E 65642062 79207468 69732070 [opened by this p] 155C430 726F6365 73733A0A 00000000 00000000 [rocess:.........] 155C440 6B736564 6D703A20 6E6F2063 75727265 [ksedmp: no curre] 155C450 6E742063 6F6E7465 78742061 7265610A [nt context area.] 155C460 00000000 00000000 76657273 696F6E20 [........version ] 155C470 6E756D62 65720000 6B736574 73746400 [number..ksetstd.] 155C480 4B534554 53544400 3D3D3D3D 3D3D3D3D [KSETSTD.========] 155C490 3D3D3D3D 3D3D3D3D 3D3D3D3D 3D3D3D3D [================] 155C4A0 3D3D3D3D 3D3D3D3D 0A000000 00000000 [========........] Argument/Register addr=7bff5928. Dump of memory from 0x7BFF58E8 to 0x7BFF5A28 7BFF58E0 7BFBE780 0072DD0F [{....r..] 7BFF58F0 00000005 40016E78 400A3EB0 7BFB7AFA [....@.nx@.>.{.z.] 7BFF5900 400BF3E0 0000009A 00000300 400BF3E6 [@...........@...] 7BFF5910 C6B69E20 00000000 C68E41B8 C72A8DB0 [... ......A..*..] 7BFF5920 C72BFB78 C653D074 C653D048 00000000 [.+.x.S.t.S.H....] 7BFF5930 00000000 00000000 00000000 00000000 [................] Repeat 2 times 7BFF5960 40066C80 7BFF5688 00000000 C6F5EFC0 [@.l.{.V.........] 7BFF5970 40005534 0000002F 00802064 08000000 [@.U4.../.. d....] 7BFF5980 400B17F8 00000000 7BFF5944 C63F4FA0 [@.......{.YD.?O.] 7BFF5990 00000000 00000000 00000001 7BFCB648 [............{..H] 7BFF59A0 7BFF59D8 00000000 40016DC0 7BFF59D8 [{.Y.....@.m.{.Y.] 7BFF59B0 00000020 0000002F C01FBEBB 7BFF7600 [... .../....{.v.]

.......................
......................

0006250 00000000 00000000 00000000 4007659A  [............@.e.]
40006260 00000000 00000000 00000000 00000000  [................]
40006270 00000000 00000000 00000000 000001AC  [................]
40006280 63757273 6F720000 00000000 00000000  [cursor..........]
40006290 00000000 00000000 00000000 00000000  [................]
400062A0 4006D7CA 4006D7D2 00000000 00000000  [@...@...........]
400062B0 00000000 00000000 00000000 00000000  [................]
400062C0 00000058 4B4F4B41 206F7065 6E206375  [...XKOKA open cu]
400062D0 72736F72 00000000 00000000 00000000  [rsor............]
400062E0 00000000                             [....]

Argument/Register addr=c653e198.

..............
...............
...............

Dump of memory from 0x15460F0 to 0x1546230

15460F0 25346420 4F66663D 25346420 436F6D6D  [%4d Off=%4d Comm]
1546100 3D25730A 00000000 503A2053 697A653D  [=%s.....P: Size=]
1546110 25356420 5365673D 25346420 4F66663D  [%5d Seg=%4d Off=]
1546120 25346420 436F6D6D 3D25730A 00000000  [%4d Comm=%s.....]
1546130 6672616D 65207365 676D656E 74000000  [frame segment...]
1546140 6672616D 65207365 676D656E 74656420  [frame segmented ]
1546150 61727261 79000000 20206E78 743A2000  [array...  nxt: .]
1546160 4152523A 20256420 2F202564 00000000  [ARR: %d / %d....]
1546170 25642E30 78253038 6C780000 00000000  [%d.0x%08lx......]
1546180 0A000000 00000000 63757273 6F72203A  [........cursor :]
1546190 206B6B73 616C6300 63757273 6F72203A  [ kksalc.cursor :]
15461A0 206B6B73 616C7800 73716C20 61726561  [ kksalx.sql area]
15461B0 00000000 00000000 63757273 6F722063  [........cursor c]
15461C0 68696C64 00000000 7461626C 655F2578  [hild....table_%x]
15461D0 5F25785F 25785F25 785F2578 5F257800  [_%x_%x_%x_%x_%x.]
15461E0 63747864 6566203A 206B6B73 6C6F6400  [ctxdef : kkslod.]
15461F0 54797065 63686563 6B206865 61702064  [Typecheck heap d]
1546200 65736372 6970746F 72000000 00000000  [escriptor.......]
1546210 54797065 63686563 6B206865 61700000  [Typecheck heap..]
1546220 63747820 696E206B 6B736C6F 64000000  [ctx in kkslod...]

Argument/Register addr=400054c0.
Dump of memory from 0x40005480 to 0x400055C0

....................
...................
..................

Files currently opened by this process:

PROCESS STATE

Process global information:

process: c63a4448, call: c63f4fa0, xact: c650cee0, curses: c63be3f8, usrses: c63be3f8

SO: c63a4448, type: 1, owner: 0, flag: INIT/-/-/0x00 (process) Oracle pid=8, calls cur/top: c63f4fa0/c63f4fa0, 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: c63b5a08 O/S info: user: oracle, term: UNKNOWN, ospid: 14163 OSD pid info: 14163

SO: c63be3f8, type: 3, owner: c63a4448, flag: INIT/-/-/0x00 (session) trans: c650cee0, creator: c63a4448, flag: (41) USR/- BSY/-/-/-/-/-
DID: 0000-0000-00000000, short-term DID: 0000-0000-00000000

              txn branch: 0
              oct: 61, prv: 0, user: 84/SIGRENEW

O/S info: user: oracle, term: pts/td, ospid: 14161, machine: idcux03

program: sqlplus_at_idcux03 (TNS V1-V3) application name: SQL*Plus, hash value=3669949024 last wait for 'SQL*Net message from client' blocking sess=0x0 seq=83 wait_time=-2

                driver id=54435000, #bytes=1, =0
      ----------------------------------------
      SO: c650cee0, type: 23, owner: c63be3f8, flag: INIT/-/-/0x00
      (trans) bsn = 221, flg = 0x200001, flg2 = 0x00, prx = 0x0, ros =
2147483647, spn = 223
      efd = 9
      parent xid: 0x0000.000.00000000
      env: (scn: 0x0000.00000000  xid: 0x0000.000.00000000  uba:
0x00000000.0000.00)
      cev: (spc = 0  usi = 2147483647  ubk tsn: 0 rdba: 0x00000000 
useg tsn: 0 rdba: 0x00000000
           hwm uba: 0x00000000.0000.00  col uba: 0x00000000.0000.00
            num bl: 0 bk list: 0x0)
      (enqueue) <no resource>
      res: 0, prv: 0, sess: 0
        xga: 0x0, heap: UGA
      ----------------------------------------
      SO: c6567d20, type: 33, owner: c63be3f8, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=c6567d20 handle=c6945188 mode=N
      call pin=c6568d90 session pin=0
      user=c63be3f8 session=c63be3f8 count=1 flags=[00] savepoint=136
      LIBRARY OBJECT HANDLE: handle=c6945188
      name=SYS.DBMS_APPLICATION_INFO
      hash=fcfd1282 timestamp=03-14-2002 13:20:02
      namespace=BODY/TYBD flags=TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0011-0011 lock=N pin=0 latch=0
      lwt=c69451a0[c69451a0,c69451a0] ltm=c69451a8[c69451a8,c69451a8]
      pwt=c69451b8[c69451b8,c69451b8] ptm=c6945210[c6945210,c6945210]
      ref=c6945190[c6945190,c6945190]
        LIBRARY OBJECT: object=c68cc518
        type=PKBD flags=EXS/LOC[0005] pflags=NST/SWR [09] status=VALD
load=0
        DEPENDENCIES: count=2 size=16
        ACCESSES: count=1 size=16
        DATA BLOCKS:
        data#     heap  pointer status pins change
        ----- -------- -------- ------ ---- ------
            0 c68cc728 c68cc600 I/-/A     0 NONE
            4 c68cc5b0 c69487e8 I/-/A     0 NONE
      ----------------------------------------
      SO: c656bfe0, type: 33, owner: c63be3f8, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=c656bfe0 handle=c703c2e8 mode=N
      call pin=c656d028 session pin=0
      user=c63be3f8 session=c63be3f8 count=1 flags=[00] savepoint=136
      LIBRARY OBJECT HANDLE: handle=c703c2e8
      name=SYS.DBMS_APPLICATION_INFO
      hash=fcfd1281 timestamp=03-14-2002 13:19:24
      namespace=TABL/PRCD/TYPE flags=TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0215-0215 lock=N pin=0 latch=2
     pwt=c703c318[c703c318,c703c318] ptm=c703c370[c703c370,c703c370]
      ref=c703c2f0[c68be778,c68cc698]
        LIBRARY OBJECT: object=c6d5fc30
        type=PCKG flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
        DEPENDENCIES: count=1 size=16
        DATA BLOCKS:
        data#     heap  pointer status pins change
        ----- -------- -------- ------ ---- ------
            0 c6d593d8 c6d5fd18 I/-/A     0 NONE
            2 c6d5fcc8 c7179900 I/-/A     0 NONE
            4 c6b83ad8 c6fbaff0 I/-/A     0 NONE
            9 c6b83a78 c718f9a0 I/-/A     0 NONE
      ----------------------------------------
      SO: c6565bd0, type: 33, owner: c63be3f8, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=c6565bd0 handle=c7180a60 mode=N
      call pin=c6566be8 session pin=0
      user=c63be3f8 session=c63be3f8 count=1 flags=[00] savepoint=109
      LIBRARY OBJECT HANDLE: handle=c7180a60
      name=SYS.DBMS_OUTPUT
      hash=5e736e8a timestamp=03-14-2002 13:20:20
      namespace=BODY/TYBD flags=TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0011-0011 lock=N pin=0 latch=1
      lwt=c7180a78[c7180a78,c7180a78] ltm=c7180a80[c7180a80,c7180a80]
      pwt=c7180a90[c7180a90,c7180a90] ptm=c7180ae8[c7180ae8,c7180ae8]
      ref=c7180a68[c7180a68,c7180a68]
        LIBRARY OBJECT: object=c6b68dd8
        type=PKBD flags=EXS/LOC[0005] pflags=/SWR [08] status=VALD
load=0
        DEPENDENCIES: count=3 size=16
        ACCESSES: count=1 size=16
        DATA BLOCKS:
        data#     heap  pointer status pins change
        ----- -------- -------- ------ ---- ------
            0 c6b6aac0 c6b68ec0 I/-/A     0 NONE
            4 c6b68e70 c675ef50 I/-/A     0 NONE
      ----------------------------------------
      SO: c6567be0, type: 33, owner: c63be3f8, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=c6567be0 handle=c700d818 mode=N
    call pin=c6568958 session pin=0
      user=c63be3f8 session=c63be3f8 count=1 flags=[00] savepoint=109
      LIBRARY OBJECT HANDLE: handle=c700d818
      name=SYS.DBMS_OUTPUT
      hash=5e736e89 timestamp=03-14-2002 13:19:27
      namespace=TABL/PRCD/TYPE flags=TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0215-0215 lock=N pin=0 latch=0
      lwt=c700d830[c700d830,c700d830] ltm=c700d838[c700d838,c700d838]
      pwt=c700d848[c700d848,c700d848] ptm=c700d8a0[c700d8a0,c700d8a0]
      ref=c700d820[c6b68f58,c6ffa960]
        LIBRARY OBJECT: object=c6e2f2b8
        type=PCKG flags=EXS/LOC[0005] pflags=NST [01] status=VALD
load=0
        DEPENDENCIES: count=1 size=16
        DATA BLOCKS:
        data#     heap  pointer status pins change
        ----- -------- -------- ------ ---- ------
            0 c6e2f4c8 c6e2f3a0 I/-/A     0 NONE
            2 c6e2f350 c6e660d0 I/-/A     0 NONE
            4 c67f5958 c6b1ea38 I/-/A     0 NONE
            9 c67f58f8 c67f5608 I/-/A     0 NONE
      ----------------------------------------
      SO: c6567d60, type: 33, owner: c63be3f8, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=c6567d60 handle=c734b9a8 mode=N
      call pin=c65689e8 session pin=0
      user=c63be3f8 session=c63be3f8 count=1 flags=CBB/[02]
savepoint=93
      LIBRARY OBJECT HANDLE: handle=c734b9a8
      name=SYS.DATABASE
      hash=aea96fa0 timestamp=12-31-4712 23:59:59
      namespace=EVNT flags=TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=0
      lwt=c734b9c0[c734b9c0,c734b9c0] ltm=c734b9c8[c734b9c8,c734b9c8]
      pwt=c734b9d8[c734b9d8,c734b9d8] ptm=c734ba30[c734ba30,c734ba30]
      ref=c734b9b0[c734b9b0,c734b9b0]
        LIBRARY OBJECT: object=c67dd568
        type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
        DATA BLOCKS:
        data#     heap  pointer status pins change          0 c67dd778
c67dd650 I/-/A     0 NONE
            3 c67dd600 c67fb250 I/-/A     0 NONE
      ----------------------------------------
      SO: c656bea0, type: 33, owner: c63be3f8, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=c656bea0 handle=c7025040 mode=N
      call pin=c656cec0 session pin=0
      user=c63be3f8 session=c63be3f8 count=1 flags=CBB/[02]
savepoint=93
      LIBRARY OBJECT HANDLE: handle=c7025040
      name=SIGRENEW.SIGRENEW
      hash=c0caf470 timestamp=12-31-4712 23:59:59
      namespace=EVNT flags=TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=2
      lwt=c7025058[c7025058,c7025058] ltm=c7025060[c7025060,c7025060]
      pwt=c7025070[c7025070,c7025070] ptm=c70250c8[c70250c8,c70250c8]
      ref=c7025048[c7025048,c7025048]
        LIBRARY OBJECT: object=c6dfc670
        type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
        DATA BLOCKS:
        data#     heap  pointer status pins change
        ----- -------- -------- ------ ---- ------
            0 c6dfc880 c6dfc758 I/-/A     0 NONE
            3 c6dfc708 c68b9ac8 I/-/A     0 NONE
      ----------------------------------------
      SO: c6c88b38, type: 32, owner: c63be3f8, flag: INIT/-/-/0x00
      user lock: lock=c6c88b38 mode=S
      user resource: user=c656f108 uid=84 mode=S
      ----------------------------------------
      SO: c6b951b8, type: 32, owner: c63be3f8, flag: INIT/-/-/0x00
      user lock: lock=c6b951b8 mode=S
      user resource: user=c656f108 uid=84 mode=S
    ----------------------------------------

SO: c644d8c0, type: 9, owner: c63a4448, flag: INIT/-/-/0x00 (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: c63a4448,

                       event: 20, last message event: 20, messages
read: 0
                       channel: (c644e178) system events broadcast
channel
                                scope: 101, event: 20, last mesage
event: 0,
                                publishers/subscribers: 0/7,
   ----------------------------------------

SO: c63f4fa0, type: 2, owner: c63a4448, flag: INIT/-/-/0x00 (call) sess: cur c63be3f8, rec c63bdbb8, usr c63be3f8; depth: 0

      SO: c653d048, type: 30, owner: c63f4fa0, flag: INIT/-/-/0x00
      row cache enqueue: count=1 session=c63be3f8 object=c72bfb78,
mode=S
      row cache parent object: address=c72bfb78 type=7(dc_users)
      transaction=0 mode=S flags=0001
      status=EMPTY/-/-/-/-/-/-/-
      set=0, complete=FALSE
      set=1, complete=FALSE
      data=
      00000052 00000000 00000000 00000000 00000000 00000000 00000000
00000000
      00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
      00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
      00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
      00000000 00000000 00000000 00000000
      ----------------------------------------
      SO: c653d074, type: 30, owner: c63f4fa0, flag: INIT/-/-/0x00
      row cache enqueue: count=1 session=c63be3f8 object=c72a8db0,
mode=S
      row cache parent object: address=c72a8db0 type=11(dc_object_ids)
      transaction=0 mode=S flags=0002
      status=VALID/-/-/-/-/-/-/-
      data=
      00002a69 00002a69 00000052 0008434f 4e544143 544f0000 00000000
00000000
      00000000 00000000 00000000 01000000 00000000 00000000 00000000
00000000
      00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
      00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
      00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
      00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
      00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
      00000000 00000000 00000000 00000000 00000000
      ----------------------------------------
      SO: c63bdbb8, type: 3, owner: c63f4fa0, flag: INIT/-/-/0x00
      (session) trans: 0, creator: 0, flag: (2) -/REC -/-/-/-/-/-
                DID: 0000-0000-00000000, short-term DID:
0000-0000-00000000
                txn branch: 0
                oct: 0, prv: 0, user: 0/SYS

URRENT SESSION'S INSTANTIATION STATE

current session=c63be3f8

INSTANTIATION OBJECT: object=400ab698
type="PL/SQL"[0] lock=c6567d20 handle=c6945188 spec=400ab740 level=0 flags=SHR/BDY/FST[63] executions=3
REST OF INSTANTIATION OBJECT:
address=400ab6e4 size=72
00000019 400ab740 40004658 00000000 400bdd00 00000000 00000014 00140000
c6948900 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000

INSTANTIATION OBJECT: object=400ab740
type="PL/SQL"[0] lock=c656bfe0 handle=c703c2e8 body=400ab698 level=0 flags=SHR/[01] executions=6
REST OF INSTANTIATION OBJECT:
address=400ab78c size=72
ffffffff 400ab740 40004658 00000000 400af360 00000000 00000013 00130000
c6fbb108 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000

INSTANTIATION OBJECT: object=400ae998
type="PL/SQL"[0] lock=c6565bd0 handle=c7180a60 spec=400ab7e8 level=0 flags=SHR/BDY/FST[63] executions=1
REST OF INSTANTIATION OBJECT:
address=400ae9e4 size=72
ffffffff 400ab7e8 40004658 00000000 400b9a40 00000000 00000012 00120000
c675f068 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000 00000000

INSTANTIATION OBJECT: object=400ab7e8
type="PL/SQL"[0] lock=c6567be0 handle=c700d818 body=400ae998 level=0 flags=SHR/[41] executions=2
REST OF INSTANTIATION OBJECT:
address=400ab834 size=72
ffffffff 400ab7e8 40004658 00000000 400b0928 00000000 00000011 00110000
c6b1eb50 00000000 00000000 00000000 00000000 00000000 00000000 00000000

INSTANTIATION OBJECT: object=400ad2c0
type="KOKA open cursor"[3] lock=0 handle=0 body=0 level=0 flags=FST[60] executions=0
REST OF INSTANTIATION OBJECT:
address=400ad30c size=12
00000000 00000005 0000000a

INSTANTIATION OBJECT: object=400ad258
type="KOKA pseudo cursor"[4] lock=0 handle=0 body=0 level=0 flags=FST[60] executions=0
REST OF INSTANTIATION OBJECT:
address=400ad2a4 size=12
00000000 00000005 0000000a

INSTANTIATION OBJECT: object=400ac0c8
type="cursor"[2] lock=400b16e8 handle=400b15e8 body=0 level=0 flags=CGA/FST[70] executions=0

********************   Cursor Dump   ************************

Current cursor: 1, pgadep: 0

pgactx: 400bcda0 ctxcbk: 400bf378 ctxqbc: 400bc150 ctxrws: 0 Cursor Dump:

Cursor 1 (400a9a78): CURBOUND curiob: 400ac0c8 curflg: 4c curpar: 0 curusr: 0 curses c63be3f8 cursor name: drop trigger TR_S_6324_1_EMPLEADOS child pin: 400b1280, child lock: 400b1240, parent lock: 400b16e8 xscflg: 802064, parent handle: 400b15e8, xscfl2: 400 nxt: 1.0x000000a8
Cursor frame allocation dump:
frm: -------- Comment -------- Size Seg Off End of cursor dump

***************** dump of cursor xsc=400ac0c8 **********************
................

..............

.................

HEAP DUMP heap name="sql area" desc=0x400bcf78 extent sz=0x1028 alt=32767 het=32767 rec=0 flg=2 opc=5 parent=40004dc8 owner=0 nex=0 xsz=0x0
EXTENT 0

  Chunk 400bf368 sz=      136    perm      "perm           "  alo=136
400BF360                   50000089 00000000          [P.......]

400BF370 400BCD90 00000088 400BF3E0 400BF3C0 [@.......@...@...]

400BF380 00000000 00000000 00000000 00000000  [................]
        Repeat 3 times
400BF3C0 0000000D 00155452 5F535F36 3332345F  [......TR_S_6324_]

400BF3D0 315F454D 504C4541 444F5300 00000000 [1_EMPLEADOS.....] 400BF3E0 00000000 00085349 4752454E 45570000 [......SIGRENEW..] EXTENT 1

  Chunk 400bc118 sz=     3032    recreate  "Typecheck heap "  latch=0
     ds 400bcd00 sz=     3032 ct=        1
400BC110                   80000BD9 00000000          [........]
...............

.............

.................
********************   Cursor Dump   ************************

Current cursor: 1, pgadep: 0

pgactx: 400bcda0 ctxcbk: 400bf378 ctxqbc: 400bc150 ctxrws: 0 Cursor Dump:

***************** dump of cursor xsc=400ac0c8 **********************
.........
...........
...............
..................
......................
.........................

Received on Mon Mar 18 2002 - 03:49:13 CST