Oracle-L: Re: v$sgastat question

From: Guang Mei <zlmei_at_hotmail.com>
Date: Thu, 09 Jan 2003 19:28:50 -0800
Message-ID: <F001.0052C030.20030109192850@fatcity.com>

Hi,

I am using neither MTS nor RMAN. I set the large_pool_size to zero now. I also set the java_pool_size to 32768 and it works in oracle 8173, although I seem to remember the minimum java_pool_size was 1M in oracle 805. Also I had ORA-04031 error during exp (in oracle 805) and I increased the java_pool_size to 20M and the exp error disappeared. I have not tried to exp in oracle 8173 with java_pool_size = 32K yet.

Guang

A few additional exploratory questions:

Are you using Shared Server (aka Multi Threaded Server) connection model? Are you using RMAN?

If the answer to both the questions is no, then you are wating the memory by setting the large_pool_size. I don't know when you took the snapshot of the query, but if you took that after the database has been up for a while, it looks like the answer is no to both the questions.

If you are not using java then limit your java pool. There is a bare minimum it needs to start the database; not sure how much. In databases (8.1.7.4), I have set it at 32768, but could be less.

HTH Arup Nanda
www.proligence.com

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 08, 2003 4:00 PM

>Hi:
>
>I am trying to learn how to make use v$sgastat info in our oracle 8173 db.
>
>Here is what I set for the instance:
>
>shared_pool_size 268435456
>shared_pool_reserved_size 13421772
>large_pool_size 614400
>java_pool_size 1024000
>
>I also got v$sgastat info:
>
>SQL> select * from v$sgastat;
>
>POOL NAME BYTES
>----------- -------------------------- ----------
> fixed_sga 73888
> db_block_buffers 409600000
> log_buffer 1024000
...

MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: zlmei_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).

Received on Thu Jan 09 2003 - 21:28:50 CST