RE: newbie question

From: Diego Cutrone <dcutrone_at_afip.gov.ar>
Date: Wed, 16 May 2001 10:25:39 -0700
Message-ID: <F001.003051AB.20010516103627@fatcity.com>

Hi,

Yes, you can modify instance parameters in the initXYZ.ora file. After you change them, they take effect when you bounce the instance (shutdown and startup)

Also, there are some parameters that can be modify on the fly, without bouncing the instance.

check this.

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> column name format a60
SQL> column value format a20

SQL> column ISSYS_MODIFIABLE format a6
SQL> select name,value,ISSYS_MODIFIABLE from v$parameter;

NAME                                                         VALUE

ISSYS_

------------------------------------------------------------ ---------------
----- ------
processes                                                    50
FALSE
sessions                                                     60
FALSE
timed_statistics                                             TRUE

IMMEDIATE <<<-----------

You can change timed_statistics value with this command:

alter system set timed_statistics=true;

Hope it helps
DC

Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, May 16, 2001 3:19 PM

> Hi, guru,
>
> After I created a XYZ database using the Database Configuration Assistant,
> can I modify some parameters in the initXYZ.ora file? What steps should I
> take after the modification? Please advise.
>
> Regards,
> Julia
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: PHU,JULIA (HP-Sunnyvale,ex2)
> INET: julia_phu_at_hp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Diego Cutrone
  INET: dcutrone_at_afip.gov.ar

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed May 16 2001 - 12:25:39 CDT