Oracle-L: RE: v$sgastat question

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 09 Jan 2003 12:19:12 -0800
Message-ID: <F001.0052BA2C.20030109121912@fatcity.com>

Guang - If you're not familiar with it, go to http://www.hotsos.com/ and get Mogens Norgaard's paper, Introducing the V$ Wait Interface. Where is the database spending it's time? What's the bottleneck?

-----Original Message-----
Sent: Thursday, January 09, 2003 1: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: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------