-none- 2004-04-28 - By -not available-
PROCESS 23:=20
-- ---- ---- ---- ---- ---- ---- ---- --=20
SO: d9523624, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00=20
(process) Oracle pid=3D23, calls cur/top: d960d7d4/d960d7d4, flag: (0) =
-=20
int error: 0, call error: 0, sess error: 0, txn error 0=20
(post info) last post received: 3648316968 0 1=20
last post received-location: kslfre=20
last process to post me: d9522cd0 4 0=20
last post sent: 2147544044 0 1=20
last post sent-location: kslfre=20
last process posted by me: d9525220 41 0=20
(latch info) wait_event=3D0 bits=3D90=20
holding 8000ebec shared pool level=3D7=20
Location from where latch is held: kghfrunp: alloc: clatch nowait=
:=20
Context saved from call: 0=20
state=3Dbusy=20
holding 8000c114 row cache objects level=3D4=20
Location from where latch is held: kghfrunp: clatch: nowait:=20
Context saved from call: 0=20
state=3Dbusy=20
Process Group: DEFAULT, pseudo proc: d955952c=20
O/S info: user: oracle, term: UNKNOWN, ospid: 5345=20
OSD pid info: 5345=20
-- ---- ---- ---- ---- ---- ---- ---- --=20
SO: d95991a0, type: 3, owner: d9523624, pt: 0, flag: INIT/-/-/0x00=20
(session) trans: 0, creator: d9523624, flag: (41) USR/- BSY/-/-/-/-/-=
=20
DID: 0000-0000-00000000, short-term DID: 0000-0000-00000000=
=20
txn branch: 0=20
oct: 47, prv: 0, user: 20/SYSADM=20
O/S info: user: dp943, term: PHSPSPAPP8, ospid: 2028:3424, machine:
PARTNERS\PHSPSPAPP8=20
program: PSAPPSRV.exe=20
client info: ,dp943,PHSPSPAPP8,,PSAPPSRV.exe,=20
last wait for 'latch free ' blocking sess=3D0x0 seq=3D14093 wait_time=3D=
-1=20
address=3Dd974e628, number=3D6a, tries=3D1=20
-- ---- ---- ---- ---- ---- ---- ---- --=20
SO: d97c6674, type: 36, owner: d95991a0, flag: INIT/-/-/0x00=20
LIBRARY OBJECT PIN: pin=3Dd97c6674 handle=3Dda02bb1c mode=3DX lock=3D=
d97d5c84=20
user=3Dd95991a0 session=3Dd95991a0 count=3D0 mask=3D007d savepoint=3D=
68
flags=3D[00]=20
-- ---- ---- ---- ---- ---- ---- ---- --=20
SO: d97d5c84, type: 35, owner: d95991a0, flag: INIT/-/-/0x00=20
LIBRARY OBJECT LOCK: lock=3Dd97d5c84 handle=3Dda02bb1c mode=3DN=20
call pin=3D0 session pin=3Dd97c6674=20
user=3Dd95991a0 session=3Dd95991a0 count=3D1 flags=3DPNS/[08] savep=
oint=3D68=20
LIBRARY OBJECT HANDLE: handle=3Dda02bb1c=20
namespace=3DCRSR flags=3DRON/KGHP/PN0/[10010000]=20
kkkk-dddd-llll=3D0000-0000-0000 lock=3DN pin=3DX latch=3D2=20
lwt=3Dda02bb34[da02bb34,da02bb34] ltm=3Dda02bb3c[da02bb3c,da02bb3c]=
=20
pwt=3Dda02bb4c[da02bb4c,da02bb4c] ptm=3Dda02bba4[da02bba4,da02bba4]=
=20
ref=3Dda02bb24[cac6f6d8,cac6f6d8] lnd=3Dda02bbb0[da02bbb0,da02bbb0]=
=20
LIBRARY OBJECT: object=3Ddadfc344=20
type=3DCRSR flags=3DEXS/BCM[0001] pflags=3DNST [101] status=3DVAL=
D load=3D0=20
DEPENDENCIES: count=3D4 size=3D16=20
ACCESSES: count=3D1 size=3D16=20
TRANSLATIONS: count=3D1 size=3D16=20
DATA BLOCKS:=20
data# heap pointer status pins change=20
-- -- -- ----- -- ----- -- --- ---- -- ---=20
0 c9cee16c dadfc1b4 I/P/A 0 NONE =20
2 dadfc3d8 c9c4bb3c I/P/A 1 NONE =20
3 dadfc438 0 -/P/- 1 NONE =20
4 dadfc498 cf49aef0 I/P/A 1 NONE =20
5 dadfc104 0 -/P/- 1 NONE =20
6 dadfc164 cb43e3e4 I/P/A 1 NONE =20
-- ---- ---- ---- ---- ---- ---- ---- --=20
SO: d97cc9cc, type: 35, owner: d95991a0, flag: INIT/-/-/0x00=20
LIBRARY OBJECT LOCK: lock=3Dd97cc9cc handle=3Dcac6f768 mode=3DN=20
Any ideas are welcome. If you made it this far, thanks for the perseveran=
ce
and time you already invested.=20
Henry=20
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com > =20
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------=20
To unsubscribe send email to: oracle-l-request@(protected)=20
put 'unsubscribe ' in the subject line.=20
--=20
Archives are at http://www.freelists.org/archives/oracle-l/
<http://www.freelists.org/archives/oracle-l/ > =20
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
<http://www.freelists.org/help/fom-serve/cache/1.html > =20
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --=20
-- Binary/unsupported file stripped by Ecartis --
-- Type: application/ms-tnef
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
