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"
