quot; <[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 by
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
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 v
hy 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
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 inst
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
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