Re: "Hot" tables in Schema

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 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
> ----------------------------------------------------------------- 

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

Other related posts: