Oracle-L: RE: v$sgastat question

From: Richard Ji <richard.ji_at_mobilespring.com>
Date: Thu, 09 Jan 2003 12:15:09 -0800
Message-ID: <F001.0052BA10.20030109121509@fatcity.com>

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