automatic memory management, not so automatic?

From: hastenthunder <hastenthunder_at_hotmail.com>
Date: Wed, 29 Dec 2004 10:55:07 -0500
Message-ID: <vrAAd.2322$Ny6.3852@mencken.net.nih.gov>

Hello,

I'm running Oracle 10g on Red Hat Enterprise 3, using Oracle's automatic memory management.

I've verified that the instance is acutally using automatic memory management by using the following queries:

SQL> show parameter sga_target

NAME                                 TYPE               VALUE
------------------------------------ ------------------ --------------------
----------
sga_target                           big integer        1104M

As far as I understand it, Oracle should now have the following parameters defined:

__db_cache_size
__java_pool_size
__large_pool_size
__shared_pool_size

However, I cannot find these new parameters from v$parameter. Nor can I find them by executing the following:

SQL> show parameter pool

NAME                                 TYPE               VALUE
------------------------------------ ------------------ --------------------
----------
buffer_pool_keep                     string
buffer_pool_recycle                  string
global_context_pool_size             string
java_pool_size                       big integer        0
large_pool_size                      big integer        0
olap_page_pool_size                  big integer        0
shared_pool_reserved_size            big integer        13421772
shared_pool_size                     big integer        0

streams_pool_size

This is way odd, the "old" pool_size parameters have been set to 0, yet the new parameters is not showing up.

Any comments would be greatly appreciated. Received on Wed Dec 29 2004 - 09:55:07 CST