| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_WWK.DE>
> To: "'LazyDBA.com Discussion'" <oracledba_at_lazydba.com>;
> <oracle-l_at_freelists.org>
> 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?
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri May 28 2004 - 01:39:07 CDT
 |
 |