Nov 09, 2017 at 06:37 AM

ORACLE DRAMATICALLY AUTOEXTENDS DATAFILE

1150 Views Last edit Nov 10, 2017 at 01:12 AM 8 rev

Good day!

Can you help me with this one?

I have 3 datafiles, all of them are set to autoextend on next 100MB, maxsize is 32GB.

Last october 28 in the morning, those 3 files are extended for a total of 15GB.

Therefore, each datafile was increased to 5GB. When I checked it Oct30, the usage has not grown that much (actually not at all) so how come will the datafile autoextend itself up to 5GB?

I already checked the increment size in Oracle enterprise manager and it says 100MB.

AND.. there are no manual extensions done here. Checked the logs already.

My questions are,

1. Where did that 5GB come from?

2. How does Oracle autoextend its datafile? I just want to know the process.

Fo example,

Autoextend=100MB, MAXSIZE=32GB

If there is a huge data of 15GB and Oracle has to extend the datafile until it has enough space. Does it extends 100MB for 150 times so it can fulfill 15GB? or it will extend 15GB for one time and neglect the 100MB setting for autoextend?

Please I need advices. Thank you!!