MIME-Version: 1.0
In-Reply-To: <CAO6SxR_MAWc0Vqi9LSWhuLMkT2=bpHnQ+hVgYZHMXsMhiBnqrw@mail.gmail.com>
References: <CAO6SxR_MAWc0Vqi9LSWhuLMkT2=bpHnQ+hVgYZHMXsMhiBnqrw@mail.gmail.com>
Date: Mon, 18 Jan 2016 12:05:13 -0600
Message-ID: <CAEueRAXeFt1n3kRzUast-nDe_Givj50jFiKsLQeK=ko6O_cJ3g@mail.gmail.com>
Subject: Re: Basic question about internal process flow in Oracle 11g R2 rac enviroment
From: Seth Miller <sethmiller.sm@gmail.com>
To: Sandip Mukhopadhyay <sandip.mukhopadhyay24@gmail.com>
Cc: "oracle-l@freelists.org" <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary=047d7b2e0add327b8305299f98ac
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: sethmiller.sm@gmail.com
--047d7b2e0add327b8305299f98ac
Content-Type: text/plain; charset=UTF-8

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@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
>
>

--047d7b2e0add327b8305299f98ac
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Sandip,<div><br></div><div>Are you asking about the proces=
s 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 dictiona=
ry?</div><div><br></div><div>Seth Miller</div></div><div class=3D"gmail_ext=
ra"><br><div class=3D"gmail_quote">On Mon, Jan 18, 2016 at 10:13 AM, Sandip=
 Mukhopadhyay <span dir=3D"ltr">&lt;<a href=3D"mailto:sandip.mukhopadhyay24=
@gmail.com" target=3D"_blank">sandip.mukhopadhyay24@gmail.com</a>&gt;</span=
> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bo=
rder-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hi All,<div><br=
></div><div>I am posting a basic question of internal process flow in a 2 n=
ode 11g r2 rac environment(ASM is obvious storage here),suppose a user has =
entered =C2=A0below SQL =C2=A0from his Client terminal=C2=A0</div><div>sele=
ct * from tab</div><div><br></div><div>What is the internal process flow i.=
e how data is fetched and provided to the user .</div><div><br></div><div>A=
ppreciate your assistance &amp; cooperation .</div><div><br></div><div>Rega=
rds,</div><div>Sandy</div><div><br></div></div>
</blockquote></div><br></div>

--047d7b2e0add327b8305299f98ac--
--
http://www.freelists.org/webpage/oracle-l