Re: Change SGA size online ??

Thanks for the correction. I made the mistake of believeing some Oracle Documentation - always a bit risky

Kevin

--
The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:37180482.30736797_at_192.86.155.100...
> A copy of this was sent to "Kevin A Lewis" <KevinALewis_at_Hotmail.com>
> (if that email address didn't require changing)
> On Thu, 15 Apr 1999 15:30:18 +0100, you wrote:
>
> >I think you mean V$SYSTEM_PARAMETER as V$PARAMETER is the older more
> >restricted form of the information without the 'alterable' element
>
> no, v$parameter and v$system_parameter have the same structure. The
difference
> between the 2 is that some (but not all) of the settings in v$parameter
reflect
> the current SESSIONS setting of that parameter whereas v$system_parameter
shows
> the 'default' setting for a value given a new session. Over time, all
elements
> in v$parameter will show the session setting.
>
> SQL> desc v$parameter
> Name Null? Type
> ------------------------------- -------- ----
> NUM NUMBER
> NAME VARCHAR2(64)
> TYPE NUMBER
> VALUE VARCHAR2(512)
> ISDEFAULT VARCHAR2(9)
> ISSES_MODIFIABLE VARCHAR2(5)
> ISSYS_MODIFIABLE VARCHAR2(9)
> ISMODIFIED VARCHAR2(10)
> ISADJUSTED VARCHAR2(5)
> DESCRIPTION VARCHAR2(64)
>
> SQL> desc v$system_parameter
> Name Null? Type
> ------------------------------- -------- ----
> NUM NUMBER
> NAME VARCHAR2(64)
> TYPE NUMBER
> VALUE VARCHAR2(512)
> ISDEFAULT VARCHAR2(9)
> ISSES_MODIFIABLE VARCHAR2(5)
> ISSYS_MODIFIABLE VARCHAR2(9)
> ISMODIFIED VARCHAR2(8)
> ISADJUSTED VARCHAR2(5)
> DESCRIPTION VARCHAR2(64)
>
> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Service Industries
> Reston, VA USA
>
> --
> http://govt.us.oracle.com/ -- downloadable utilities
>
> --------------------------------------------------------------------------
--
> Opinions are mine and do not necessarily reflect those of Oracle
Corporation Received on Thu Apr 15 1999 - 11:17:47 CDT