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