Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Change SGA size online ??
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