Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE : RE: Script for most active tables

RE : RE: Script for most active tables

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Fri, 27 Oct 2000 10:42:33 +0200
Message-Id: <10662.120398@fatcity.com>


Jim,

   IMHO there is no such thing as AUDIT for what you want - you'll get all the information you want from the audit trail.

-- 
Regards,

  Stephane Faroult
  email: sfaroult_at_oriolecorp.com 
  Oriole Corporation
  Voice:  +44  (0) 7050-696-269 
  Fax:    +44  (0) 7050-696-449 
  Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs

>
> Thanks all,
>
> I'm still looking around for a script. Estat/bstat only gives tablespace or datafile info i'm looking for
> the same kind of info at the table level.
>
> ...JIM...
>
> >>> Winnie_Liu_at_infonet.com 10/25/00 5:35:51 PM >>>
>
>
> I think utlbstat/utlestat only tell you what tablespace/datafile is
> active... unless your whole table is in that particular datafile, or else I
> don't think bstat/estat will tell you much.
Received on Fri Oct 27 2000 - 03:42:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US