sys.v_$parameter

2001-06-11 Thread Greg Moore
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

Re: sys.v_$parameter

2001-06-11 Thread Vladimir Begun
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

Re: sys.v_$parameter

2001-06-11 Thread Connor McDonald
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

Re: sys.v_$parameter

2001-06-11 Thread Mogens Nørgaard
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

Re: Re: sys.v_$parameter

2001-06-11 Thread sfaroult
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

RE: sys.v_$parameter

2001-06-11 Thread Mark Leith
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

Re: sys.v_$parameter

2001-06-11 Thread Jon Walthour
] 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