If meomry serves, a poke around under the v$segstat covers reveals a unexposed date column in the
underlying x$ view. Possibly unexposed due to errors currently, but still worth a look
hth
connor
- Mogens_Nørgaard <mln_at_miracleas.dk> wrote: > 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?
> >
> >
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > 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_at_freelists.org
> 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
> -----------------------------------------------------------------
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174
web:
http://www.oracledba.co.uk
web:
http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
Coming Soon! "Oracle Insight - Tales of the OakTable"
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
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
-----------------------------------------------------------------
Received on Sun May 30 2004 - 03:06:44 CDT