James's Blog

Oracle: 9i segment level statistics

9i release 2 and higher,
segment statistics could be retrieved from following views.

v$segment_statistics
v$segstat
v$segstat_name

select owner, object_name,statistic_name,value
from v$segment_statistics
where owner='SYSTEM'
and object_name='TABLE'

posted by James Pei @ 3:41 PM