From cspence@FuelSpot.com Wed, 13 Jun 2001 06:27:46 -0700
From: Christopher Spence <cspence@FuelSpot.com>
Date: Wed, 13 Jun 2001 06:27:46 -0700
Subject: RE: Question about LMT
Message-ID: <F001.00327766.20010613061120@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: Question about LMT



If you 
plan on still using LMT and want an even extent at the end.
 
"Walking on water and developing software from a 
specification are easy if both are frozen." 
Christopher R. Spence <FONT 
face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS" 
size=2>Fuelspot 

  <FONT face=Tahoma 
  size=2>-----Original Message-----From: DEMANCHE Luc (Cetelem) 
  [mailto:Luc.Demanche@cetelem.fr]Sent: Wednesday, June 13, 2001 8:56 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Question about LMT
  Hi 
  Guy,
  <SPAN 
  class=964174611-13062001> 
  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).
  Is 
  it important to keep this extra 64 Kb when we want to resize the 
  datafiles.
  <SPAN 
  class=964174611-13062001> 
  <SPAN 
  class=964174611-13062001>Luc
  
    -----Message 
    d'origine-----De: Guy Hammond 
    [mailto:guy.hammond@avt.co.uk]Date: Wednesday, June 13, 2001 2:15 
    PMÀ: Multiple recipients of list ORACLE-LObjet: RE: 
    Question about LMT
    
    <SPAN 
    style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hi 
    Luc,
    <SPAN 
    style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> 
    <SPAN 
    style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">If you try to 
    resize a datafile to a size below that of the actual data it contains, 
    Oracle will warn you. Try setting Autoextend on if you're worried about 
    running out of space on a recently shrunk file; looking at your numbers I'm 
    guessing that you have plenty of space on the disk. As long as you keep an 
    eye on the datafile size, it will be fine.
    <SPAN 
    style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> 
    <SPAN 
    style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Cheers,
    <SPAN 
    style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> 
    <SPAN 
    style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">g.
    <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@cetelem.fr] <SPAN 
    style="FONT-WEIGHT: bold">Sent: 13 June 2001 12:05<SPAN 
    style="FONT-WEIGHT: bold">To: Multiple recipients of list 
    ORACLE-LSubject: Question 
    about LMT
    <FONT face="Times New Roman" 
    size=3> 
    <SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi all, 
    
    <SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I created a tablespace in 
    LMT.  I created all my datafiles with an extra 64 Kb for the bitmap 
    index. 
    <SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">My question is : If I want to 
    resize my datafile, do I have to keep this extra 64 Kb ? 
    
    <SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Example : 
          datafile size   = 500M + 64 Kb = 512064 
    Kb         
            <SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">resize to 50M   = 
    51200 or 51264 Kb 
    <SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">TIA 

    <SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">----------------- 
    <SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Luc Demanche 
    <SPAN 
    style="FONT-WEIGHT: bold; FONT-STYLE: italic; FONT-FAMILY: Arial">CETELEM 
    <SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Tél.: 
    01-46-39-14-49 <SPAN 
    style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Fax : 
    01-46-39-59-88