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 <[email protected]>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) [ > [email protected]] on behalf of Geoffrey Endresen [[email protected]] > *Sent:* Wednesday, October 26, 2011 10:13 AM > *To:* [email protected] > *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 ARSlist: "Where the Answers Are"_ > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ -- -Geoff Endresen Amazon.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
