question about v$segment_statistics

Giganews Newsgroups
Subject: question about v$segment_statistics
Posted by:  stephan11 (Stephan…@gmx.de)
Date: 22 Nov 2005

i am using the 10g database . if i want statistic information about
tables ( e.g how often a certain table is selected  ) i have to use the
view 'v$segment_statistics' . is this right ?
if i enter the statement :
select distinct owner from v$segment_statistics;
the result of the query is :

OWNER
------
DBSNMP
IX
MDSYS
SYS
SYSMAN
SYSTEM
WKSYS
WMSYS
XDB

why for example does not appear the user HR ?

what do i have to do to get the statistic information from the table
'countries' of the user hr ?

greeting s. f.

Replies