FATAL ERROR IN TWO-TASK SERVER: error = 12571 - Oracle Server

Database Administrator · #1 06-30-2004, 01:39 AM

Hi,
Yesterday I faced a problem when I inserting data through VB6
interface.
But It was hanging at the time of inserting data in database.But the
same insert query when I run through SQL* it is working
perfectly.After that I shutdown and restart my database instance.After
that from application end it is working fine.Today I check the
udump.There the .TRC file is telling..I am giving the details
below.What can be the problem.It is not a deadlock.Then what type of
error.Please explain me.
Regards
Arijit Chatterjee
================================================== ================
Dump file E:\Oracle\admin\heildb\udump\ORA02952.TRC
Tue Jun 29 16:25:41 2004
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.2 , CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.2 , CPU type 586
Instance name: heildb

Redo thread mounted by this instance: 1

Oracle process number: 27

Windows thread id: 2952, image: ORACLE.EXE

*** 2004-06-29 16:25:41.968
*** SESSION ID

24.155) 2004-06-29 16:25:41.968
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2004-06-29 16:25:41.968
ksedmp: internal or fatal error
Current SQL statement for this session:
Insert into transaction2(Voucherkey,VoucherNo,DateField,Narrat ion )
values(2,'',to_date('06/29/2004','MM-DD-YYYY'),'Cash Transferred ')
----- Call Stack Trace -----
calling call entry
argument values in hex
location type point
(? means dubious value)
-------------------- -------- --------------------
----------------------------
_ksedmp+a8 CALLrel _ksedst+0

AEE480
_opitsk+f50 CALLrel _ksedmp+0
2
_opiino+50c CALLrel _opitsk+0
0
_opiodr+506 CALLreg 00000000
3C 4

BAEFBFC
_opidrv+384 CALLrel _opiodr+0
3C 4

BAEFBFC

0
_sou2o+19 CALLrel _opidrv+0
_opimai+10c CALLrel _sou2o+0
_OracleThreadStart@4+49f CALLrel _opimai+0
2

