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@xxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *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
