Database Administration (MOSC)

MOSC Banner

Is an extent allocation serialized or concurrent/parallel operation?

edited Feb 3, 2012 2:56AM in Database Administration (MOSC) 4 comments
My case: multiple inserts to the same table (100K inserts in 6 secs). Everything went OK, but  almost 90 extents has been allocated, 64M each, almost 5GB together. Much, much  more than was in fact needed. At the and of the day it caused tablespace space allocation problems, so I need an explanation. My explanation is that extent allocation is executed in parallel, until first ~90 inserts requests has been fulfilled, then the rest goes. It seems reasonable, but I can't find any info in any Oracle docs about serialisation or parallelisation of this Oracle core functionality.
I'd be greateful for any, official or not, explanation. Or confirmation

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