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
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
