We turned the Cursor Sharing (SIMILIAR) on a couple of months ago and it made a big improvement in in the Oracle server Remedy uses the IDs. You could always drop the old field and use the archgid utility to change the ID and rename the field. Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Thursday, June 07, 2007 5:28 PM To: [email protected] Subject: Re: Cursor sharing ? ** seperate question: since you are answering.. I just imported all the diary fields (long) into another diary field (log) if I just delete the old diary, and rename the new db name to the old one.. Will this work.. I cannot remember if all workflow is tied to the Fieldid or fieldname. thanks. On 6/7/07, Axton <[EMAIL PROTECTED]> wrote: ** I've implemented this using the cursor_sharing parameter (SIMILAR). Similar is recommended over force if you search the KB, although the articles are against really old versions. It makes a huge difference in Oracle in relation to (1) hard parses and (2) shared pool size. This does two things on the Oracle side, reduces cpu overhead, reduces memory requirements. It would really be better if Remedy were altered to use bind variables natively, but this will never happen. Axton Grams On 6/7/07, patrick zandi <[EMAIL PROTECTED] > wrote: ** Alternatively, you may set the parameter "cursor_sharing" to "force". <https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/ini tParameters?event=findParameter&target=ARS10.adm&type=oracle_database&in itParamName=cursor_sharing&newParamValue=FORCE&backURL=/em/console/datab ase/instance/hdm%3Ftype%3Doracle_database%26task_id%3D2489%26target%3DAR S10.adm%26event%3DfindingDetailsReload%26findingID%3D11&messageText=ADDM %20recommends%20modifying%20parameter%20cursor_sharing%20from%20EXACT%20 to%20FORCE.&messageType=info> Action Investigate application logic for possible use of bind variables instead of literals. Rationale At least 12 SQL statements with PLAN_HASH_VALUE 1942213815 were found to be using literals. An example is SQL statement with SQL_ID "dybpwnnkz45af" . SQL Text SELECT C536871112 FROM T262 WHERE C1 = 'WP0011693' <https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sql Detail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=dybpwnn kz45af&planHashValue=1942213815&refreshChoice=HIST_CUST&pageNum=1> SQL ID dybpwnnkz45af <https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sql Detail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=dybpwnn kz45af&planHashValue=1942213815&refreshChoice=HIST_CUST&pageNum=1> Rationale At least 12 SQL statements with PLAN_HASH_VALUE 1942213815 were found to be using literals. An example is SQL statement with SQL_ID "4s8y4x7jf2mbg" . SQL Text SELECT C536871112 FROM T262 WHERE C1 = 'WP0010719' <https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sql Detail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=4s8y4x7 jf2mbg&planHashValue=1942213815&refreshChoice=HIST_CUST&pageNum=1> SQL ID 4s8y4x7jf2mbg <https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sql Detail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=4s8y4x7 jf2mbg&planHashValue=1942213815&refreshChoice=HIST_CUST&pageNum=1> Rationale At least 12 SQL statements with PLAN_HASH_VALUE 4064886972 were found to be using literals. An example is SQL statement with SQL_ID "4vv1kb5twgab0" . SQL Text SELECT C536871111 FROM T197 WHERE C1 = 'TT010174' <https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sql Detail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=4vv1kb5 twgab0&planHashValue=4064886972&refreshChoice=HIST_CUST&pageNum=1> SQL ID 4vv1kb5twgab0 <https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sql Detail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=4vv1kb5 twgab0&planHashValue=4064886972&refreshChoice=HIST_CUST&pageNum=1> Rationale At least 12 SQL statements with PLAN_HASH_VALUE 4064886972 were found to be using literals. An example is SQL statement with SQL_ID "bwvq3h65kwaj3" . =========================================== Has anyone Implimented this.. ??? and or has Remedy Recommended this ? Cursor_sharing :? -- Patrick Zandi -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
