In 9i, you can get a lot from v$segment_statistics (or gv$segment_statistics with RAC) by doing deltas between runs. Don Granaman SQL*Plus-addicted OraSaurus ----- Original Message ----- From: "Daiminger, Helmut" <HELMUT.DAIMINGER@xxxxxx> To: "'LazyDBA.com Discussion'" <oracledba@xxxxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, May 26, 2004 6:36 AM Subject: "Hot" tables in Schema > Hi! > > Does anybody out there know how to get the hot tables in a specific schema > in a specific period of time? I.e. find the tables that get hit the most > during a specific period of time? ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------