Setting the field in the configuration file is not enough. You have to also run the stored procedure to update all of the tables to "In-Row" storage. Any new tables created by the arserver will use in-row storage. The lob storage conversion stored procedure is found in the "RemedyAndOracleCLOBs.pdf" document.
Other things to check: 1. Do you have a lot of Indexes on HPD:HelpDesk? If so consider reducing any unnecessary indexes. The more indexes you add the slower the "INSERT INTO" sql statement ... 2. Do you have any custom workflow that may be causing a delay? 3. Have you considered increasing the memory available to the DB? (By far the biggest performance improvement you will get) 4. Do you have Oracle Cursor sharing set to SIMILAR on both the Oracle DB and in the ar.conf file? Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of SriSamSri Appecherla Sent: Monday, July 12, 2010 4:00 PM To: arslist@ARSLIST.ORG Subject: Poor performance while saving Incidents ** Hi, Creating incidents is taking a lot of time. When I create an Incident, it is taking about 20-25 seconds to save, though I have set the Store LOB in row option from the server information window. I checked the SQL logs and found that a lot of time is wasted while setting the LOB fields. ARS 7.5, Patch 3 (in server group) Oracle 11g Sun Solaris 10 Please help. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
