Re: automatic memory management, not so automatic?

On Wed, 29 Dec 2004 10:55:07 -0500, "hastenthunder" <hastenthunder_at_hotmail.com> wrote:

Cannot confirm your observation. They show up in either of these cases :

SQL> select substr(name,1,50),substr(value,1,20) from v$parameter where name like '\_\_%' escape '\';

SUBSTR(NAME,1,50)                                  SUBSTR(VALUE,1,20)
--------------------------------------------------
--------------------


__shared_pool_size                                 46137344

__large_pool_size                                  4194304

__java_pool_size                                   4194304

__db_cache_size                                    109051904

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 4M

java_pool_size                       big integer 0


__large_pool_size                    big integer 4M

large_pool_size                      big integer 0
olap_page_pool_size                  big integer 0
shared_pool_reserved_size            big integer 2306867


__shared_pool_size                   big integer 44M

shared_pool_size                     big integer 0

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
streams_pool_size                    big integer 0

• Kenneth Koenraadt