Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> resizing shared_pool_size on Ora9i

resizing shared_pool_size on Ora9i

From: Davide Pulver <david.pulver_at_profidatagroup.com>
Date: Tue, 12 Mar 2002 17:09:06 GMT
Message-ID: <SCqj8.42$Nt5.1072@nreader1.kpnqwest.net>


Hello

In my init.ora-File I defined the param shared_pool_size=16M. After restarting the database, I verify the param. with "show parameters shared_pool_size". output: shared_pool_size value=29360128 (28M) --> +12M!

When i resize the param in init.ora to 32M, the effective value is set to 44M. (+12M too)

What is wrong, where the 12M come from?

Thanks in advance and sorry for my bad english.

D. Pulver Received on Tue Mar 12 2002 - 11:09:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US