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 > __20060125_______________________This posting was submitted with HTML in > it___ __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"
