. 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
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
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
,
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
, 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
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
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
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
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
-
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
, 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
:
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
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
: 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
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
, 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
$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
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
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
19 matches
Mail list logo