| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=324073315-20112000><FONT face=Arial color=#0000ff size=2>What's
in the block?</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader><FONT face="Times New Roman"
size=2>-----Original Message-----<BR><B>From:</B> arun
[mailto:arun_k_c_at_hotmail.com]<BR><B>Sent:</B> Saturday, November 18, 2000 7:45
PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> latch
free while running pl/sql block<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2>Can anybody let me know how to solve this
issue.</FONT></DIV>
<DIV><FONT face=Arial size=2>Thanks</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>
Received on Mon Nov 20 2000 - 09:32:21 CST
 |
 |