RE: SHARED POOL SIZE

[Sunil_Nookala]

Title: RE: SHARED POOL SIZE

sorry I goofed...I meant.. yes, it could be changed.

-----Original Message-----
From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 3:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: SHARED POOL SIZE

The value of IMMEDIATE in the ISSYS_MODIFIABLE column
means that it IS modifiable and takes effect
immediately.

----
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Chaos! Panic! Disaster! (My work here is done)

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: SHARED POOL SIZE

No, it is NOT.

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production

  1  select name, ISSES_MODIFIABLE, ISSYS_MODIFIABLE from v$parameter
  2* where name like'shared_pool_size%'
SQL> /

NAME                                                             ISSES
ISSYS_MOD
---------------------------------------------------------------- -----
---------
shared_pool_size                                                 FALSE
IMMEDIATE

Sunil Nookala
Dell Corp.

-----Original Message-----
Sent: Monday, May 20, 2002 2:55 PM
To: Multiple recipients of list ORACLE-L

Only on 9.0.1 and above

-----Original Message-----
[EMAIL PROTECTED]
Sent: Monday, May 20, 2002 9:24 PM
To: Multiple recipients of list ORACLE-L

No.

Jared

Hamid Alavi <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/20/2002 12:05 PM
Please respond to ORACLE-L

 
        To:     Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
        cc:
        Subject:        SHARED POOL SIZE

HI,

IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE
DATABASE(8.1.6.2 ON SUN SOLARIS)

Hamid Alavi
Office 818 737-0526
Cell    818 402-1987

======================= Confidentiality Statement
=======================
The information contained in this message and any attachments is
intended only for the use of the individual or entity to which it is
addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
and exempt from disclosure under applicable law.  If you have received
this message in error, you are prohibited from copying, distributing, or

using the information.  Please contact the sender immediately by return
e-mail and delete the original message from your system.
===================== End Confidentiality Statement
=====================

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  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:
  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: raja
  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:
  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).