Re: Statspack analysis

> a quarter - v$sysstat shows
> 61 centisecond per second CPU.
> (of course, we don't know how many CPUs
> you have - but maybe it's just the one).

its 4 cpus's, but the server also hosts a number of automated programs that access the database.

> But the most anomalous figures are:
>> enqueue releases 897,706 217.8 556.5
>> enqueue requests 897,705 217.8 556.5
> coupled with calls on v$rowcache
>> dc_segments 892,027 0.0 0 0 1,219
>> dc_tablespaces 891,241 0.0 0 0 4
>
> At a guess, you have an object that is growing (and possibly shrinking)
> very rapidly in a tablespace declared with a very small extent size, I
> can't think of any other reason why these figures might be so extreme.

Hmm, could that be in temp tablespace? I think its a locally managed uniform 1M or 4M extents. I will look at it tomorrow. How could I find out what object that is growing and/or shrinking fast?

TIA
Peter Laursen Received on Thu Mar 30 2006 - 16:36:54 CST