Hi Geoff, one more thing: If your clobs were not in row BEFORE you installated the ITSM apps, you may want to contact BMC support so they give you the procedure on how to convert out-of-row clobs into in-row clobs. The ar.conf setting will not convert anything, it is only used when new unlimited (actually greater than 4000 characters) or diary fields are being created....
Guillaume ________________________________ From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Guillaume Rheault [guilla...@dcshq.com] Sent: Monday, October 31, 2011 11:03 AM To: arslist@ARSLIST.ORG Subject: Re: Any recommendations on Oracle 11.2 init.ora settings with v7.1 ** Hi Geoff, The recommendation on CLOBs is to have them inline. So the entry in the ar.conf file should be: Oracle-Clob-Storage-In-Row: T The results cache is a new 11g feature... what I am referring to is to alter the T tables related to the looukp ITSM forms so they are kept in the KEEP cache, which is the memory area where the tables are pinned. Ask your DBA about it, he should know about it. The partitioning of the tables is not done at the Remedy level, it is done at the database level. Again your DBA should be familiar with this... Guillaume ________________________________ From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Geoffrey Endresen [geoffer...@gmail.com] Sent: Wednesday, October 26, 2011 2:06 PM To: arslist@ARSLIST.ORG Subject: Re: Any recommendations on Oracle 11.2 init.ora settings with v7.1 ** Guilluame, Thanks for the reply. We have around 20GB shared on a huge DB host that is only for Remedy. > In addition to the documented usual settings (cursor sharing = FORCE, in-line > CLOB) We are using FORCE. What is the in-line CLOB recommendation? > consider pinning in memory the ITSM lookup tables (people, user, group, > support groups, categorizations, etc). Good Idea. This is the same as the results cache, right? >Also consider partitioning your transaction tables (incidents, tasks, etc). I did not know that a Remedy tables could actually be partitioned. For example HPD:HelpDesk has too many entries. It would be great to have the T-table that coule be partitioned by Create_Date. How is that done? Thanks, -Geoff On Wed, Oct 26, 2011 at 7:31 AM, Guillaume Rheault <guilla...@dcshq.com<mailto:guilla...@dcshq.com>> wrote: ** How much memory do you have on your database server? Is it a dedicated database to Remedy? In addition to the documented usual settings (cursor sharing = FORCE, in-line CLOB) consider pinning in memory the ITSM lookup tables (people, user, group, support groups, categorizations, etc). Also consider partitioning your transaction tables (incidents, tasks, etc). In any case, your DBA should run the SQL Tuning Advisor, SQL Access Advisor and SQL Performance Advisor, and analyze the recommendations Guillaume ________________________________ From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] on behalf of Geoffrey Endresen [geoffer...@gmail.com<mailto:geoffer...@gmail.com>] Sent: Wednesday, October 26, 2011 10:13 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Any recommendations on Oracle 11.2 init.ora settings with v7.1 ** All, I've seen a few people that are using the 11.2 Oracle with the Oracle 10g client from the application servers. I'm interested in oracle settings in the init.ora that give best performance for a shared DB server for a Server Group. We have about 12 hosts in our server group now. We don't plan to upgrade to v7.6 until next year. The only setting we are currently using is the ar.conf setting for Cursor Sharing = FORCE -- -Geoff Endresen Amazon.com _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ -- -Geoff Endresen Amazon.com _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
