Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: lots of waiting on 'db file parallel write'
Thanks for the links Joel.
Looking that v$bh the following query returns..
1 select decode( status, 'free', 'free', 'used' )status,count(*)
2 from v$bh
3* group by decode( status, 'free', 'free', 'used' )
STATUS| COUNT(*)
---------|----------
free | 2
used | 248385
It appears to stay this way throughout the day... Not sure if that's
good or not.
I will look through the docs and see where the KEEP and/or RECYCLE
pools might
benefit me.
I don't think I'm swapping... the machine has 12GB of memory of which
I've allocated
5GB to SGA .. I'm currently using about 3GB (DB_CACHE_SIZE=2GB,
SHARED_POOL = 1GB) so I can dynamically increase the memory if I need
to.
My pga_aggregate_target is set to 1500MB so that still leaves me about 6GB of memory ...
Here is some output from top. (This is a 12 cpu machine).
load averages: 6.61, 6.92, 7.11
15:44:32134 processes: 127 sleeping, 7 on cpu
Thanks for all the great information.
-peter
Received on Tue Feb 28 2006 - 14:45:48 CST