From guy.hammond@avt.co.uk Wed, 13 Jun 2001 09:44:37 -0700 From: Guy Hammond Date: Wed, 13 Jun 2001 09:44:37 -0700 Subject: RE: Question about LMT Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: Question about LMT Ah, got it, hadn't considered the extent size.   Thanks,   g.   -----Original Message----- From: Igor Neyman [mailto:ineyman@perceptron.com] Sent: 13 June 2001 15:36 To: Multiple recipients of list ORACLE-L Subject: 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 DBA Perceptron, Inc. (734)414-4627 ineyman@perceptron.com  
----- Original Message ----- From: Guy Hammond To: Multiple recipients of list ORACLE-L Sent: Wednesday, June 13, 2001 10:11 AM Subject: RE: Question about LMT   Luc,   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.   HTH,   g.   -----Original Message----- From: DEMANCHE Luc (Cetelem) [mailto:Luc.Demanche@cetelem.fr] Sent: 13 June 2001 13:56 To: Multiple recipients of list ORACLE-L Subject: RE: Question about LMT   Hi Guy,   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.   Luc