SELECT OBJECT, COUNT(SID) FROM V$ACCESS
WHERE TYPE = 'TABLE'
GROUP BY OBJECT
ORDER BY COUNT(SID);
Doing this query do i have the most accessed tables?????
|
Results 1 to 4 of 4
Thread: the most accessed tablesThreaded View
|
Click Here to Expand Forum to Full Width |