BAEFE78
77E4A98D CALLreg 00000000
----- Argument/Register Address Dump -----
Argument/Register addr=baee480.
Dump of memory from 0xBAEE440 to 0xBAEE580
BAEE440 00000003 E647C400 6552211C 00000033 [......G..!Re3...]
BAEE450 00000000 FFFFFFFD 00000048 00000000 [........H.......]
BAEE460 00000000 00000000 0020EB90 00000000 [.......... .....]
BAEE470 0000001D 0BAEE48C 0041E204 00000001 [..........A.....]
BAEE480 00E191B4 00E191B4 00E191B4 00E191BC [................]
BAEE490 00E191B4 00E191B4 00E191B4 00E191B4 [................]
BAEE4A0 00E191BC 00000000 00000000 00000000 [................]
BAEE4B0 0020EB90 0BAEE568 0041F119 0BAEE4CC [.. .h.....A.....]
BAEE4C0 0000001C 0020EB90 00000002 2A2A2A0A [...... ......***]
BAEE4D0 30303220 36302D34 2039322D 323A3631 [ 2004-06-29 16:2]
BAEE4E0 31343A35 32332D25 2D252073 25207338 [5:41%-32s %-8s %]
BAEE4F0 7332332D 0BAE0020 60B16307 00000000 [-32s ....c.`....]
BAEE500 0000311B 45414220 38374546 25207300 [.1.. BAEFE78.s %]
BAEE510 7332332D 342D2520 0B000A73 0000311B [-32s %-4s....1..]
BAEE520 655221B4 00200033 00000000 00000000 [.!Re3. .........]
BAEE530 00000000 00000000 00000000 00000000 [................]
BAEE540 0BAEFFEC 00000000 0BAEFE78 00000000 [........x.......]
BAEE550 00000001 00000001 00000000 0BAEDCC8 [................]
BAEE560 00000003 0BAEE58C 00477F2D 0BAEE4A4 [........-.G.....]
BAEE570 00000000 0000311B 00211828 00000000 [.....1..(.!.....]
Argument/Register addr=baefbfc.
Dump of memory from 0xBAEFBBC to 0xBAEFCFC
BAEFBB0 00000020 [ ...]
BAEFBC0 77F42AC3 77E5AAA3 0BB24B00 60840538 [.*.w...w.K..8..`]
BAEFBD0 00000000 00000000 00000000 0BAEFBEC [................]
BAEFBE0 00000000 00000000 00000000 00000000 [................]
BAEFBF0 7FF9FC00 0BAEFC14 77E5AB09 0BAEFD85 [...........w....]
BAEFC00 FFFFFFFF 00000000 00000001 00000000 [................]
BAEFC10 77F4331F 77F42397 0BAEFFB8 00403154 [.3.w.#.w....T1@.]
BAEFC20 00000002 0BAEFE78 00000000 00000000 [....x...........]
BAEFC30 00E5908C 002145C0 77FC2340 77F5D0E7 [.....E!.@#.w...w]
BAEFC40 00000000 7FFDF000 00000000 00000024 [............$...]
BAEFC50 00000001 00000000 44414853 00000000 [........SHAD....]
BAEFC60 FFFF0000 00000002 011D88C0 00000000 [................]
BAEFC70 00000580 00000001 00000000 00000000 [................]
BAEFC80 00000070 FFFFFFFF FFFFFFFF 77F5D045 [p...........E..w]
BAEFC90 77F5D10F 00247578 71B21570 7FFDF000 [...wxu$.p..q....]
BAEFCA0 77FC23B4 0BAEFC40 00000000 0BAEFD0C [.#.w@...........]
BAEFCB0 77F45A34 77F8C7B0 FFFFFFFF 77F5D0E7 [4Z.w...w.......w]
BAEFCC0 77F4363F 77F5CEE5 0BAEFD30 00000000 [?6.w...w0.......]
BAEFCD0 00E5908C 00000000 00000000 00000000 [................]
BAEFCE0 00000000 00000000 00000000 00000000 [................]
BAEFCF0 00000000 00000000 7FFDF000 [............]
Argument/Register addr=baefe78.
Dump of memory from 0xBAEFE38 to 0xBAEFF78
BAEFE30 00000000 00000000 [........]
BAEFE40 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
BAEFE70 00000000 00000000 0BAEFD78 0BAEFD85 [........x.......]
BAEFE80 00000000 00000000 00000000 61726F2A [............*ora]
BAEFE90 77617073 65725F6E 5F796C70 6C696568 [spawn_reply_heil]
BAEFEA0 325F6264 2A323539 00000000 00000000 [db_2952*........]
BAEFEB0 00000000 00000000 00000000 00000000 [................]
Repeat 9 times
BAEFF50 804E3B5C 00000000 FF247700 F6614BFC [\;N......w$..Ka.]
BAEFF60 804E3B9A FF2478E0 F6614C30 804E3CB0 [.;N..x$.0La.. BAEFF70 FF247750 FF247750 [Pw$.Pw$.]
----- End of Call Stack Trace -----
================================================== =
Files currently opened by this process:
================================================== =
PROCESS STATE
-------------
Process global information:
process: 28a1a64, call: 0, xact: 2af6ee8, curses: 0, usrses:
28c9aec
----------------------------------------
SO: 28a1a64, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
(process) Oracle pid=27, calls cur/top: 0/29170f8, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 18
last post received-location: ksqrcl
last process to post me: 28a1414 30 0
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: 28b9eb0
O/S info: user: SYSTEM, term: SYSTEL1, ospid: 2952
OSD pid info: 2952
----------------------------------------
SO: 28c9aec, type: 3, owner: 28a1a64, pt: 0, flag: INIT/-/-/0x00
(session) trans: 2af6ee8, creator: 28a1a64, flag: (41) USR/-
-/-/-/-/-/-
DID: 0001-001B-00000002, short-term DID:
0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, user: 36/SCOTT
O/S info: user: SHANTA\Administrator, term: SYSTEL1, ospid:
3176:3584, machine: SHANTA\SYSTEL1
program: vb6.exe
last wait for 'SQL*Net break/reset to client' blocking sess=0x0
seq=306 wait_time=-2
driver id=54435000, break?=1, =0
----------------------------------------
SO: 2af6ee8, type: 25, owner: 28c9aec, pt: 0, flag:
INIT/-/-/0x00
(trans) bsn = 360, flg = 0x1e03, flg2 = 0x00, prx = 0x0, ros =
2147483647, spn = 367
efd = 5
parent xid: 0x0000.000.00000000
env: (scn: 0x0000.000c12b1 xid: 0x0003.025.00000036 uba:
0x008005e0.0013.34)
cev: (spc = 1962 usi = 3 ubk tsn: 1 rdba: 0x008005e0 useg
tsn: 1 rdba: 0x00800402
hwm uba: 0x008005e0.0013.34 col uba: 0x00000000.0000.00
num bl: 1 bk list: 0x2ae32a4)
(enqueue) TX-00030025-00000036 DID: 0001-001B-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 2979d00, mode: X, prv: 2979d08, sess: 28c9aec, proc:
28a1a64
xga: 0x0, heap: UGA
----------------------------------------
SO: 2ae32a4, type: 24, owner: 2af6ee8, pt: 0, flag: -/-/-/0x00
(List of Blocks) next index = 2
index savepoint itli buffer hint
--------------------------------------
0 363 1 0x 2a01054
1 366 2 0x 2a012fc
----------------------------------------
SO: 2acd28c, type: 22, owner: 2af6ee8, pt: 0, flag:
INIT/-/-/0x00
DML LOCK: tab=25979 flg=01 chi=0
his[0]: mod=3 spn=360
(enqueue) TM-0000657B-00000000 DID: 0001-001B-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 2979cb8, mode: SX, prv: 2979cc0, sess: 28c9aec, proc:
28a1a64
----------------------------------------
SO: 2bafc60, type: 36, owner: 28c9aec, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=2bafc60 handle=0 lock=2baef28
user=28c9aec session=28c9aec count=0 mask=0000 savepoint=358
flags=[00]
----------------------------------------
SO: 2baef28, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=2baef28 handle=5627dc0 mode=N
call pin=0 session pin=2bafc60
user=28c9aec session=28c9aec count=1 flags=[00] savepoint=357
LIBRARY OBJECT HANDLE: handle=5627dc0
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
lwt=5627dd8[5627dd8,5627dd8] ltm=5627de0[5627de0,5627de0]
pwt=5627df0[5627df0,5627df0] ptm=5627e48[5627e48,5627e48]
ref=5627dc8[5628210,5628210] lnd=5627e54[5627e54,5627e54]
LIBRARY OBJECT: object=5627b84
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=2 size=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 5627d50 56273b8 I/P/A 0 NONE
6 5627c18 5626398 I/-/A 0 NONE
----------------------------------------
SO: 2baeaf0, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=2baeaf0 handle=5627e7c mode=N
call pin=2bafca8 session pin=0
user=28c9aec session=28c9aec count=1 flags=[00] savepoint=357
LIBRARY OBJECT HANDLE: handle=5627e7c
name=
Insert into transaction2(Voucherkey,VoucherNo,DateField,Narrat ion )
values(2,'',to_date('06/29/2004','MM-DD-YYYY'),'Cash Transferred ')
hash=30bdef64 timestamp=06-29-2004 16:24:35
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
lwt=5627e94[5627e94,5627e94] ltm=5627e9c[5627e9c,5627e9c]
pwt=5627eac[5627eac,5627eac] ptm=5627f04[5627f04,5627f04]
ref=5627e84[5627e84,5627e84] lnd=5627f10[5627f10,5627f10]
LIBRARY OBJECT: object=5628088
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 5628244 5628210 5627dc0
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 5628290 562810c I/P/A 0 NONE
----------------------------------------
SO: 2bb02d8, type: 36, owner: 28c9aec, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=2bb02d8 handle=0 lock=2baedc0
user=28c9aec session=28c9aec count=0 mask=0000 savepoint=351
flags=[00]
----------------------------------------
SO: 2baedc0, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=2baedc0 handle=5748c5c mode=N
call pin=0 session pin=2bb02d8
user=28c9aec session=28c9aec count=1 flags=[00] savepoint=351
LIBRARY OBJECT HANDLE: handle=5748c5c
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
lwt=5748c74[5748c74,5748c74] ltm=5748c7c[5748c7c,5748c7c]
pwt=5748c8c[5748c8c,5748c8c] ptm=5748ce4[5748ce4,5748ce4]
ref=5748c64[5740a4c,5740a4c] lnd=5748cf0[5748cf0,5748cf0]
LIBRARY OBJECT: object=5748a44
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 574083c 5748804 I/P/A 0 NONE
6 5748ad8 573e980 I/-/A 0 NONE
----------------------------------------
SO: 2bae8d4, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=2bae8d4 handle=5748d18 mode=N
call pin=2baf510 session pin=0
user=28c9aec session=28c9aec count=1 flags=[00] savepoint=351
LIBRARY OBJECT HANDLE: handle=5748d18
name=Select max(VoucherKey) from transaction2
hash=5fb7057d timestamp=06-29-2004 15:00:31
namespace=CRSR flags=RON/KGHP/TIM/PN0/SML/[12010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
lwt=5748d30[5748d30,5748d30] ltm=5748d38[5748d38,5748d38]
pwt=5748d48[5748d48,5748d48] ptm=5748da0[5748da0,5748da0]
ref=5748d20[5748d20,5748d20] lnd=5748dac[5748dac,5748dac]
LIBRARY OBJECT: object=57408c4
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 5740a80 5740a4c 5748c5c
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 5740acc 5740948 I/P/A 0 NONE
----------------------------------------
SO: 2bb3e4c, type: 36, owner: 28c9aec, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=2bb3e4c handle=575c244 mode=S
lock=2baedfc
user=28c9aec session=28c9aec count=1 mask=0041 savepoint=343
flags=[00]
----------------------------------------
SO: 2baedfc, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=2baedfc handle=575c244 mode=N
call pin=0 session pin=2bb3e4c
user=28c9aec session=28c9aec count=1 flags=PNS/[08]
savepoint=343
LIBRARY OBJECT HANDLE: handle=575c244
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch=0
lwt=575c25c[575c25c,575c25c] ltm=575c264[575c264,575c264]
pwt=575c274[575c274,575c274] ptm=575c2cc[575c2cc,575c2cc]
ref=575c24c[575c308,575c308] lnd=575c2d8[575c2d8,575c2d8]
LIBRARY OBJECT: object=575c02c
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 575d6c0 575bdec I/P/A 0 NONE
6 575c0c0 575b968 I/P/A 1 NONE
----------------------------------------
SO: 2baf900, type: 36, owner: 28c9aec, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=2baf900 handle=0 lock=2baea78
user=28c9aec session=28c9aec count=0 mask=0000 savepoint=193
flags=[00]
----------------------------------------
SO: 2baea78, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=2baea78 handle=575c244 mode=N
call pin=0 session pin=2baf900
user=28c9aec session=28c9aec count=1 flags=[00] savepoint=193
LIBRARY OBJECT HANDLE: handle=575c244
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch=0
lwt=575c25c[575c25c,575c25c] ltm=575c264[575c264,575c264]
pwt=575c274[575c274,575c274] ptm=575c2cc[575c2cc,575c2cc]
ref=575c24c[575c308,575c308] lnd=575c2d8[575c2d8,575c2d8]
LIBRARY OBJECT: object=575c02c
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 575d6c0 575bdec I/P/A 0 NONE
6 575c0c0 575b968 I/P/A 1 NONE
----------------------------------------
SO: 2bb53e8, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=2bb53e8 handle=575f5fc mode=N
call pin=2bb3dbc session pin=0
user=28c9aec session=28c9aec count=2 flags=[00] savepoint=193
LIBRARY OBJECT HANDLE: handle=575f5fc
name=select AccountMaster.*, AccountMaster."ROWID" from
AccountMaster order by accountcode
hash=94670588 timestamp=06-29-2004 11:05:39
namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
lwt=575f614[575f614,575f614] ltm=575f61c[575f61c,575f61c]
pwt=575f62c[575f62c,575f62c] ptm=575f684[575f684,575f684]
ref=575f604[575f604,575f604] lnd=575f690[575f690,575f690]
LIBRARY OBJECT: object=575f44c
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 575c4d4 575c308 575c244
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 575d720 575f4d0 I/P/A 0 NONE
----------------------------------------
SO: 2bb4fb0, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=2bb4fb0 handle=59ee220 mode=N
call pin=2bb3984 session pin=0
user=28c9aec session=28c9aec count=1 flags=CBB/[02] savepoint=76
LIBRARY OBJECT HANDLE: handle=59ee220
name=SYS.DATABASE
hash=aea96fa0 timestamp=12-31-4712 23:59:59
namespace=EVNT flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=0
lwt=59ee238[59ee238,59ee238] ltm=59ee240[59ee240,59ee240]
pwt=59ee250[59ee250,59ee250] ptm=59ee2a8[59ee2a8,59ee2a8]
ref=59ee228[59ee228,59ee228] lnd=59ee2b4[59ee2b4,59ee2b4]
LIBRARY OBJECT: object=59ee008
type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 59e8d04 59ee0ec I/-/A 0 NONE
3 59ee09c 59ede9c I/-/A 0 NONE
----------------------------------------
SO: 2bb4f38, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=2bb4f38 handle=57b6284 mode=N
call pin=2bb3aec session pin=0
user=28c9aec session=28c9aec count=1 flags=CBB/[02] savepoint=76
LIBRARY OBJECT HANDLE: handle=57b6284
name=SCOTT.SCOTT
hash=7727a61d timestamp=12-31-4712 23:59:59
namespace=EVNT flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=0
lwt=57b629c[57b629c,57b629c] ltm=57b62a4[57b62a4,57b62a4]
pwt=57b62b4[57b62b4,57b62b4] ptm=57b630c[57b630c,57b630c]
ref=57b628c[57b628c,57b628c] lnd=57b6318[57b6318,57b6318]
LIBRARY OBJECT: object=57b600c
type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 57b6214 57b60f0 I/-/A 0 NONE
3 57b60a0 57b5f1c I/-/A 0 NONE
----------------------------------------
SO: 57437c4, type: 34, owner: 28c9aec, pt: 0, flag:
INIT/-/-/0x00
user lock: lock=57437c4 mode=S
user resource: user=2bc2dd4 uid=36 mode=S
----------------------------------------
SO: 562ca14, type: 34, owner: 28c9aec, pt: 0, flag:
INIT/-/-/0x00
user lock: lock=562ca14 mode=S
user resource: user=2bc2dd4 uid=36 mode=S
----------------------------------------
SO: 29a2a24, type: 9, owner: 28a1a64, pt: 0, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 28a1a64,
event: 69, last message event: 69, messages
read: 0
channel: (29a3c2c) system events broadcast
channel
scope: 101, event: 69, last mesage
event: 0,
publishers/subscribers: 0/26,
messages published: 0
----------------------------------------
SO: 29170f8, type: 2, owner: 28a1a64, pt: 0, flag: INIT/-/-/0x00
(call) sess: cur 28c9aec, rec 0, usr 28c9aec; depth: 0
END OF PROCESS STATE

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

Database Administrator · #2 06-30-2004, 06:53 AM

arijitchatterjee123@yahoo.co.in (Arijit Chatterjee) wrote in message news:...
> Hi,
> Yesterday I faced a problem when I inserting data through VB6
> interface.
> But It was hanging at the time of inserting data in database.But the
> same insert query when I run through SQL* it is working
> perfectly.After that I shutdown and restart my database instance.After
> that from application end it is working fine.Today I check the
> udump.There the .TRC file is telling..I am giving the details
> below.What can be the problem.It is not a deadlock.Then what type of
> error.Please explain me.
> Regards

Ora-12571 is a network timeout. You didn't look up the error at all, did you?

Sybrand Bakker
Senior Oracle DBA

Database Administrator · #3 06-30-2004, 06:53 AM

arijitchatterjee123@yahoo.co.in (Arijit Chatterjee) wrote in message news:...
> Hi,
> Yesterday I faced a problem when I inserting data through VB6
> interface.
> But It was hanging at the time of inserting data in database.But the
> same insert query when I run through SQL* it is working
> perfectly.After that I shutdown and restart my database instance.After
> that from application end it is working fine.Today I check the
> udump.There the .TRC file is telling..I am giving the details
> below.What can be the problem.It is not a deadlock.Then what type of
> error.Please explain me.
> Regards

Ora-12571 is a network timeout. You didn't look up the error at all, did you?

Sybrand Bakker
Senior Oracle DBA

Database Administrator · #4 06-30-2004, 06:53 AM

arijitchatterjee123@yahoo.co.in (Arijit Chatterjee) wrote in message news:...
> Hi,
> Yesterday I faced a problem when I inserting data through VB6
> interface.
> But It was hanging at the time of inserting data in database.But the
> same insert query when I run through SQL* it is working
> perfectly.After that I shutdown and restart my database instance.After
> that from application end it is working fine.Today I check the
> udump.There the .TRC file is telling..I am giving the details
> below.What can be the problem.It is not a deadlock.Then what type of
> error.Please explain me.
> Regards

Ora-12571 is a network timeout. You didn't look up the error at all, did you?

Sybrand Bakker
Senior Oracle DBA

Database Administrator · #5 06-30-2004, 06:53 AM

arijitchatterjee123@yahoo.co.in (Arijit Chatterjee) wrote in message news:...
> Hi,
> Yesterday I faced a problem when I inserting data through VB6
> interface.
> But It was hanging at the time of inserting data in database.But the
> same insert query when I run through SQL* it is working
> perfectly.After that I shutdown and restart my database instance.After
> that from application end it is working fine.Today I check the
> udump.There the .TRC file is telling..I am giving the details
> below.What can be the problem.It is not a deadlock.Then what type of
> error.Please explain me.
> Regards

Ora-12571 is a network timeout. You didn't look up the error at all, did you?

Sybrand Bakker
Senior Oracle DBA

Database Administrator · #6 06-30-2004, 06:53 AM

arijitchatterjee123@yahoo.co.in (Arijit Chatterjee) wrote in message news:...
> Hi,
> Yesterday I faced a problem when I inserting data through VB6
> interface.
> But It was hanging at the time of inserting data in database.But the
> same insert query when I run through SQL* it is working
> perfectly.After that I shutdown and restart my database instance.After
> that from application end it is working fine.Today I check the
> udump.There the .TRC file is telling..I am giving the details
> below.What can be the problem.It is not a deadlock.Then what type of
> error.Please explain me.
> Regards

Ora-12571 is a network timeout. You didn't look up the error at all, did you?

Sybrand Bakker
Senior Oracle DBA

Database Administrator · #7 06-30-2004, 06:53 AM

arijitchatterjee123@yahoo.co.in (Arijit Chatterjee) wrote in message news:...
> Hi,
> Yesterday I faced a problem when I inserting data through VB6
> interface.
> But It was hanging at the time of inserting data in database.But the
> same insert query when I run through SQL* it is working
> perfectly.After that I shutdown and restart my database instance.After
> that from application end it is working fine.Today I check the
> udump.There the .TRC file is telling..I am giving the details
> below.What can be the problem.It is not a deadlock.Then what type of
> error.Please explain me.
> Regards

Ora-12571 is a network timeout. You didn't look up the error at all, did you?

Sybrand Bakker
Senior Oracle DBA

Database Administrator · #8 06-30-2004, 06:53 AM

arijitchatterjee123@yahoo.co.in (Arijit Chatterjee) wrote in message news:...
> Hi,
> Yesterday I faced a problem when I inserting data through VB6
> interface.
> But It was hanging at the time of inserting data in database.But the
> same insert query when I run through SQL* it is working
> perfectly.After that I shutdown and restart my database instance.After
> that from application end it is working fine.Today I check the
> udump.There the .TRC file is telling..I am giving the details
> below.What can be the problem.It is not a deadlock.Then what type of
> error.Please explain me.
> Regards

Ora-12571 is a network timeout. You didn't look up the error at all, did you?

Sybrand Bakker
Senior Oracle DBA

Database Administrator · #9 06-30-2004, 06:53 AM

arijitchatterjee123@yahoo.co.in (Arijit Chatterjee) wrote in message news:...
> Hi,
> Yesterday I faced a problem when I inserting data through VB6
> interface.
> But It was hanging at the time of inserting data in database.But the
> same insert query when I run through SQL* it is working
> perfectly.After that I shutdown and restart my database instance.After
> that from application end it is working fine.Today I check the
> udump.There the .TRC file is telling..I am giving the details
> below.What can be the problem.It is not a deadlock.Then what type of
> error.Please explain me.
> Regards

Ora-12571 is a network timeout. You didn't look up the error at all, did you?

Sybrand Bakker
Senior Oracle DBA

Database Administrator · #10 06-30-2004, 08:55 AM

This type of error (error = 1271) is a symptom of something else that
went wrong somewhere topside -- which could be any number of things.

See metalink for tips on how to trace thru this.

HTH.

arijitchatterjee123@yahoo.co.in (Arijit Chatterjee) wrote in message news:...
> Hi,
> Yesterday I faced a problem when I inserting data through VB6
> interface.
> But It was hanging at the time of inserting data in database.But the
> same insert query when I run through SQL* it is working
> perfectly.After that I shutdown and restart my database instance.After
> that from application end it is working fine.Today I check the
> udump.There the .TRC file is telling..I am giving the details
> below.What can be the problem.It is not a deadlock.Then what type of
> error.Please explain me.
> Regards
> Arijit Chatterjee
> ================================================== ================
> Dump file E:\Oracle\admin\heildb\udump\ORA02952.TRC
> Tue Jun 29 16:25:41 2004
> ORACLE V8.1.7.0.0 - Production vsnsta=0
> vsnsql=e vsnxtr=3
> Windows 2000 Version 5.2 , CPU type 586
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
> Windows 2000 Version 5.2 , CPU type 586
> Instance name: heildb
>
> Redo thread mounted by this instance: 1
>
> Oracle process number: 27
>
> Windows thread id: 2952, image: ORACLE.EXE
>
>
> *** 2004-06-29 16:25:41.968
> *** SESSION ID

24.155) 2004-06-29 16:25:41.968
> FATAL ERROR IN TWO-TASK SERVER: error = 12571
> *** 2004-06-29 16:25:41.968
> ksedmp: internal or fatal error
> Current SQL statement for this session:
> Insert into transaction2(Voucherkey,VoucherNo,DateField,Narrat ion )
> values(2,'',to_date('06/29/2004','MM-DD-YYYY'),'Cash Transferred ')
> ----- Call Stack Trace -----
> calling call entry
> argument values in hex
> location type point
> (? means dubious value)
> -------------------- -------- --------------------
> ----------------------------
> _ksedmp+a8 CALLrel _ksedst+0
>
> AEE480
> _opitsk+f50 CALLrel _ksedmp+0
> 2
> _opiino+50c CALLrel _opitsk+0
> 0
> _opiodr+506 CALLreg 00000000
> 3C 4
>
> BAEFBFC
> _opidrv+384 CALLrel _opiodr+0
> 3C 4
>
> BAEFBFC
>
> 0
> _sou2o+19 CALLrel _opidrv+0
> _opimai+10c CALLrel _sou2o+0
> _OracleThreadStart@4+49f CALLrel _opimai+0
> 2
>
> BAEFE78
> 77E4A98D CALLreg 00000000
> ----- Argument/Register Address Dump -----
> Argument/Register addr=baee480.
> Dump of memory from 0xBAEE440 to 0xBAEE580
> BAEE440 00000003 E647C400 6552211C 00000033 [......G..!Re3...]
> BAEE450 00000000 FFFFFFFD 00000048 00000000 [........H.......]
> BAEE460 00000000 00000000 0020EB90 00000000 [.......... .....]
> BAEE470 0000001D 0BAEE48C 0041E204 00000001 [..........A.....]
> BAEE480 00E191B4 00E191B4 00E191B4 00E191BC [................]
> BAEE490 00E191B4 00E191B4 00E191B4 00E191B4 [................]
> BAEE4A0 00E191BC 00000000 00000000 00000000 [................]
> BAEE4B0 0020EB90 0BAEE568 0041F119 0BAEE4CC [.. .h.....A.....]
> BAEE4C0 0000001C 0020EB90 00000002 2A2A2A0A [...... ......***]
> BAEE4D0 30303220 36302D34 2039322D 323A3631 [ 2004-06-29 16:2]
> BAEE4E0 31343A35 32332D25 2D252073 25207338 [5:41%-32s %-8s %]
> BAEE4F0 7332332D 0BAE0020 60B16307 00000000 [-32s ....c.`....]
> BAEE500 0000311B 45414220 38374546 25207300 [.1.. BAEFE78.s %]
> BAEE510 7332332D 342D2520 0B000A73 0000311B [-32s %-4s....1..]
> BAEE520 655221B4 00200033 00000000 00000000 [.!Re3. .........]
> BAEE530 00000000 00000000 00000000 00000000 [................]
> BAEE540 0BAEFFEC 00000000 0BAEFE78 00000000 [........x.......]
> BAEE550 00000001 00000001 00000000 0BAEDCC8 [................]
> BAEE560 00000003 0BAEE58C 00477F2D 0BAEE4A4 [........-.G.....]
> BAEE570 00000000 0000311B 00211828 00000000 [.....1..(.!.....]
> Argument/Register addr=baefbfc.
> Dump of memory from 0xBAEFBBC to 0xBAEFCFC
> BAEFBB0 00000020 [ ...]
> BAEFBC0 77F42AC3 77E5AAA3 0BB24B00 60840538 [.*.w...w.K..8..`]
> BAEFBD0 00000000 00000000 00000000 0BAEFBEC [................]
> BAEFBE0 00000000 00000000 00000000 00000000 [................]
> BAEFBF0 7FF9FC00 0BAEFC14 77E5AB09 0BAEFD85 [...........w....]
> BAEFC00 FFFFFFFF 00000000 00000001 00000000 [................]
> BAEFC10 77F4331F 77F42397 0BAEFFB8 00403154 [.3.w.#.w....T1@.]
> BAEFC20 00000002 0BAEFE78 00000000 00000000 [....x...........]
> BAEFC30 00E5908C 002145C0 77FC2340 77F5D0E7 [.....E!.@#.w...w]
> BAEFC40 00000000 7FFDF000 00000000 00000024 [............$...]
> BAEFC50 00000001 00000000 44414853 00000000 [........SHAD....]
> BAEFC60 FFFF0000 00000002 011D88C0 00000000 [................]
> BAEFC70 00000580 00000001 00000000 00000000 [................]
> BAEFC80 00000070 FFFFFFFF FFFFFFFF 77F5D045 [p...........E..w]
> BAEFC90 77F5D10F 00247578 71B21570 7FFDF000 [...wxu$.p..q....]
> BAEFCA0 77FC23B4 0BAEFC40 00000000 0BAEFD0C [.#.w@...........]
> BAEFCB0 77F45A34 77F8C7B0 FFFFFFFF 77F5D0E7 [4Z.w...w.......w]
> BAEFCC0 77F4363F 77F5CEE5 0BAEFD30 00000000 [?6.w...w0.......]
> BAEFCD0 00E5908C 00000000 00000000 00000000 [................]
> BAEFCE0 00000000 00000000 00000000 00000000 [................]
> BAEFCF0 00000000 00000000 7FFDF000 [............]
> Argument/Register addr=baefe78.
> Dump of memory from 0xBAEFE38 to 0xBAEFF78
> BAEFE30 00000000 00000000 [........]
> BAEFE40 00000000 00000000 00000000 00000000 [................]
> Repeat 2 times
> BAEFE70 00000000 00000000 0BAEFD78 0BAEFD85 [........x.......]
> BAEFE80 00000000 00000000 00000000 61726F2A [............*ora]
> BAEFE90 77617073 65725F6E 5F796C70 6C696568 [spawn_reply_heil]
> BAEFEA0 325F6264 2A323539 00000000 00000000 [db_2952*........]
> BAEFEB0 00000000 00000000 00000000 00000000 [................]
> Repeat 9 times
> BAEFF50 804E3B5C 00000000 FF247700 F6614BFC [\;N......w$..Ka.]
> BAEFF60 804E3B9A FF2478E0 F6614C30 804E3CB0 [.;N..x$.0La.. > BAEFF70 FF247750 FF247750 [Pw$.Pw$.]
> ----- End of Call Stack Trace -----
> ================================================== =
> Files currently opened by this process:
> ================================================== =
> PROCESS STATE
> -------------
> Process global information:
> process: 28a1a64, call: 0, xact: 2af6ee8, curses: 0, usrses:
> 28c9aec
> ----------------------------------------
> SO: 28a1a64, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
> (process) Oracle pid=27, calls cur/top: 0/29170f8, flag: (0) -
> int error: 0, call error: 0, sess error: 0, txn error 0
> (post info) last post received: 0 0 18
> last post received-location: ksqrcl
> last process to post me: 28a1414 30 0
> 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: 28b9eb0
> O/S info: user: SYSTEM, term: SYSTEL1, ospid: 2952
> OSD pid info: 2952
> ----------------------------------------
> SO: 28c9aec, type: 3, owner: 28a1a64, pt: 0, flag: INIT/-/-/0x00
> (session) trans: 2af6ee8, creator: 28a1a64, flag: (41) USR/-
> -/-/-/-/-/-
> DID: 0001-001B-00000002, short-term DID:
> 0000-0000-00000000
> txn branch: 0
> oct: 0, prv: 0, user: 36/SCOTT
> O/S info: user: SHANTA\Administrator, term: SYSTEL1, ospid:
> 3176:3584, machine: SHANTA\SYSTEL1
> program: vb6.exe
> last wait for 'SQL*Net break/reset to client' blocking sess=0x0
> seq=306 wait_time=-2
> driver id=54435000, break?=1, =0
> ----------------------------------------
> SO: 2af6ee8, type: 25, owner: 28c9aec, pt: 0, flag:
> INIT/-/-/0x00
> (trans) bsn = 360, flg = 0x1e03, flg2 = 0x00, prx = 0x0, ros =
> 2147483647, spn = 367
> efd = 5
> parent xid: 0x0000.000.00000000
> env: (scn: 0x0000.000c12b1 xid: 0x0003.025.00000036 uba:
> 0x008005e0.0013.34)
> cev: (spc = 1962 usi = 3 ubk tsn: 1 rdba: 0x008005e0 useg
> tsn: 1 rdba: 0x00800402
> hwm uba: 0x008005e0.0013.34 col uba: 0x00000000.0000.00
> num bl: 1 bk list: 0x2ae32a4)
> (enqueue) TX-00030025-00000036 DID: 0001-001B-00000002
> lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> res: 2979d00, mode: X, prv: 2979d08, sess: 28c9aec, proc:
> 28a1a64
> xga: 0x0, heap: UGA
> ----------------------------------------
> SO: 2ae32a4, type: 24, owner: 2af6ee8, pt: 0, flag: -/-/-/0x00
> (List of Blocks) next index = 2
> index savepoint itli buffer hint
> --------------------------------------
> 0 363 1 0x 2a01054
> 1 366 2 0x 2a012fc
> ----------------------------------------
> SO: 2acd28c, type: 22, owner: 2af6ee8, pt: 0, flag:
> INIT/-/-/0x00
> DML LOCK: tab=25979 flg=01 chi=0
> his[0]: mod=3 spn=360
> (enqueue) TM-0000657B-00000000 DID: 0001-001B-00000002
> lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
> res: 2979cb8, mode: SX, prv: 2979cc0, sess: 28c9aec, proc:
> 28a1a64
> ----------------------------------------
> SO: 2bafc60, type: 36, owner: 28c9aec, flag: INIT/-/-/0x00
> LIBRARY OBJECT PIN: pin=2bafc60 handle=0 lock=2baef28
> user=28c9aec session=28c9aec count=0 mask=0000 savepoint=358
> flags=[00]
> ----------------------------------------
> SO: 2baef28, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
> LIBRARY OBJECT LOCK: lock=2baef28 handle=5627dc0 mode=N
> call pin=0 session pin=2bafc60
> user=28c9aec session=28c9aec count=1 flags=[00] savepoint=357
> LIBRARY OBJECT HANDLE: handle=5627dc0
> namespace=CRSR flags=RON/KGHP/PN0/[10010000]
> kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
> lwt=5627dd8[5627dd8,5627dd8] ltm=5627de0[5627de0,5627de0]
> pwt=5627df0[5627df0,5627df0] ptm=5627e48[5627e48,5627e48]
> ref=5627dc8[5628210,5628210] lnd=5627e54[5627e54,5627e54]
> LIBRARY OBJECT: object=5627b84
> type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
> DEPENDENCIES: count=2 size=16
> ACCESSES: count=1 size=16
> TRANSLATIONS: count=1 size=16
> DATA BLOCKS:
> data# heap pointer status pins change
> ----- -------- -------- ------ ---- ------
> 0 5627d50 56273b8 I/P/A 0 NONE
> 6 5627c18 5626398 I/-/A 0 NONE
> ----------------------------------------
> SO: 2baeaf0, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
> LIBRARY OBJECT LOCK: lock=2baeaf0 handle=5627e7c mode=N
> call pin=2bafca8 session pin=0
> user=28c9aec session=28c9aec count=1 flags=[00] savepoint=357
> LIBRARY OBJECT HANDLE: handle=5627e7c
> name=
> Insert into transaction2(Voucherkey,VoucherNo,DateField,Narrat ion )
> values(2,'',to_date('06/29/2004','MM-DD-YYYY'),'Cash Transferred ')
> hash=30bdef64 timestamp=06-29-2004 16:24:35
> namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
> kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
> lwt=5627e94[5627e94,5627e94] ltm=5627e9c[5627e9c,5627e9c]
> pwt=5627eac[5627eac,5627eac] ptm=5627f04[5627f04,5627f04]
> ref=5627e84[5627e84,5627e84] lnd=5627f10[5627f10,5627f10]
> LIBRARY OBJECT: object=5628088
> type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
> CHILDREN: size=16
> child# table reference handle
> ------ -------- --------- --------
> 0 5628244 5628210 5627dc0
> DATA BLOCKS:
> data# heap pointer status pins change
> ----- -------- -------- ------ ---- ------
> 0 5628290 562810c I/P/A 0 NONE
> ----------------------------------------
> SO: 2bb02d8, type: 36, owner: 28c9aec, flag: INIT/-/-/0x00
> LIBRARY OBJECT PIN: pin=2bb02d8 handle=0 lock=2baedc0
> user=28c9aec session=28c9aec count=0 mask=0000 savepoint=351
> flags=[00]
> ----------------------------------------
> SO: 2baedc0, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
> LIBRARY OBJECT LOCK: lock=2baedc0 handle=5748c5c mode=N
> call pin=0 session pin=2bb02d8
> user=28c9aec session=28c9aec count=1 flags=[00] savepoint=351
> LIBRARY OBJECT HANDLE: handle=5748c5c
> namespace=CRSR flags=RON/KGHP/PN0/[10010000]
> kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch=0
> lwt=5748c74[5748c74,5748c74] ltm=5748c7c[5748c7c,5748c7c]
> pwt=5748c8c[5748c8c,5748c8c] ptm=5748ce4[5748ce4,5748ce4]
> ref=5748c64[5740a4c,5740a4c] lnd=5748cf0[5748cf0,5748cf0]
> LIBRARY OBJECT: object=5748a44
> type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
> DEPENDENCIES: count=1 size=16
> AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
> ACCESSES: count=1 size=16
> TRANSLATIONS: count=1 size=16
> DATA BLOCKS:
> data# heap pointer status pins change
> ----- -------- -------- ------ ---- ------
> 0 574083c 5748804 I/P/A 0 NONE
> 6 5748ad8 573e980 I/-/A 0 NONE
> ----------------------------------------
> SO: 2bae8d4, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
> LIBRARY OBJECT LOCK: lock=2bae8d4 handle=5748d18 mode=N
> call pin=2baf510 session pin=0
> user=28c9aec session=28c9aec count=1 flags=[00] savepoint=351
> LIBRARY OBJECT HANDLE: handle=5748d18
> name=Select max(VoucherKey) from transaction2
> hash=5fb7057d timestamp=06-29-2004 15:00:31
> namespace=CRSR flags=RON/KGHP/TIM/PN0/SML/[12010000]
> kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
> lwt=5748d30[5748d30,5748d30] ltm=5748d38[5748d38,5748d38]
> pwt=5748d48[5748d48,5748d48] ptm=5748da0[5748da0,5748da0]
> ref=5748d20[5748d20,5748d20] lnd=5748dac[5748dac,5748dac]
> LIBRARY OBJECT: object=57408c4
> type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
> CHILDREN: size=16
> child# table reference handle
> ------ -------- --------- --------
> 0 5740a80 5740a4c 5748c5c
> DATA BLOCKS:
> data# heap pointer status pins change
> ----- -------- -------- ------ ---- ------
> 0 5740acc 5740948 I/P/A 0 NONE
> ----------------------------------------
> SO: 2bb3e4c, type: 36, owner: 28c9aec, flag: INIT/-/-/0x00
> LIBRARY OBJECT PIN: pin=2bb3e4c handle=575c244 mode=S
> lock=2baedfc
> user=28c9aec session=28c9aec count=1 mask=0041 savepoint=343
> flags=[00]
> ----------------------------------------
> SO: 2baedfc, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
> LIBRARY OBJECT LOCK: lock=2baedfc handle=575c244 mode=N
> call pin=0 session pin=2bb3e4c
> user=28c9aec session=28c9aec count=1 flags=PNS/[08]
> savepoint=343
> LIBRARY OBJECT HANDLE: handle=575c244
> namespace=CRSR flags=RON/KGHP/PN0/[10010000]
> kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch=0
> lwt=575c25c[575c25c,575c25c] ltm=575c264[575c264,575c264]
> pwt=575c274[575c274,575c274] ptm=575c2cc[575c2cc,575c2cc]
> ref=575c24c[575c308,575c308] lnd=575c2d8[575c2d8,575c2d8]
> LIBRARY OBJECT: object=575c02c
> type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
> DEPENDENCIES: count=1 size=16
> AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
> ACCESSES: count=1 size=16
> TRANSLATIONS: count=1 size=16
> DATA BLOCKS:
> data# heap pointer status pins change
> ----- -------- -------- ------ ---- ------
> 0 575d6c0 575bdec I/P/A 0 NONE
> 6 575c0c0 575b968 I/P/A 1 NONE
> ----------------------------------------
> SO: 2baf900, type: 36, owner: 28c9aec, flag: INIT/-/-/0x00
> LIBRARY OBJECT PIN: pin=2baf900 handle=0 lock=2baea78
> user=28c9aec session=28c9aec count=0 mask=0000 savepoint=193
> flags=[00]
> ----------------------------------------
> SO: 2baea78, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
> LIBRARY OBJECT LOCK: lock=2baea78 handle=575c244 mode=N
> call pin=0 session pin=2baf900
> user=28c9aec session=28c9aec count=1 flags=[00] savepoint=193
> LIBRARY OBJECT HANDLE: handle=575c244
> namespace=CRSR flags=RON/KGHP/PN0/[10010000]
> kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch=0
> lwt=575c25c[575c25c,575c25c] ltm=575c264[575c264,575c264]
> pwt=575c274[575c274,575c274] ptm=575c2cc[575c2cc,575c2cc]
> ref=575c24c[575c308,575c308] lnd=575c2d8[575c2d8,575c2d8]
> LIBRARY OBJECT: object=575c02c
> type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
> DEPENDENCIES: count=1 size=16
> AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
> ACCESSES: count=1 size=16
> TRANSLATIONS: count=1 size=16
> DATA BLOCKS:
> data# heap pointer status pins change
> ----- -------- -------- ------ ---- ------
> 0 575d6c0 575bdec I/P/A 0 NONE
> 6 575c0c0 575b968 I/P/A 1 NONE
> ----------------------------------------
> SO: 2bb53e8, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
> LIBRARY OBJECT LOCK: lock=2bb53e8 handle=575f5fc mode=N
> call pin=2bb3dbc session pin=0
> user=28c9aec session=28c9aec count=2 flags=[00] savepoint=193
> LIBRARY OBJECT HANDLE: handle=575f5fc
> name=select AccountMaster.*, AccountMaster."ROWID" from
> AccountMaster order by accountcode
> hash=94670588 timestamp=06-29-2004 11:05:39
> namespace=CRSR flags=RON/KGHP/TIM/PN0/MED/[50010000]
> kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=0
> lwt=575f614[575f614,575f614] ltm=575f61c[575f61c,575f61c]
> pwt=575f62c[575f62c,575f62c] ptm=575f684[575f684,575f684]
> ref=575f604[575f604,575f604] lnd=575f690[575f690,575f690]
> LIBRARY OBJECT: object=575f44c
> type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
> CHILDREN: size=16
> child# table reference handle
> ------ -------- --------- --------
> 0 575c4d4 575c308 575c244
> DATA BLOCKS:
> data# heap pointer status pins change
> ----- -------- -------- ------ ---- ------
> 0 575d720 575f4d0 I/P/A 0 NONE
> ----------------------------------------
> SO: 2bb4fb0, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
> LIBRARY OBJECT LOCK: lock=2bb4fb0 handle=59ee220 mode=N
> call pin=2bb3984 session pin=0
> user=28c9aec session=28c9aec count=1 flags=CBB/[02] savepoint=76
> LIBRARY OBJECT HANDLE: handle=59ee220
> name=SYS.DATABASE
> hash=aea96fa0 timestamp=12-31-4712 23:59:59
> namespace=EVNT flags=KGHP/TIM/SML/[02000000]
> kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=0
> lwt=59ee238[59ee238,59ee238] ltm=59ee240[59ee240,59ee240]
> pwt=59ee250[59ee250,59ee250] ptm=59ee2a8[59ee2a8,59ee2a8]
> ref=59ee228[59ee228,59ee228] lnd=59ee2b4[59ee2b4,59ee2b4]
> LIBRARY OBJECT: object=59ee008
> type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
> DATA BLOCKS:
> data# heap pointer status pins change
> ----- -------- -------- ------ ---- ------
> 0 59e8d04 59ee0ec I/-/A 0 NONE
> 3 59ee09c 59ede9c I/-/A 0 NONE
> ----------------------------------------
> SO: 2bb4f38, type: 35, owner: 28c9aec, flag: INIT/-/-/0x00
> LIBRARY OBJECT LOCK: lock=2bb4f38 handle=57b6284 mode=N
> call pin=2bb3aec session pin=0
> user=28c9aec session=28c9aec count=1 flags=CBB/[02] savepoint=76
> LIBRARY OBJECT HANDLE: handle=57b6284
> name=SCOTT.SCOTT
> hash=7727a61d timestamp=12-31-4712 23:59:59
> namespace=EVNT flags=KGHP/TIM/SML/[02000000]
> kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=0
> lwt=57b629c[57b629c,57b629c] ltm=57b62a4[57b62a4,57b62a4]
> pwt=57b62b4[57b62b4,57b62b4] ptm=57b630c[57b630c,57b630c]
> ref=57b628c[57b628c,57b628c] lnd=57b6318[57b6318,57b6318]
> LIBRARY OBJECT: object=57b600c
> type=EVNT flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
> DATA BLOCKS:
> data# heap pointer status pins change
> ----- -------- -------- ------ ---- ------
> 0 57b6214 57b60f0 I/-/A 0 NONE
> 3 57b60a0 57b5f1c I/-/A 0 NONE
> ----------------------------------------
> SO: 57437c4, type: 34, owner: 28c9aec, pt: 0, flag:
> INIT/-/-/0x00
> user lock: lock=57437c4 mode=S
> user resource: user=2bc2dd4 uid=36 mode=S
> ----------------------------------------
> SO: 562ca14, type: 34, owner: 28c9aec, pt: 0, flag:
> INIT/-/-/0x00
> user lock: lock=562ca14 mode=S
> user resource: user=2bc2dd4 uid=36 mode=S
> ----------------------------------------
> SO: 29a2a24, type: 9, owner: 28a1a64, pt: 0, flag: INIT/-/-/0x00
> (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 28a1a64,
> event: 69, last message event: 69, messages
> read: 0
> channel: (29a3c2c) system events broadcast
> channel
> scope: 101, event: 69, last mesage
> event: 0,
> publishers/subscribers: 0/26,
> messages published: 0
> ----------------------------------------
> SO: 29170f8, type: 2, owner: 28a1a64, pt: 0, flag: INIT/-/-/0x00
> (call) sess: cur 28c9aec, rec 0, usr 28c9aec; depth: 0
> END OF PROCESS STATE
>
> ================================================== ================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode