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

Report message to a moderator

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

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 05:52:04 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.