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 -> Re: automatic memory management, not so automatic?

Re: automatic memory management, not so automatic?

From: hastenthunder <hastenthunder_at_hotmail.com>
Date: Wed, 29 Dec 2004 14:00:11 -0500
Message-ID: <09DAd.2324$Ny6.3787@mencken.net.nih.gov>


Right, that is my question.
If these __ parameters do not show up on my server, then

    SQL>Show parameter sga_target
should return a value of 0, yet it does not.

In essence, sga_target parameter is saying I'm using automatic memory management, yet the 4 __ parameters does not show up.

<Kenneth Koenraadt> wrote in message
news:41d2ef5e.265406_at_news.inet.tele.dk...
> 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
Received on Wed Dec 29 2004 - 13:00:11 CST

Original text of this message

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