Re: Autoextend

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Sat, 15 Jan 2005 09:01:45 -0800
Message-ID: <ttCdnd-VDeP70XTcRVn-gQ@comcast.com>

<jcpj_mx_at_yahoo.com.mx> wrote in message
news:1105808224.083127.172190_at_z14g2000cwz.googlegroups.com...
> I have a question regarding autoextend, how can affect my database if
> the size of autoextend is 100K, I think is to small, the max size is
> 2 gb and is an OLTP database
>

Think about it. You are asking the OS to allocate another set of disk blocks of 100k and you are probably doing it frequently. (depends how fast the tablespace is growing). Ouch. Might be better to ask for larger chunks less frequently.

You could bench mark it.
Jim Received on Sat Jan 15 2005 - 11:01:45 CST