RE: Question about LMT
Title: Question about LMT Hi Luc, 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. Cheers, g. -Original Message- From: DEMANCHE Luc (Cetelem) [mailto:[EMAIL PROTECTED]] Sent: 13 June 2001 12:05 To: Multiple recipients of list ORACLE-L Subject: Question about LMT Hi all, I created a tablespace in LMT. I created all my datafiles with an extra 64 Kb for the bitmap index. My question is : If I want to resize my datafile, do I have to keep this extra 64 Kb ? Example : datafile size = 500M + 64 Kb = 512064 Kb resize to 50M = 51200 or 51264 Kb TIA - Luc Demanche CETELEM Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88
RE: Question about LMT
Title: 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 -Message d'origine-De: Guy Hammond [mailto:[EMAIL PROTECTED]]Date: Wednesday, June 13, 2001 2:15 PMÀ: Multiple recipients of list ORACLE-LObjet: RE: Question about LMT Hi Luc, 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. Cheers, g. -Original Message-From: DEMANCHE Luc (Cetelem) [mailto:[EMAIL PROTECTED]] Sent: 13 June 2001 12:05To: Multiple recipients of list ORACLE-LSubject: Question about LMT Hi all, I created a tablespace in LMT. I created all my datafiles with an extra 64 Kb for the bitmap index. My question is : If I want to resize my datafile, do I have to keep this extra 64 Kb ? Example : datafile size = 500M + 64 Kb = 512064 Kb resize to 50M = 51200 or 51264 Kb TIA - Luc Demanche CETELEM Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88
RE: Question about LMT
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 Oracle DBA Fuelspot -Original Message-From: DEMANCHE Luc (Cetelem) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 13, 2001 8:56 AMTo: Multiple recipients of list ORACLE-LSubject: 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 -Message d'origine-De: Guy Hammond [mailto:[EMAIL PROTECTED]]Date: Wednesday, June 13, 2001 2:15 PMÀ: Multiple recipients of list ORACLE-LObjet: RE: Question about LMT Hi Luc, 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. Cheers, g. -Original Message-From: DEMANCHE Luc (Cetelem) [mailto:[EMAIL PROTECTED]] Sent: 13 June 2001 12:05To: Multiple recipients of list ORACLE-LSubject: Question about LMT Hi all, I created a tablespace in LMT. I created all my datafiles with an extra 64 Kb for the bitmap index. My question is : If I want to resize my datafile, do I have to keep this extra 64 Kb ? Example : datafile size = 500M + 64 Kb = 512064 Kb resize to 50M = 51200 or 51264 Kb TIA - Luc Demanche CETELEM Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88
Re: Question about LMT
Title: 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[EMAIL PROTECTED] - 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:[EMAIL PROTECTED]] Sent: 13 June 2001 13:56To: Multiple recipients of list ORACLE-LSubject: 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
RE: Question about LMT
Title: Question about LMT Also note, if you try resizing a datafile smaller than it has ever been, it will complain. In other words, if you have a 500M datafile and used 400M, then drop 300M, you cannot resize it to 100M. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Guy Hammond [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 13, 2001 8:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Question about LMT Hi Luc, 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. Cheers, g. -Original Message-From: DEMANCHE Luc (Cetelem) [mailto:[EMAIL PROTECTED]] Sent: 13 June 2001 12:05To: Multiple recipients of list ORACLE-LSubject: Question about LMT Hi all, I created a tablespace in LMT. I created all my datafiles with an extra 64 Kb for the bitmap index. My question is : If I want to resize my datafile, do I have to keep this extra 64 Kb ? Example : datafile size = 500M + 64 Kb = 512064 Kb resize to 50M = 51200 or 51264 Kb TIA - Luc Demanche CETELEM Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88
RE: Question about LMT
Title: 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:[EMAIL PROTECTED]] 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
RE: Question about LMT
Guy, Welcome back, we've missed you (and especially your Friday recipes!) Rachel >From: Guy Hammond <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Question about LMT >Date: Wed, 13 Jun 2001 04:15:22 -0800 > >Hi Luc, > >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. > >Cheers, > >g. > >-Original Message- >Sent: 13 June 2001 12:05 >To: Multiple recipients of list ORACLE-L > >Hi all, >I created a tablespace in LMT. I created all my datafiles with an extra 64 >Kb for the bitmap index. >My question is : If I want to resize my datafile, do I have to keep this >extra 64 Kb ? >Example : datafile size = 500M + 64 Kb = 512064 Kb > resize to 50M = 51200 or 51264 Kb >TIA >- >Luc Demanche >CETELEM >Tél.: 01-46-39-14-49 >Fax : 01-46-39-59-88 _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Question about LMT
Title: Question about LMT Ah, got it, hadn't considered the extent size. Thanks, g. -Original Message- From: Igor Neyman [mailto:[EMAIL PROTECTED]] 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 [EMAIL PROTECTED] - 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:[EMAIL PROTECTED]] 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
RE: Question about LMT
Title: Question about LMT i agree, I think the 64k is a mute point, at worse case you have one unusable extent at the end when using LMT. But if your extents are 100M, it may be a little issue. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Guy Hammond [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 13, 2001 10:11 AMTo: Multiple recipients of list ORACLE-LSubject: 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:[EMAIL PROTECTED]] Sent: 13 June 2001 13:56To: Multiple recipients of list ORACLE-LSubject: 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
RE: Question about LMT
Guy, Welcome back !! Rachel tried her best to keep those Friday recipes coming.. but some thought it was spam ;) And then she gave up ! Looking forward to Friday !! - Kirti > -Original Message- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, June 13, 2001 10:07 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Question about LMT > > Guy, > > Welcome back, we've missed you (and especially your Friday recipes!) > > Rachel > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[OFF TOPIC] RE: Question about LMT
Hi Rachel, I kinda got sidetracked into being a system analyst for a bit, but now I'm a DBA again (at a different company). It's all coming back to me... then Oracle decided to go and release a whole 'nother version, 9i. I'll try to dig out a recipe for Friday. Incidentally, if anyone's watching UK television tonight, it's the episode of Nigella in which she goes out drinking then cooks hangover/morning after food. Excellent! :0) g. -Original Message- Sent: 13 June 2001 16:07 To: Multiple recipients of list ORACLE-L Guy, Welcome back, we've missed you (and especially your Friday recipes!) Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [OFF TOPIC] RE: Question about LMT
Nigella I think I want to see this. And I know I want to know what hangover/morning after food is! We've missed you. I sent recipes to the list but I doubt they were as good as yours. You are not the only one overwhelmed at the thought of ANOTHER release to learn! Rachel >From: Guy Hammond <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: [OFF TOPIC] RE: Question about LMT >Date: Wed, 13 Jun 2001 09:56:44 -0800 > >Hi Rachel, > >I kinda got sidetracked into being a system analyst for a bit, but now I'm >a >DBA again (at a different company). It's all coming back to me... then >Oracle decided to go and release a whole 'nother version, 9i. > >I'll try to dig out a recipe for Friday. Incidentally, if anyone's watching >UK television tonight, it's the episode of Nigella in which she goes out >drinking then cooks hangover/morning after food. Excellent! :0) > >g. > > >-Original Message- >Sent: 13 June 2001 16:07 >To: Multiple recipients of list ORACLE-L > >Guy, > >Welcome back, we've missed you (and especially your Friday recipes!) > >Rachel > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Guy Hammond > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [OFF TOPIC] RE: Question about LMT
I don't know if she has a web site, but this is one of her books: http://www.amazon.co.uk/exec/obidos/ASIN/0701168889/o/qid=992607058/sr=8 -1/202-3082814-8953423 I hear that her TV series will be coming on in the US soon. Her cooking style is very compatible with my own, full-fat ingredients and large servings! :0) g. -Original Message- Sent: 13 June 2001 20:01 To: Multiple recipients of list ORACLE-L Nigella I think I want to see this. And I know I want to know what hangover/morning after food is! We've missed you. I sent recipes to the list but I doubt they were as good as yours. You are not the only one overwhelmed at the thought of ANOTHER release to learn! Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [OFF TOPIC] RE: Question about LMT
Actually, this is a better URL: http://www.amazon.co.uk/exec/obidos/ASIN/0701172878/o/qid=992607528/sr=8 -1/202-3082814-8953423 g. -Original Message- Sent: 13 June 2001 20:01 To: Multiple recipients of list ORACLE-L Nigella I think I want to see this. And I know I want to know what hangover/morning after food is! We've missed you. I sent recipes to the list but I doubt they were as good as yours. You are not the only one overwhelmed at the thought of ANOTHER release to learn! Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).