Database Administration (MOSC)

MOSC Banner

oracle 11.2.0.4 segment extents number investigation in performance managment

edited Mar 14, 2016 6:40AM in Database Administration (MOSC) 7 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center