Home » RDBMS Server » Server Administration » Autoextend
Autoextend [message #281222] Fri, 16 November 2007 03:14 Go to next message
preet_kumar
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.

Thanks
Re: Autoextend [message #281235 is a reply to message #281222] Fri, 16 November 2007 03:41 Go to previous message
Michel Cadot
Messages: 64103
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.

Regards
Michel
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 Dec 04 20:27:56 CST 2016

Total time taken to generate the page: 0.34103 seconds