-none- 2004-04-27 - By -not available-
PROCESS 23:
-- ---- ---- ---- ---- ---- ---- ---- --
SO: d9523624, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
(process) Oracle pid=23, calls cur/top: d960d7d4/d960d7d4, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 3648316968 0 1
last post received-location: kslfre
last process to post me: d9522cd0 4 0
last post sent: 2147544044 0 1
last post sent-location: kslfre
last process posted by me: d9525220 41 0
(latch info) wait_event=0 bits=90
holding 8000ebec shared pool level=7
Location from where latch is held: kghfrunp: alloc: clatch nowait:
Context saved from call: 0
state=busy
holding 8000c114 row cache objects level=4
Location from where latch is held: kghfrunp: clatch: nowait:
Context saved from call: 0
state=busy
Process Group: DEFAULT, pseudo proc: d955952c
O/S info: user: oracle, term: UNKNOWN, ospid: 5345
OSD pid info: 5345
-- ---- ---- ---- ---- ---- ---- ---- --
SO: d95991a0, type: 3, owner: d9523624, pt: 0, flag: INIT/-/-/0x00
(session) trans: 0, creator: d9523624, flag: (41) USR/- BSY/-/-/-/-/-
DID: 0000-0000-00000000, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 47, prv: 0, user: 20/SYSADM
O/S info: user: dp943, term: PHSPSPAPP8, ospid: 2028:3424, machine: PARTNERS\PHSPSPAPP8
program: PSAPPSRV.exe
client info: ,dp943,PHSPSPAPP8,,PSAPPSRV.exe,
last wait for 'latch free ' blocking sess=0x0 seq=14093 wait_time=-1
address=d974e628, number=6a, tries=1
-- ---- ---- ---- ---- ---- ---- ---- --
SO: d97c6674, type: 36, owner: d95991a0, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=d97c6674 handle=da02bb1c mode=X lock=d97d5c84
user=d95991a0 session=d95991a0 count=0 mask=007d savepoint=68 flags=[00]
-- ---- ---- ---- ---- ---- ---- ---- --
SO: d97d5c84, type: 35, owner: d95991a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=d97d5c84 handle=da02bb1c mode=N
call pin=0 session pin=d97c6674
user=d95991a0 session=d95991a0 count=1 flags=PNS/[08] savepoint=68
LIBRARY OBJECT HANDLE: handle=da02bb1c
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0000-0000 lock=N pin=X latch=2
lwt=da02bb34[da02bb34,da02bb34] ltm=da02bb3c[da02bb3c,da02bb3c]
pwt=da02bb4c[da02bb4c,da02bb4c] ptm=da02bba4[da02bba4,da02bba4]
ref=da02bb24[cac6f6d8,cac6f6d8] lnd=da02bbb0[da02bbb0,da02bbb0]
LIBRARY OBJECT: object=dadfc344
type=CRSR flags=EXS/BCM[0001] pflags=NST [101] status=VALD load=0
DEPENDENCIES: count=4 size=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
-- -- -- ----- -- ----- -- --- ---- -- ---
0 c9cee16c dadfc1b4 I/P/A 0 NONE
2 dadfc3d8 c9c4bb3c I/P/A 1 NONE
3 dadfc438 0 -/P/- 1 NONE
4 dadfc498 cf49aef0 I/P/A 1 NONE
5 dadfc104 0 -/P/- 1 NONE
6 dadfc164 cb43e3e4 I/P/A 1 NONE
-- ---- ---- ---- ---- ---- ---- ---- --
SO: d97cc9cc, type: 35, owner: d95991a0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=d97cc9cc handle=cac6f768 mode=N
Any ideas are welcome. If you made it this far, thanks for the perseverance and time you already invested.
Henry
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
