Home » RDBMS Server » Server Administration » Autoextend
Autoextend [message #281222] Fri, 16 November 2007 03:14 Go to next message
Messages: 197
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: 65087
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: Tue Jul 25 12:13:24 CDT 2017

Total time taken to generate the page: 0.10240 seconds