Re: v$sgastat question

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).