Re: Question about LMT

Guy,
 
I think 64K makes a difference, depending on the size of the uniform extent specified for LMT.
Let say, we create 100M file with 10M extent size and don't add 64K to the size of the file. Then, the last 10M (minus 64K) in the file will be wasted.
 
It does not make a difference only if your extent size <= 64K.
 
Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627<A href="mailto:ineyman_at_perceptron.com">ineyman_at_perceptron.com 

<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message -----
  <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Guy Hammond To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

  Sent: Wednesday, June 13, 2001 10:11
  AM
  Subject: RE: Question about LMT      

<SPAN

  style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Luc,
<SPAN

  style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> 
<SPAN

  style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">How are you   calculating the size you want to resize the <SPAN   class=SpellE>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: 10pt; COLOR: navy; FONT-FAMILY: Arial"> 
<SPAN

  style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">HTH,
<SPAN

  style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> 
<SPAN

  style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">g<FONT   face=Arial color=navy size=2><SPAN
  style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">.
<SPAN

  style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> 
<SPAN

  lang=EN-US
  style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma; mso-ansi-language: EN-US">-----Original   Message-----From: DEMANCHE
  Luc (Cetelem) [mailto:Luc.Demanche_at_cetelem.fr] <SPAN   style="FONT-WEIGHT: bold">Sent: 13 June 2001 13:56<SPAN   style="FONT-WEIGHT: bold">To: Multiple recipients of list   ORACLE-LSubject: RE:
  Question about LMT
<FONT face="Times New Roman"

  size=3>    

<FONT face=Arial color=blue

  size=2>Hi
  Guy,   

<FONT face="Times New Roman"

  size=3>    

<FONT face=Arial color=blue

  size=2>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 face=Arial color=blue

  size=2>Is it
  important to keep this extra 64 Kb when we want to resize the   datafiles.   

<FONT face="Times New Roman"

  size=3>    

<FONT face=Arial color=blue

  size=2><SPAN
  style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Luc   

    <SPAN
    style="FONT-SIZE: 12pt">  Received on Wed Jun 13 2001 - 08:48:07 CDT