--- "Fedock, John (KAM.RHQ)" <[EMAIL PROTECTED]>
wrote:
> What a timely thread. I have been working on
> debugging a library cache lock
> issue as well. I am running 8.1.7 on HP-UX. < Snip>
Listers,
there is a tar on this ( I think ) issue or similar
one. Please check matastink for bug no. 215
nks for your reply,
>
> Cherie
>
>
>
> "George
> Schlossnagle"To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
> .com>Subject:
ements in that job is
> causing the problem.
>
> Thanks for your reply,
>
> Cherie
>
>
>
> "George
> Schlossnagle"To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
>
To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
> thian.com> Subject: Re: Shared pool
wait for library cache pin
> Sent by:
> [EMAIL PROTECTED]
>
>
> 01/02/02 02:41
>
Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: Shared pool wait for
library cache pin
Sent by:
;
>
>
>
>
>
> George
> Schlossnagle To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
> thian.com> Subject: Re: Shared pool
wait for library cache pin
> Se
CTED]
01/03/02 05:37 Subject: Re: Shared pool wait for library
cache pin
>
> Thanks for taking time to reply.
>
> Cherie
>
>
>
> George
> Schlossnagle To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
> thian.com> Subj
George
Schlossnagle To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: Shared pool wait for
library cache pin
eorge
Schlossnagle" To: <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
Subject: Re: Shared pool wait
pool, right?
>
> Thanks for taking time to reply.
>
> Cherie
>
>
>
> George
> Schlossnagle To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
> thian.com>
[EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
01/02/02 03:35 Subject: Re: Shared pool wait
for library cache pin
PM
Cherie,
What constitutes 'a lot of shared pool waits (for libary cache pin)'?
D
eorge
Schlossnagle" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: Shared pool wait for
library cache pin
0.
> I'm not sure what high is?
>
> Cherie
>
>
>
> "George
> Schlossnagle" To: Multiple recipients
> of list ORACLE-L <[EMAIL PROTECTED]>
> thian.com>
EMAIL PROTECTED]
01/02/02 03:35 Subject: Re: Shared pool wait for library
cache pin
n 400.
I'm not sure what high is?
Cherie
"George
Schlossnagle" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
thian.com> Subject: Re: Shar
ply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Shared pool wait for library cache pin
>Date: Wed, 02 Jan 2002 13:35:20 -0800
>
>
>Yes, there are a handful with more than 400.
>I'm not sure what high is?
>
&g
ist ORACLE-L
<[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: Shared pool wait for library
cache pin
uot;George
Schlossnagle" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: Shared pool wait for
library cache pin
Do any of your queries have a high version_count (visible through
v$sqlarea)?
George
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 02, 2002 3:20 PM
>
> We are seeing a lot of shared pool waits (for libary cache pin) on
> ou
We are seeing a lot of shared pool waits (for libary cache pin) on
our 8.1.5 web-based application. We are seeing this via Precise/Indepth
SQL monitoring tool.
I haven't been able to find much documentation on shared pool waits or
library cache pins.
Can anyone tell me what might be causing th
21 matches
Mail list logo