what is the meaning of statistic_name='space_used' in v$segment_statistics?
- From: Baziel de Leeuw <baziel@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 6 Oct 2010 11:51:45 +0200
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
Other related posts:
