Appropriate size for Autoextending datafile in oracle 10g [message #385050] |
Fri, 06 February 2009 05:19 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3212 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
|