Correct - also, if you are using Solaris + remote Oracle db the performance takes a huge hit if you are using out-of-row.
However, we are using IN-ROW! :) And the space is still being consumed at a ridiculous rate - I can't believe I didn't mention that but it was rather late last night when I wrote this. William Rentfrow Principal Consultant, StrataCom Inc. [email protected] O 715-592-5185 C 715-410-8056 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: Wednesday, November 18, 2009 1:21 AM To: [email protected] Subject: Re: Oracle in-row LOB storage issue - IM 7.03 Hi, In most cases, as I understand, it is definitely better to not use the out-row-lob-setting. This will save a lot of space and time for the DB. Best Regards - Misi, RRR AB, http://rrr.se/sv/ > I've read a LOT of the documentation, etc, regarding how LOB storage > works (including Axton's very fine wiki on this topic) and I'm pretty > familiar with it in theory. > > We are doing a data migration at the moment which is using an enormous > amount of space. We are in the process of migratiing 330,000 records > as a test. > > This has used (so far) 33 GB of table space. We only have 47 GB in > this test system. Considering the actual ARX exports were < 1 GB > something is clearly not right here. > > Initial consultation with a DBA has indicated these rows in the T1114 > (aka, HPD:HelpDesk) are LOB's: > > C1000005940 z1D Template Related CI > C1000000151 Detailed Decription > C1000000156 Resolution > C1000003742 z1D Mobile Worklog Upd > C300270900 Reason Description > > All of these are character fields set to 0 (unlimited) length. > > The questions I have are: > > 1.) If a LOB is > 4K it is stored out of row regardless. Can anyone > tell me how to determine the space used by any of those particular > fields in Oracle? And how I can tell if these are in fact being > stored out of row due to the "unlimited" option on the field? > > 2.) Aren't z1D fields supposed to be Display only according to > Remedy's design and naming conventions? I'm pretty sure that is the > case but both of the fields above with that prefix are stored as optional. > > Thanks in advance - > > William Rentfrow > Principal Consultant, StrataCom Inc. > [email protected] > O 715-592-5185 > C 715-410-8056 > > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
