Do you really need java pool ? If not get rid of it . set it to 0.
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Thursday, January 09, 2003 2:44 PM
> Guang,
>
> Earlier I posted a response to check java pool and large pool parameters.
> Any progress on that?
>
> Arup.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, January 09, 2003 3:15 PM
>
>
> > Then you should look into statspack and get a copy of "Oracle
Performance
> > Tuning 101".
> >
> > -----Original Message-----
> > Sent: Thursday, January 09, 2003 2:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi:
> >
> > My objective is to see if there is anything that I can change on db
> setting
> > to increase the performance, without modifying application code (BTW, we
> > already looked at all application code at least 5 times and would like
to
> > see if our db setting is good).
> >
> > Guang
> >
> > -----Original Message-----
> > Date: Wed, 8 Jan 2003 15:31:59 -0600
> >
> > Guang - What is your objective? What would you define as an improvement?
> >
> > Dennis Williams
> > DBA, 40%OCP
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> >
> >
> > -----Original Message-----
> > Sent: Wednesday, January 08, 2003 3:00 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > 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
> > shared pool free memory 20906472
> > ....
> >
> >
> > _________________________________________________________________
> > Help STOP SPAM: Try the new MSN 8 and get 2 months FREE*
> > http://join.msn.com/?page=features/junkmail
> >
> > --
> > 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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Richard Ji
> > INET: richard.ji_at_mobilespring.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).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Arup Nanda
> INET: arupnanda_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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: BigP
INET: big_planet_2000_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 - 18:37:16 CST
