Home » RDBMS Server » Server Administration » Appropriate size for Autoextending datafile in oracle 10g (oracle 10g 10.2.0.3.0 on linux 64 bit)
Appropriate size for Autoextending datafile in oracle 10g [message #385050] Fri, 06 February 2009 05:19 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,

I am using Oracle 10g 10.2.0.3.0 on linux 64 bit, one thing i want to find out that i have my schema datafile, which set on autoextend, i have set next size to 100mb, if the file reaches to its full does it make us wait for long to create a place of 100mb or should i reduce the size from 100mb to 10mb.

What should be the appropriate Next size in Autoextend for oracle database in my case.


Re: Appropriate size for Autoextending datafile in oracle 10g [message #385062 is a reply to message #385050] Fri, 06 February 2009 05:43 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Depends on your case.

How big is the database, how fast is it growing, how much space have you left, how fast are your drives, etc....

As a rule of thumb I make the autoextend size at least so big that files are not autoextended more than once a day or so.

For ~500GB Tablespace wich I expect to grow by about 200MB a week I have it's set to 100MB for example, for a leeeeeeetle ~50MB tablespace where I have no clue yet wheter it will grow or not I have set it to 10MB for now.
Re: Appropriate size for Autoextending datafile in oracle 10g [message #385071 is a reply to message #385050] Fri, 06 February 2009 06:00 Go to previous messageGo to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
We have 16GB RAM with 300gb hard disk and our data increased more than 100MB a day, my question is Next size of Autoextend is 100mb it will take more time to create than creating 10mb, and it can affect performance of database during work hours.

If performance of database degraded,
How do i check that it is the main reason behind the performance problem? beacause i do not have facility of Database diagnostic tools.


Re: Appropriate size for Autoextending datafile in oracle 10g [message #385084 is a reply to message #385050] Fri, 06 February 2009 06:36 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
Doesn't matter I suppose.
If oracle needs 100mb space then with 10m extents,oracle would allocate 10 times 10m space.
For a 100m extent,it would allocate once, the time taken would be the same.
Previous Topic: Error while creating Database in 10.2.0.4.0.OS is HP-UX 11.11 (merged 3)
Next Topic: Discrepancy between NLS_RDBMS_VERSION and DBA_REGISTRY (merged)
Goto Forum:
  


Current Time: Wed Dec 07 04:58:06 CST 2016

Total time taken to generate the page: 0.11129 seconds