|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 :
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.