Re: Session Stats

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Wed, 28 May 2003 17:37:52 -0700
Message-ID: <ADcBa.56682$MJ5.39004@fed1read03>

Billy Verreynne wrote:
> How bad is bad when a v$session_stat becomes a very large negative value
> (over a billion) for a v$statname like table scan rows gotten?
>
> Oracle 8.1.7 (HP-UX 11).
>
> --
> Billy

32-bit integers can "only" count up to ~=2GB before the highest order bit gets set at which time the OS interprets it as a negative value. It really does not hurt anything except for making useful determinations from those values. Received on Wed May 28 2003 - 19:37:52 CDT