Re: analyze command, monitor space/extents

Completely depends on your situation.
Patrol can do it, OEM with performance pack can do it (can send you an alert when space usage exceeds a threshold) you can have your own scripts like
freespace

select tablespace_name, sum(bytes)/1048576 "M free" from dba_free_space
group by tablespace_name;

nearing maxextents
select owner, segment_name, extents, max_extents from dba_segments
where extents >= trunc(max_extents * 0.9);

not able to extent
select segment_name, next_extent
from dba_segments s
where next_extent >
(select max(extent)
  from dba_free_space f
  where f.tablespace_name = s.tablespace_name)

etc.

To predict is possible when you either spool the output and/or save it in a table, and run the scripts at regular intervals.

Hth,

Sybrand Bakker, Oracle DBA

Ray Stell <stellr_at_stell.cns.vt.edu> wrote in message news:88k3lf$gf8$1_at_solaris.cc.vt.edu...
> Sybrand Bakker (postbus_at_sybrandb.demon.nl) wrote:
> : 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
>
>
> right, that's what I'm asking how to do, also I would like to
> be able to predict when it will happen. How is it done?
>
>
Received on Fri Feb 18 2000 - 13:15:46 CST