Re: sys.v_$parameter
On Jun 11, 2001 at 12:25:22AM, Greg Moore wrote: 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? In fact you'll get the same result. v$parameter is a synonym for v_$parameter: grep -i 'cre.*syn.*v\$par' $ORACLE_HOME/rdbms/admin/catalog.sql -- Vladimir Begun | Besides, REAL computers have a rename() http://vbegun.net/ | system call.:-) http://vbegun.net/wap/ | -- Larry Wall in [EMAIL PROTECTED]| [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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).
Re: sys.v_$parameter
If you're obsessive about performance - its avoiding the synonym lookup I suppose.. Cheers Connor --- Greg Moore [EMAIL PROTECTED] wrote: 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
Re: sys.v_$parameter
What's more interesting is of course a query against v$fixed_view_definition to show how v$parameter (or v_$parameter) is defined. This will point you to x$ksppi and other x$-tables where you can also see the un-documented parameters (those starting with an _). Greg Moore wrote: 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). -- Venlig hilsen Mogens Nørgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= 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).
Re: Re: sys.v_$parameter
There is only one case when you should use V_$something instead of V$SOMETHING, which is when connected as SYS (or INTERNAL) to grant SELECT to a user who needs to create a stored procedure or view involving the said V$something. As Vladimir said, V$xxx is a synonym for V_$xxx, which is a (hard-coded) view on GV$xxx, itself a hard-coded view on a more or less complex brew of X$ tables (details in V$FIXED_VIEW_DEFINITION). At least on the versions I have tried so far, GRANTing anything on the synonym doesn't work (you get an error saying that the only thing you are allowed to do with dynamic views is SELECT from them). However, no problem to grant SELECT on V_$... Regards, Stephane Faroult Oriole Corporation On Jun 11, 2001 at 12:25:22AM, Greg Moore wrote: 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? In fact you'll get the same result. v$parameter is a synonym for v_$parameter: grep -i 'cre.*syn.*v\$par' $ORACLE_HOME/rdbms/admin/catalog.sql -- Vladimir Begun | Besides, REAL computers have a rename() http://vbegun.net/ | system call.:-) http://vbegun.net/wap/ | -- Larry Wall in [EMAIL PROTECTED]| [EMAIL PROTECTED] -- -- Diese E-Mail wurde mit http://de.mail-inspector.de verschickt Mail Inspector ist ein kostenloser Service von http://www.is-fun.net Der Absender dieser E-Mail hatte die IP: 195.25.229.12 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
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).
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 [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).
