Tamaño de next e initial ? [message #301145] |
Tue, 19 February 2008 05:47 |
ArielD
Messages: 5 Registered: February 2008 Location: Rosario
|
Junior Member |
|
|
Hola.
Tengo un tablespace gestionado en forma local con un tamaño NEXT de 64K y AUTOALLOCATE.
Dentro de ese tablespace tengo todos los objetos de mi aplicación.
Pregunto, es conveniente tener un valor INITIAL de 64K (1 extensión)para los objetos o me conviene reservar más extensiones en el comienzo para evitar fragmentación ?
Muchas gracias.
|
|
|
|
|
|
Re: Tamaño de next e initial ? [message #301204 is a reply to message #301169] |
Tue, 19 February 2008 09:47 |
|
Barbara Boehmer
Messages: 9100 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
MarcS wrote on Tue, 19 February 2008 05:13 | Could you rephrase the question please, in English would be great ;)
|
rough translation:
Size of next and initial?
I have a local tablespace created with a NEXT size of 64K and AUTOALLOCATE. Inside that tablespace I have all the objects of my application.
I ask, is it better to have an initial value of 64K (1 extension) for the objects or is it better to reserve more extensions in the beginning to avoid fragmentation?
Many thanks.
|
|
|