RE: buffer busy wait latch free ( cache buffer chain )

2001-12-06 Thread Scott Shafer
[EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of ARUN K C Sent: Wednesday, December 05, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: buffer busy wait latch free ( cache buffer chain

RE: buffer busy wait latch free ( cache buffer chain )

2001-12-05 Thread ARUN K C
PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: buffer busy wait latch free ( cache buffer chain ) Date: Tue, 04 Dec 2001 23:05:19 -0800 Your statement there are several bugs relating to waiting for latch-free on cache-buffer-chains, and the possibility of the instance

RE: buffer busy wait latch free ( cache buffer chain )

2001-12-05 Thread Larry Elkins
] [mailto:[EMAIL PROTECTED]]On Behalf Of ARUN K C Sent: Wednesday, December 05, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: buffer busy wait latch free ( cache buffer chain ) One way I can say there are bunch of patches which has to be applied on 8.1.7.2,We had

RE: buffer busy wait latch free ( cache buffer chain )

2001-12-05 Thread ARUN K C
I was mentioning this on Sun 2.6 os From: Larry Elkins [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: buffer busy wait latch free ( cache buffer chain ) Date: Wed, 05 Dec 2001 06:30:23 -0800 I may have missed it, but has

RE: buffer busy wait latch free ( cache buffer chain )

2001-12-05 Thread Barbara Baker
Re: 8.1.7.2 problems We are also on Solaris 2.6. We've been testing 8.1.7.2 for the past several weeks, and have not seen these kinds of problems. This is a very critical upgrade for us. Are others seeing major problems with 8.1.7.2 on Solaris?? Thanks for any responses. Barb

Re: buffer busy wait latch free ( cache buffer chain )

2001-12-05 Thread Edward Shevtsov
and only option was to bring the database was bring it down. God I can say they have royally messed up in 8.1.7.2. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: buffer busy wait latch free ( cache buffer chain ) Date

RE: buffer busy wait latch free ( cache buffer chain )

2001-12-05 Thread DENNIS WILLIAMS
can say they have royally messed up in 8.1.7.2. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: buffer busy wait latch free ( cache buffer chain ) Date: Tue, 04 Dec 2001 23:05:19 -0800 Your statement

RE: buffer busy wait latch free ( cache buffer chain )

2001-12-05 Thread Binley Lim
Metalink: advance search on the keywords, click only Bug Database for Sources, and take your pick from the list. [EMAIL PROTECTED] 12/05/01 08:05PM Your statement there are several bugs relating to waiting for latch-free on cache-buffer-chains, and the possibility of the instance hanging.

Re: buffer busy wait latch free ( cache buffer chain )

2001-12-05 Thread hemantchitale
[EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Re: buffer busy wait latch free ( cache buffer chain

Re: buffer busy wait latch free ( cache buffer chain )

2001-12-04 Thread ARUN K C
What are u seeing the buffer busy waits on is it for the read intensivity and latch free is showing that there are hot blocks why dont you find out the hot blocks and find what can be done about it From: VIVEK_SHARMA [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of

RE: buffer busy wait latch free ( cache buffer chain )

2001-12-04 Thread Diego Cutrone
Vivek: To combat the latch free- cache buffer chain problem, I would first check in v$latch_children if the contention is even across all cache buffer chain latches. If this is the case case (most of the time it is not) , I would add more cache buffer latches. If this is not the case, as ARUN

RE: buffer busy wait latch free ( cache buffer chain )

2001-12-04 Thread Binley Lim
If on 8.1.7, there are several bugs relating to waiting for latch-free on cache-buffer-chains, and the possibility of the instance hanging. One is 1967363, and at least two others are still open after applying that patch. Changing cache buffer latches/buckets is not mentioned in those bugs,

RE: buffer busy wait latch free ( cache buffer chain )

2001-12-04 Thread hemantchitale
: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: RE: buffer busy wait latch free ( cache buffer chain