Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE : RE: Script for most active tables
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 DBAsReceived on Fri Oct 27 2000 - 03:42:33 CDT
>
> 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.