Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: difference between v$, gv$, and v_$?

Re: difference between v$, gv$, and v_$?

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 31 May 2002 18:02:02 -0700
Message-ID: <1efdad5b.0205311702.618b406b@posting.google.com>


Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<eadffusp0fa9el2tf29hka6j6d7bdkihop_at_4ax.com>...
> On 31 May 2002 04:57:07 -0700, rgaffuri_at_cox.net (Ryan Gaffuri) wrote:
>
> >Yes I know I can look at them and I have. Im trying to figure out what
> >the different methodology in the naming convention is? Why is one v$,
> >one v_$, another gv_$, and another gv$?
> >
> >What is the reasoning?
>
> gv is an acronym for global view. It comes into play when running
> Oracle Parallel Server. The gv% views will show results for the
> complete cluster. Note many of the v$ views just select from the
> global view with a where clause referring to the local instance.
> v%$ are just synonyms (please look up what they are in dba_objects)
> for v_$. There was a rationale behind this, but right now I can't
> recall it.
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

thanks. I have actually looked in the Oracle documentation on OTN and on Metalink and could not find an answer. Its probably there somewhere...

The GV vs. V$ clears up alot.

Thanks. Received on Fri May 31 2002 - 20:02:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US