Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: lots of waiting on 'db file parallel write'

Re: lots of waiting on 'db file parallel write'

From: peter <p_msantos_at_yahoo.com>
Date: 28 Feb 2006 12:45:48 -0800
Message-ID: <1141159548.710087.260570@e56g2000cwe.googlegroups.com>


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:32
134 processes: 127 sleeping, 7 on cpu
CPU states: 26.8% idle, 35.5% user, 12.1% kernel, 25.6% iowait, 0.0% swap
Memory: 12G real, 6109M free, 5799M swap in use, 5867M swap free

Thanks for all the great information.
-peter
Received on Tue Feb 28 2006 - 14:45:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US