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 09:44:37 -0700
Message-ID: <F001.00327E08.20010613084031@fatcity.com>

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>Ah, got it, hadn't considered the extent size.

<span style='font-size:

10.0pt;font-family:Arial;color:navy'> 

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>Thanks,

<span style='font-size:

10.0pt;font-family:Arial;color:navy'> 

<span style='font-size:

10.0pt;font-family:Arial;color:navy'>g.

<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: Igor Neyman
[mailto:ineyman_at_perceptron.com]
Sent<span
style='font-weight:bold'>: <st1:date Month="6" Day="13" Year="2001"><span lang=EN-US style='font-size:10.0pt;  font-family:Tahoma;mso-ansi-language:EN-US'>13 June 2001<font size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma; mso-ansi-language:EN-US'> <font
 size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma;  mso-ansi-language:EN-US'>15:36<font size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma; mso-ansi-language:EN-US'>
To: Multiple recipients of list
ORACLE-L
Subject: Re: Question about LMT

<font size=3

face="Times New Roman"> 

<font size=2

face="Times New Roman">Guy,

<font size=3

face="Times New Roman"> 

<font size=2

face="Times New Roman">I think 64K makes a difference, depending on the size of the uniform extent specified for LMT.

<font size=2

face="Times New Roman">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.

<font size=3

face="Times New Roman"> 

<font size=2

face="Times New Roman">It does not make a difference only if your extent size <= 64K.

<font size=3

face="Times New Roman"> 

<font size=3

face="Times New Roman">Igor Neyman, OCP DBA Perceptron, Inc.
(734)414-4627
ineyman_at_perceptron.com
 

<blockquote style='border:none;border-left:solid black 1.5pt;padding:0cm 0cm 0cm 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>

<span

style='font-size:10.0pt;font-family:Arial'>----- Original Message -----

<font

size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;font-weight: bold'>From:<span style='font-size:
10.0pt;font-family:Arial'> <a href="mailto:guy.hammond_at_avt.co.uk" title="guy.hammond_at_avt.co.uk">Guy Hammond

<span

style='font-size:10.0pt;font-family:Arial;font-weight:bold'>To:<font size=2 face=Arial> <a
href="mailto:ORACLE-L_at_fatcity.com" title="ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

<span

style='font-size:10.0pt;font-family:Arial;font-weight:bold'>Sent:<font size=2 face=Arial> Wednesday,
June 13, 2001 10:11 AM

<span

style='font-size:10.0pt;font-family:Arial;font-weight:bold'>Subject:<font size=2 face=Arial> RE:
Question about LMT

<font size=3

face="Times New Roman"> 

<font size=2 color=navy

face=Arial>Luc,

<font size=2 color=navy

face=Arial> 

<font size=2 color=navy

face=Arial>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.

<font size=2 color=navy

face=Arial> 

<font size=2 color=navy

face=Arial>HTH,

<font size=2 color=navy

face=Arial> 

<font size=2 color=navy

face=Arial>g.

<font size=2 color=navy

face=Arial> 

<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

<span

style='font-size:12.0pt'>  Received on Wed Jun 13 2001 - 11:44:37 CDT

Original text of this message

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