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.
[EMAIL PROTECTED]
-----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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
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).
