Re: interpreting utlestat report

From: <bcmengler_at_my-deja.com>
Date: 2000/04/07
Message-ID: <8cliav$h17$1@nnrp1.deja.com>#1/1

In article <8cl6rn$3un$1_at_nnrp1.deja.com>, Ed Stevens <Ed.Stevens_at_nmm.nissan-usa.com> wrote:
> In reviewing utlestat reports on several of our databases I have
> noticed several things that raised my eybrows – not with the
> performance per se (though there is plenty there as well!) but with
> some things that just don't look "right."
>
> 1) negative numbers for "logons current"
> 2) negative numbers for "opened cursors current"
> 3) negative numbers for "session uga memory"
> 4) negative numbers for undo segment XACTS
> 5) counts for blocks_read and block_changes, but no physical reads or
> writes. I assume this indicates everything was in the buffer pool but
> am not ready to have my feet held to the fire on it.

I suspect 1 of 2 things happened -
1) You left it run for a VERY long time
2) The instance was stopped & restarted during the data collection.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 07 2000 - 00:00:00 CDT