Re: Basic question about internal process flow in Oracle 11g R2 rac enviroment

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Mon, 18 Jan 2016 12:05:13 -0600
Message-ID: <CAEueRAXeFt1n3kRzUast-nDe_Givj50jFiKsLQeK=ko6O_cJ3g_at_mail.gmail.com>



Sandip,

Are you asking about the process of how this data is fetched in the context of RAC versus single instance or are you just looking for a general overview of a query from the dictionary?

Seth Miller

On Mon, Jan 18, 2016 at 10:13 AM, Sandip Mukhopadhyay < sandip.mukhopadhyay24_at_gmail.com> wrote:

> Hi All,
>
> I am posting a basic question of internal process flow in a 2 node 11g r2
> rac environment(ASM is obvious storage here),suppose a user has entered
> below SQL from his Client terminal
> select * from tab
>
> What is the internal process flow i.e how data is fetched and provided to
> the user .
>
> Appreciate your assistance & cooperation .
>
> Regards,
> Sandy
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 18 2016 - 19:05:13 CET

Original text of this message