Re: Free Memory in v$sgastat

2003-12-16 Thread Mladen Gogala
. That room is also known as free space. Look into the tuning manual on the OTN and make sure that your buffer cache hit ratio is high enough (sorry folks, I couldn't resist). On 2003.12.15 23:19, Sinardy Xing wrote: Hi all, Why free memory in v$sgastat is a symptom

RE: Free Memory in v$sgastat

2003-12-16 Thread Sinardy Xing
cache hit ratio is high enough (sorry folks, I couldn't resist). On 2003.12.15 23:19, Sinardy Xing wrote: Hi all, Why free memory in v$sgastat is a symptom of the fragmentation? Why these free memory are more properly thought of as wasted space? Thanks

Free Memory in v$sgastat

2003-12-15 Thread Sinardy Xing
Hi all, Why free memory in v$sgastat is a symptom of the fragmentation? Why these "free memory" aremore properly thought of as wasted space? Thanks Sinardy

Re: Free Memory in v$sgastat

2003-12-15 Thread Mladen Gogala
, Why free memory in v$sgastat is a symptom of the fragmentation? Why these free memory are more properly thought of as wasted space? Thanks Sinardy -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET

RE: Free Memory in v$sgastat

2003-12-15 Thread Sinardy Xing
, Sinardy Xing wrote: Hi all, Why free memory in v$sgastat is a symptom of the fragmentation? Why these free memory are more properly thought of as wasted space? Thanks Sinardy -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

v$sgastat question

2003-01-09 Thread Guang Mei
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_size13421772 large_pool_size 614400 java_pool_size 1024000 I also got v$sgastat info

RE: v$sgastat question

2003-01-09 Thread Richard Ji
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

RE: v$sgastat question

2003-01-09 Thread DENNIS WILLIAMS
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_size13421772 large_pool_size 614400 java_pool_size 1024000 I also

Re: v$sgastat question

2003-01-09 Thread Arup Nanda
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

Re: v$sgastat question

2003-01-09 Thread BigP
- 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

RE: v$sgastat question

2003-01-09 Thread Richard Ji
, 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_size13421772 large_pool_size

RE: v$sgastat question

2003-01-09 Thread Deshpande, Kirti
: 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_size13421772 large_pool_size 614400 java_pool_size 1024000

Re: v$sgastat question

2003-01-09 Thread Arup Nanda
Oracle needs some amount in java_pool_szie to startup; not sure how much. From: BigP [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: v$sgastat question Date: Thu, 09 Jan 2003 16:37:16 -0800 MIME-Version: 1.0 Received

Re: v$sgastat question

2003-01-09 Thread Guang Mei
: Wednesday, January 08, 2003 4:00 PM 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_size13421772 large_pool_size 614400 java_pool_size

v$sgastat question

2003-01-08 Thread Guang Mei
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_size13421772 large_pool_size 614400 java_pool_size 1024000 I also got v

Re: v$sgastat question

2003-01-08 Thread Arup Nanda
, but could be less. HTH Arup Nanda www.proligence.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 4:00 PM Hi: I am trying to learn how to make use v$sgastat info in our oracle 8173 db. Here is what I set

RE: v$sgastat question

2003-01-08 Thread DENNIS WILLIAMS
$sgastat info in our oracle 8173 db. Here is what I set for the instance: shared_pool_size 268435456 shared_pool_reserved_size13421772 large_pool_size 614400 java_pool_size 1024000 I also got v$sgastat info: SQL select * from v$sgastat

RE: v$sgastat

2001-08-27 Thread Christopher Spence
To: Multiple recipients of list ORACLE-L Hi lists what is the precision of the number datatype, if not in a table. is it 1 or 32. (in v$sgastat the column bytes doesn't have precision,scale mentioned. this column values should be stored in our routine tables.) If I take the maximum ,I may

v$sgastat

2001-08-25 Thread Tatireddy, Shrinivas (MED, Keane)
Hi lists what is the precision of the number datatype, if not in a table. is it 1 or 32. (in v$sgastat the column bytes doesn't have precision,scale mentioned. this column values should be stored in our routine tables.) If I take the maximum ,I may be wasting the space. can anybody advise