Re: what is the meaning of statistic_name='space_used' in v$segment_statistics?

I think the problem here is a column overflow as sometimes happens with for example the statistic "redo size" in v$sesstat, when the number are getting really big, above 4294967296 (32 bit border), the number wents to negative.

Regards,

Gerwin

2010/10/6 Baziel de Leeuw <baziel_at_baziel.com>

> Hi,
>
> What does the statistic_name='space used' column in v$segment_statistics
> show?
>
> I get results i don't understand at all, e.g.
>
> SQL> select owner, object_name, statistic_name, value from
> v$segment_statistics where owner='SYS' and
> object_name='WRI$_OPTSTAT_HISTGRM_HISTORY' and statistic_name='space used';
>
> OWNER OBJECT_NAME STATISTIC_NAME
> VALUE
> ---------- ------------------------------ ---------------
> ------------------
> SYS WRI$_OPTSTAT_HISTGRM_HISTORY space used
> -554110
>
> Yes, that is a negative value.
>
> I expected beforehand that space_used would be something like bytes in
> memory or something like that.
>
> Does anyone know what it actually is?
>
> Baziel
>
>
>

--
http://www.freelists.org/webpage/oracle-l