Re: 'gc current' waits on a SELECT statement!?
From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Sun, 24 Jul 2011 23:27:30 -0500
Message-ID: <CAN5iexGPJVCA=o7p1vBwrFNsN7h=0iDpzQchbkcefVy6PzuLBg_at_mail.gmail.com>
http://www.freelists.org/post/oracle-l/gc-cr-multi-block-request-and-Current-Blocks-Received,3
Date: Sun, 24 Jul 2011 23:27:30 -0500
Message-ID: <CAN5iexGPJVCA=o7p1vBwrFNsN7h=0iDpzQchbkcefVy6PzuLBg_at_mail.gmail.com>
http://www.freelists.org/post/oracle-l/gc-cr-multi-block-request-and-Current-Blocks-Received,3
On Sun, Jul 24, 2011 at 5:11 PM, PD Malik <pdthedba_at_gmail.com> wrote:
> Dear Experts,
>
> My understanding is that the gc current waits only happen when a requester
> is asking for the block in current mode i.e. to modify them (If it is
> correct) then why would the following SELECT SQL wait on the gc current
> waits pls :
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jul 24 2011 - 23:27:30 CDT