Yeah - we ended up doing that afterwards. This was during our last major system build when we built 4 systems (Dev/test/training/prod) consecutively. By the time we got to #3 we thought we'd see if it would save time doing it the other way.
William Rentfrow Principal Consultant, StrataCom Inc. [email protected] O 715-592-5185 C 715-410-8056 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Axton Sent: Monday, April 27, 2009 4:30 PM To: [email protected] Subject: Re: Oracle LOB getting very big ** You could also relocate the lobs in row after the installation is complete. This would definitely be much easier if done before there was much data in the system. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Apr 27, 2009 at 4:01 PM, William Rentfrow <[email protected]> wrote: A clever person might decide the obvious solution to this is to install the AR Server, then switch the server setting to "in-row", run the conversion, and then install the rest of the ITSM apps. That clever person would be wrong. We tried this and the ITSM installer (specifically IM and SLM if I remember correctly) conveniently reset the option to out of row storage. This definitely should be an installer option for the AR Server. William Rentfrow Principal Consultant, StrataCom Inc. [email protected] www.williamrentfrow.com O 715-592-5185 C 715-410-8056 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Axton Sent: Monday, April 27, 2009 10:57 AM To: [email protected] Subject: Re: Oracle LOB getting very big ** Nope. Take a look at the recommendation on page 5 of this Oracle white paper: http://www.oracle.com/technology/products/database/application_developme nt/pdf/lob_performance_guidelines.pdf <http://www.oracle.com/technology/products/database/application_developm e%0Ant/pdf/lob_performance_guidelines.pdf> Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Apr 27, 2009 at 10:48 AM, Guillaume Rheault <[email protected]> wrote: ** Unfortunately with the BMC ITSM apps, we don't have a choice of not using LOBs, right? Or do we? -Guillaume -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Axton Sent: Mon 04/27/09 11:42 AM To: [email protected] Subject: Re: Oracle LOB getting very big Unless explicitly defined when creating a lob, storing the lob out of row is the default behavior. I'm guessing the authors wanted to adhere to the defaults. I do know that when performing the ARS installation, the LOB storage parameter for the meta-data tables (e.g, arschema) is set to store the lob in-row. Imho, it's better to just not use lobs. Axton The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Apr 27, 2009 at 9:23 AM, Guillaume Rheault <[email protected]>wrote: > ** > > That is the $60000 question. > Seems to me the ARS installer should ask what the value of that setting > should be set to > > -Guillaume > > > -----Original Message----- > From: Action Request System discussion list(ARSList) on behalf of Misi > Mladoniczky > Sent: Mon 04/27/09 6:40 AM > To: [email protected] > Subject: Re: Oracle LOB getting very big > > Hi, > > Thank you all for the responses. > > One thing confuses me though... > > In all these comparisons, the In-Row-LOB requires less space and is faster. > > Why has BMC set the default to Out-Row-LOB? Especially since older AR > System Versions seems to use the In-Row-LOB setting??? > > Best Regards - Misi, RRR AB, http://www.rrr.se > > Products from RRR Scandinavia: > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > * RRR|Translator - Manage and automate your language translations. > Find these products, and many free tools and utilities, at http://rrr.se. > > > Just for everyone's records, there's also a white paper on the subject: > > > > 17-Mar-2008 Using Oracle CLOBs with BMC Remedy Action Request System > > http://documents.bmc.com/supportu/documents/96/63/89663/89663.pdf > > > > -David J. Easter > > Sr. Product Manager, Solution Strategy and Development > > BMC Software, Inc. > > The opinions, statements, and/or suggested courses of action expressed in > > this E-mail do not necessarily reflect those of BMC Software, Inc. My > > voluntary participation in this forum is not intended to convey a role as > > a spokesperson, liaison or public relations representative for BMC > > Software, Inc. > > > > ________________________________________ > > From: Action Request System discussion list(ARSList) [ > [email protected]] > > On Behalf Of Shellman, David [[email protected]] > > Sent: Friday, April 24, 2009 6:39 AM > > To: [email protected] > > Subject: Re: Oracle LOB getting very big > > > > Misi, > > > > I see Axton replied. He had some good info on this. > > > > Here is a sql command that BMC/Remedy support gave me to show lob space > > allocation > > > > select substr(s.segment_name,1,30) Lobsegment, l.table_name, > > substr(l.column_name,1,12) Column_name, sum(s.bytes/1024/1024) Mbytes > > from user_segments s, user_lobs l > > where l.segment_name = s.segment_name > > having sum(s.bytes/1024/1024) > 100 > > group by s.segment_name, l.table_name, l.column_name > > order by sum(s.bytes/1024/1024); > > > > Dave > > -----Original Message----- > > From: Action Request System discussion list(ARSList) </d_Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] <mailto:sponsor%[email protected]> ARSlist: "Where the Answers Are" _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"
