Re: sys.v_$parameter

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" <mark_at_cool-tools.co.uk>

> Organization: Fat City Network Services, San Diego, California

> Reply-To: ORACLE-L_at_fatcity.com

> Date: Mon, 11 Jun 2001 06:25:50 -0800

> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

> 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: sqlgreg_at_pacbell.net

> 

> 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: ListGuru_at_fatcity.com (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: mark_at_cool-tools.co.uk

> 

> 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: ListGuru_at_fatcity.com (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: jwalthour_at_mac.com

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: ListGuru_at_fatcity.com (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).