OraFAQ Forum: Server Administration » Extent Allocation Sequence

Home » RDBMS Server » Server Administration » Extent Allocation Sequence

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Extent Allocation Sequence [message #204296]

Mon, 20 November 2006 00:51

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

I have two datafile in a tablespace of 2gb each
Both of files set to autoextend ,One of the file is going to be 100% full but another newly created datafile is not used yet

My Question Is?
When an extent in that particular tablespace needed to be allocated
and first datafile is 100% used
what will be sequence?
Either it'll extend the first file or extent will be allocated from a newly created datafile

And when both of files are 100% full and what will happen then?

Thanx in advance

Report message to a moderator