Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> An Oracle performances question
If in a STORAGE clause, for the creation of a table, I fix a NEXT quite large, when DBMS allocates a new extent it won't probably get used altogether so that there'll be a fragmentation of Database. On the other hand if I set a NEXT quite small it might happen that the table will be split into a great amount of extents throughtout the Database. In which of the previous situations the Oracle performances get worse?
Thanks in advance
VIRGILIO MAIL - Il tuo indirizzo E-mail gratis e per sempre http://mail.virgilio.it/
VIRGILIO - La guida italiana a Internet
http://www.virgilio.it/
-- Posted from [216.163.180.10] via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Thu Jun 15 2000 - 00:00:00 CDT
![]() |
![]() |