In fact, I use these fully qualified views all the time. A couple of notes:
- V$ "views" are, in fact, synonyms for the V_$ views.
- V_$ views are indeed views on the GV$ views which, as has been previous
been stated, are views on the X$ tables.
- There is no real performance gain to using the view name itself rather
than the synonym. There are two advantages, though. (1) the v$ synonyms are
public synonyms and therefore clutter the library cache with references to
non-existent objects; (2) versions of Oracle prior to 7.3 do not have these
public synonyms and so references to dba_data_files, for example, must be
made as sys.dba_data_files.
As a result of all this, I use this syntax almost exclusively.
Hope this helps.
--
Jon Walthour, BSCD
Oracle 8i Certified Database Administrator (OCDBA)
Computer Horizons Corporation
Cincinnati, Ohio
> From: "Mark Leith" <[EMAIL PROTECTED]>
> Organization: Fat City Network Services, San Diego, California
> Reply-To: [EMAIL PROTECTED]
> Date: Mon, 11 Jun 2001 06:25:50 -0800
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: sys.v_$parameter
>
> To bypass the view? Is it in a huge script? Could be to glean every bit of
> performance from the script..
>
> Mark
>
> -----Original Message-----
> Sent: Monday, June 11, 2001 09:25
> To: Multiple recipients of list ORACLE-L
>
>
> Why would someone write a SQL*Plus script against sys.v_$parameter when you
> want to find the value of an init parm, when instead you could code against
> v$parameter?
>
> - Greg
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Greg Moore
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Leith
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
