Yep, I've done it before without any problems
-----Original Message-----
Sent: 17 May 2001 05:06
To: Multiple recipients of list ORACLE-L
Thank you so much for the info, DC.
I have another stupid question. Can I have two different ports for two
database in the same tnsname.ora on the same server?
Cheers,
Julia
-----Original Message-----
Sent: Wednesday, May 16, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L
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 <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: PHU,JULIA (HP-Sunnyvale,ex2)
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
