Re: Segment Growth Tracking

Dba_hist_seg_stat. My script sums up space_used_delta but it is not reliable for lobs. There’s also space_used_total, and space_allocated% versions but I don’t recall whether they’re better for lobs.

Thanks,
Andy

On Tue, Jul 12, 2022 at 4:08 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote:

> It’s passing strange that two things in two days scream for “extmon” to be
> updated to handle the current releases and object types of Oracle.
>
>
>
> I am not aware of a supported tool that automatically tracks what you need.
>
>
>
> This should be a built-in feature of Oracle. Because my customers
> desperately needed it I wrote it in the 1990s. Even though I am
> semi-retired I could be bribed to bring it up to date. If Oracle is
> interested, they know where to find me. I’d probably need to change the
> name, since limited extents is no longer an issue (and has not been for a *
> *long** time.)
>
>
>
> mwf
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Sanjay Mishra ("smishra_97")
> *Sent:* Tuesday, July 12, 2022 4:15 PM
> *To:* Oracle List
> *Subject:* Segment Growth Tracking
>
>
>
> Hi
>
>
>
> I had a database where all of a sudden heavy usage of the tablespace is
> used by the Segments. There are 100s of tables/Indexes in 3 schemas using
> this tablespace and the database is over 200Tb with multiple tables daily
> or weekly partitioned. So need help with the following
>
> 1. If someone shares the best way to keep daily segment growth using a
> trigger or scheduler. The main thing is to record Table/Index/Lob segments
> as lots of partitioned tables also have secure files LOBS
>
> 2. Can I get the details from AWR like History Seg Stats or others which
> can show what segment has used lots of space in the last 1-2 days
>
>
>
>
>
> Thanks
>
> Sanjay
>

--
http://www.freelists.org/webpage/oracle-l