Re: "Hot" tables in Schema

In 10g you can even see the number of scans against each segment. I must point out, although with a weak and humble voice, that this fixed view doesn't have a time-based column, and I have yet to see anywhere in an Oracle database where there's a correlation between number of times something happened and the time it took. But it's only a mild critique. Remember when v$lock wasn't time-enabled? Now that it is we can see the lack of correlation. The same happened in 9i when v$sql suddenly both had elapsed and cpu columns. No correlation (because of the different kinds of LIO's and their very different costs).

Mogens

Mogens

Don Granaman wrote:

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 http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------


---------------------------------------------------------------- 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 http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------

Other related posts: