Home » Non-English Forums » Spanish » Tamaño de next e initial ? (Oracle9i sobre Solaris)
| 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: 9105
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.
|
|
|
|
Goto Forum:
Current Time: Fri May 02 06:08:36 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
