Database Administration (MOSC)

MOSC Banner

uniform size and autoallocate of extent in a tablespace

edited Oct 16, 2017 5:00AM in Database Administration (MOSC) 12 commentsAnswered

Hi,

We are using high-performance spinning disk in RAID 10 , instead of SSD technology. We have different tablespace setup with uniform size of  128k, 4m and 128m with total size of 2TB.

our database is OLTP

1) In terms of performance, is uniform size or autoallocate extent recommended in 11g and 12c ?

2) How do we determine if we have apply with the correct uniform size ?

3) my understanding is locally managed tablespace does not has to worry about fragmentation anymore, so does it make any different if we are using uniform or autoallocate in terms of performance ?

Thank you.

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