Home » RDBMS Server » Server Administration » Autoextend
Autoextend [message #281222] Fri, 16 November 2007 03:14 Go to next message
Messages: 195
Registered: March 2007
Senior Member
On Oracle 10g with DB_Block_Size=8K
Tablespace contains one datafile of size 10GB also Autoextend enabled increase of 500MB .
When does the file gets autoextended.Currently 96% of datafile is full.Is there a threshold when the autoextended occurs or it extends only when the datafile is 100% full.

Re: Autoextend [message #281235 is a reply to message #281222] Fri, 16 November 2007 03:41 Go to previous message
Michel Cadot
Messages: 63912
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
File is extended when it is needed that is when more space than currently available is asked.

Previous Topic: howto get the tablespace size and free space?
Next Topic: How to get patch for patchset 8174 SE from Metalink
Goto Forum:

Current Time: Sun Oct 23 17:15:17 CDT 2016

Total time taken to generate the page: 0.08461 seconds