Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question about LMT
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>Luc,
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>How are you calculating the size you want
to resize the datafiles to? If it
is based on how much they are actually used, then no. If it is based on
an external calculation of how much space you expect to use, then yes, but 64k
won't make much difference when you're dealing with files of
hundreds of megabytes.
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>HTH,
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>
<span
style='font-size:10.0pt;font-family:Arial;color:navy'>g<font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>.
<span style='font-size:
10.0pt;font-family:Arial;color:navy'>
<span
lang=EN-US style='font-size:10.0pt;font-family:Tahoma;mso-ansi-language:EN-US'>-----Original
Message-----
From: DEMANCHE Luc (Cetelem)
[mailto:Luc.Demanche_at_cetelem.fr]
Sent: 13 June 2001 13:56
To: Multiple recipients of list
ORACLE-L
Subject: RE: Question about LMT
<font size=3
face="Times New Roman">
<font size=2 color=blue
face=Arial>Hi Guy,
<font size=3
face="Times New Roman">
<font size=2 color=blue
face=Arial>My
question is only for the extra 64 Kb. When we created datafiles, we added
64 Kb for the last extend (because bitmap index need only 64 Kb).
<font size=2 color=blue
face=Arial>Is it
important to keep this extra 64 Kb when we want to resize the datafiles.
<font size=3
face="Times New Roman">
<font size=2 color=blue
face=Arial>Luc
Received on Wed Jun 13 2001 - 10:28:09 CDT