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/initParameters?event=findParameter&target=ARS10.adm&type=oracle_database&initParamName=cursor_sharing&newParamValue=FORCE&backURL=/em/console/database/instance/hdm%3Ftype%3Doracle_database%26task_id%3D2489%26target%3DARS10.adm%26event%3DfindingDetailsReload%26findingID%3D11&messageText=ADDM%20recommends%20modifying%20parameter%20cursor_sharing%20from%20EXACT%20to%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/sqlDetail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=dybpwnnkz45af&planHashValue=1942213815&refreshChoice=HIST_CUST&pageNum=1> SQL ID dybpwnnkz45af<https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sqlDetail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=dybpwnnkz45af&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/sqlDetail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=4s8y4x7jf2mbg&planHashValue=1942213815&refreshChoice=HIST_CUST&pageNum=1> SQL ID 4s8y4x7jf2mbg<https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sqlDetail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=4s8y4x7jf2mbg&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/sqlDetail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=4vv1kb5twgab0&planHashValue=4064886972&refreshChoice=HIST_CUST&pageNum=1> SQL ID 4vv1kb5twgab0<https://remdev2.testbed.rl.af.mil:1159/em/console/database/instance/sqlDetail?event=doLoad&target=ARS10.adm&type=oracle_database&sql_id=4vv1kb5twgab0&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 __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
