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