question about v$segment_statistics

From: stephan11 <Stephan11_at_gmx.de>
Date: 22 Nov 2005 14:33:59 -0800
Message-ID: <1132698839.202200.250030@g14g2000cwa.googlegroups.com>

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. Received on Tue Nov 22 2005 - 16:33:59 CST