oh, wait it is suppose to come with the system somewhere right ?
On 6/7/07, patrick zandi <[EMAIL PROTECTED]> wrote:
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
-- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
