Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question about LMT

RE: Question about LMT

From: Guy Hammond <guy.hammond_at_avt.co.uk>
Date: Wed, 13 Jun 2001 08:28:09 -0700
Message-ID: <F001.00327798.20010613061122@fatcity.com>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US