Hi,
The best way to find your hot tables is asking this question to the
designers/developers.
Another options would be
o querying v$sql views (hard work)
o using a tuning tool
o $ORACLE_HOME/rdbms/admin/catio.sql -> will show info about the database
buffer cache, take care to not overload your db.

HTH
Fabio

--- "Tan, Noel - ESM" <[Email Address Removed] escreveu: > how can I find out which
table/s is mostly used of an application? because
> that my basis on putting index, right?
>
> TA
>

_______________________________________________________________________________________________
Yahoo! GeoCities
Tenha seu lugar na Web. Construa hoje mesmo sua home page no Yahoo! GeoCities. É fácil e grátis!
http://br.geocities.yahoo.com/
Oracle LazyDBA home page