RE: Segment Growth Tracking

nice. I missed they added that. So tracking the total (daily, weekly, monthly, or quarterly) into a user table should make it easy to feed into a spreadsheet to project needs, so that allocation of extents can be driven during database slack time and capacity planning can be done.  

Any further information on what is unreliable for lobs? Is it just the delta is fubar, or is the total also broken?  

My old tool dumped the history using actual space in use per object, but that was long before dba_hist_seg_stat existed. That is a lot of nice performance data in that object as well.  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andy Sayer Sent: Tuesday, July 12, 2022 7:14 PM
To: mwf_at_rsiz.com
Cc: Oracle List; smishra_97_at_yahoo.com Subject: 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