oracle 11.2.0.4 segment extents number investigation in performance managment
Hi: I am facing a single instance database in version = 11.2.0.4 that has been run for 9 years, tables were designed 9 years ago, include storage parameters of: initial_extent, next_extent, max_extent. Over the past years some tables grow, some tables shrink; there is housekeeping script that delete data older than '7 days', run daily at end-of-day. Total data amount in user schema didn't grow much, probably 1GB per year only.
we can view each tables extents in our quarterly<< Oracle database Healthcheck report>> run by Oracle support, same for Index, Lob table, Lob index; It is a snapshot report, we compare it quarter-by-quarter.