Re: "Hot" tables in Schema
- From: Connor McDonald <hamcdc@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 30 May 2004 09:09:37 +0100 (BST)
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@xxxxxxxxxxxx> 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@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
> -----------------------------------------------------------------
=====
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@xxxxxxxxx
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@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
-----------------------------------------------------------------
Other related posts:
