Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

OATM uniform extent strategy

edited Aug 19, 2021 5:43PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered
 In my first pass of the OATM (Oracle Apps Tablespace Model) utility in release 11.5.10.2, the database actually grew by over 30G to 285G of used space.  Not a huge growth, but not quite what I expeected.  This appears to be because we migrated to uniform extents of either 128k or 1mb and many of the empty/unused tables took a larger initial extent than they had before the migration.  So, I'm thinking of migrating by schema and migrating the unused schemas to tablespaces with small initial extents.  Has anybody else pursued a similar strategy?  That means that future DBA's might have the task
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