Message-Id: <10686.122502@fatcity.com> From: "Mohan, Ross" Date: Mon, 20 Nov 2000 10:32:21 -0500 Subject: RE: latch free while running pl/sql block This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C05307.62E62A70 Content-Type: text/plain; charset="iso-8859-1" What's in the block? -----Original Message----- From: arun [mailto:arun_k_c@hotmail.com] Sent: Saturday, November 18, 2000 7:45 PM To: Multiple recipients of list ORACLE-L Subject: latch free while running pl/sql block Hi, has anybody faced probs while running pl/sql block on 8.1.5 ,I am facing latch free contention when one of the user is running this block the latch is pointing to shared pool it never releases this latch. There is nobody logged into this database apart from the user who is running his pl/sql block and even the database was just brought up. Can anybody let me know how to solve this issue. Thanks ------_=_NextPart_001_01C05307.62E62A70 Content-Type: text/html; charset="iso-8859-1"

What's in the block?

-----Original Message-----
From: arun [mailto:arun_k_c@hotmail.com]
Sent: Saturday, November 18, 2000 7:45 PM
To: Multiple recipients of list ORACLE-L
Subject: latch free while running pl/sql block

Hi,

has anybody faced probs while running pl/sql block on 8.1.5 ,I am facing latch free contention when one of the user is running this block the latch is pointing to shared pool it never releases this latch.

There is nobody logged into this database apart from the user who is running his pl/sql block and even the database was just brought up.

Can anybody let me know how to solve this issue.

Thanks