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


.