Any time you get an ORA-600 error, you call Oracle Support. It's an
untrapped error in the Oracle kernel itself, and that is more commonly known
as a bug. They're the only people who can really help.
Regards
HJR
--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================
"Lorenzo del Río" <lorenzo_del_rio_at_hotmail.com> wrote in message
news:e4dbd2e9.0203180149.76dd3ab_at_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:
> ----------------------------------------
> 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 **********************
> .........
> ...........
> ...............
> ..................
> ......................
> .........................
Received on Mon Mar 18 2002 - 11:47:00 CST
