what is the meaning of statistic_name='space_used' in v$segment_statistics?
From: Baziel de Leeuw <baziel_at_baziel.com>
Date: Wed, 6 Oct 2010 11:51:45 +0200
Message-ID: <AANLkTim460oSD5D7x=y7EyzTUOQJcABVePn4Vd__Cjwc_at_mail.gmail.com>
Hi,
Date: Wed, 6 Oct 2010 11:51:45 +0200
Message-ID: <AANLkTim460oSD5D7x=y7EyzTUOQJcABVePn4Vd__Cjwc_at_mail.gmail.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
Received on Wed Oct 06 2010 - 04:51:45 CDT