Segment Growth Tracking
From: Sanjay Mishra <"Sanjay>
Date: Tue, 12 Jul 2022 20:15:23 +0000 (UTC)
Message-ID: <657865367.421328.1657656923393_at_mail.yahoo.com>
Date: Tue, 12 Jul 2022 20:15:23 +0000 (UTC)
Message-ID: <657865367.421328.1657656923393_at_mail.yahoo.com>
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 following1. 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 LOBS2. 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
ThanksSanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 12 2022 - 22:15:23 CEST