can I use that on 7.X -- where do I get it.. == Or should I do this at the DB level
On 6/7/07, Grooms, Frederick W <[EMAIL PROTECTED]> wrote:
** 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/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 > > > -- Patrick Zandi __20060125_______________________This posting was submitted with HTML in it___
-- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
