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 Go to next message
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 #301169 is a reply to message #301145] Tue, 19 February 2008 07:13 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Could you rephrase the question please, in English would be great Wink
Re: Tamaño de next e initial ? [message #301187 is a reply to message #301145] Tue, 19 February 2008 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Moving it to spanish forum.

Regards
Michel
Re: Tamaño de next e initial ? [message #301193 is a reply to message #301145] Tue, 19 February 2008 08:10 Go to previous messageGo to next message
ArielD
Messages: 5
Registered: February 2008
Location: Rosario
Junior Member
I'm sorry.

Regards.
Re: Tamaño de next e initial ? [message #301204 is a reply to message #301169] Tue, 19 February 2008 09:47 Go to previous message
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.


Previous Topic: Lista de API's
Next Topic: particion por mes sin incluir el año (columna tipo DATE)
Goto Forum:
  


Current Time: Sat Nov 23 03:30:24 CST 2024