Re: analyze command, monitor space/extents

I'm not sure whether dba_clusters exists (or clusters are stored in dba_tables) as I almost never used clusters. That's the only other object type where gathering statistics makes sense.

I would monitor: free space per tablespace objects that almost reached maxextents (I know maxextents unlimited exists, but I don't really like to use it)
objects that can't be extended anymore because there's no sufficient contiguous space.

My 2 Eurocents.

Hth,

Sybrand Bakker, Oracle DBA

Ray Stell <stellr_at_stell.cns.vt.edu> wrote in message news:88jknk$2p0$1_at_solaris.cc.vt.edu...
> Sybrand Bakker (postbus_at_sybrandb.demon.nl) wrote:
> : dba_extents/dba_segments contain information about allocation
> : dba_indexes/_tables ect contain information about actual usage.
> : running
>
>
>
>
>
> it is the etc. part that I am interested in finding out about.
> How can I find out what tables analyze updates. Is it just
> those two tables, dba_indexes/_tables or are there other
> tables that are populated by analyze? All this is
> just digging to try to find out how to monitor space over time
> to make growth projections and management decisions. How do
> real dbas do that, what do they watch for trending/alerts?
>
>
>
>
> : dbms_utility.analyze_schema('<username>','COMPUTE')
> : (or even dbms_utility.analyze_database) should be sufficient to get
actual
> : statistics. Run them in sql*plus by exec <procedurename>.
>
> : Hth,
>
> : Sybrand Bakker, Oracle DBA
>
> : Ray Stell <stellr_at_stell.cns.vt.edu> wrote in message
> : news:88ee28$d94$1_at_solaris.cc.vt.edu...
> : > I want to monitor space/extents of tablespace/tables.
> : > Do you have to run analyze first to do this or
> : > do dba_extents/dba_tables/dba_segments get updated
> : > automatically?
> : >
> : > What tables do you have run analyze to get current data?
> : >
>
>
Received on Fri Feb 18 2000 - 11:03:06 CST