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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).