the most accessed tables

[JEMERSON]

I´m intending create a tablespace to the most accessed tables and i don´t known how. Does anyone can help me???

[deggzy]

HI,
If you can assign various datafiles to various physical devices wouldn't it be better to split up the most accessed tables ad spread the load over as many devices as you can?

Just a though.

SQLLAB is a good product for object accesses by the way.

Regards,

[JEMERSON]

thanks for the suggestion. But How do i get the most acessed tables???

[JEMERSON]

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?????