v$sgastat question

[Guang Mei]

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