Oracle-Cursor-Sharing for CMDB 7.6 and SLM 7.6

I'm wondering if anyone has experienced this same Oracle issue...   I've installed CMDB 7.6.  The documentation states Oracle-Cursor-Sharing needst to be set as SIMILAR for installation.    SLM 7.6 installation states Oracle-Cursor-Shareing needs to be set to FORCE.   Which setting should

Re: Oracle-Cursor-Sharing for CMDB 7.6 and SLM 7.6

It is force. Not similar it was a documentation error Sent from my iPhone On Mar 20, 2013, at 16:17, Oscar Herrera oherrera...@yahoo.com wrote: ** I'm wondering if anyone has experienced this same Oracle issue... I've installed CMDB 7.6. The documentation states Oracle-Cursor-Sharing

Re: Oracle-Cursor-Sharing for CMDB 7.6 and SLM 7.6

Oscar, The best setting for Oracle-Cursor-Sharing is FORCE. This is true for ANY AR System installation. Now, there is one exception to this. If you want to run Oracle in case-INsensitive mode - which is fully supported from the 8.1 and forward versions - you must set Oracle-Cursor-Sharing

Cursor Sharing

Hi Dave, Thanks for response. My current application is in performance dip, Can any shed some light on cursor sharing? Is this really improves performance? Thanks Regards Arshad Mahammad Shellman

Re: Cursor Sharing

There was a great exchange started by Frank Caruso on Monday of this week. I think it sums up everything about the subject. Look for the thread with ORACLE Cursor Sharing as the subject. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl

Re: Cursor Sharing

on cursor sharing? Is this really improves performance? Thanks Regards Arshad Mahammad Shellman, David dave.shell...@ty COELECTRONICS.COM To arslist@ARSLIST.ORG Sent by: Action cc Request System discussion list Subject (ARSList) Re: test mail arsl...@arslist. ORG 3

Re: Cursor Sharing

.2FBind_Variables Axton On Fri, Dec 3, 2010 at 10:05 AM, Arshad M arsha...@steria.co.in wrote: Hi Dave, Thanks for response. My current application is in performance dip, Can any shed some light on cursor sharing? Is this really improves performance? Thanks Regards Arshad Mahammad

Re: Cursor Sharing

Arshad, you can find a white paper on Oracle Cursor Sharing for BMC Remedy Products ' in http://www.bmc.com/supportu/documents/78/31/67831/67831.pdf. You will need access to BMC Customer support site Satya On Fri, Dec 3, 2010 at 5:01 PM, Axton axton.gr...@gmail.com wrote: ** http

Re: Cursor Sharing

Axton, When we set up our 7.1 servers a couple years ago, I set our cursor sharing to similar based on the BMC white paper: Best practices mandate specifically that, with 6.0.1, users should use force, and *with 6.3 or 7.0, users should use similar*, but the difference between the two

Re: Cursor Sharing

7.1 servers a couple years ago, I set our cursor sharing to similar based on the BMC white paper: Best practices mandate specifically that, with 6.0.1, users should use force, and *with 6.3 or 7.0, users should use similar*, but the difference between the two settings is small

Re: Cursor Sharing

. This is just based on my understanding of what that parameter does. On Fri, Dec 3, 2010 at 12:35 PM, Thad Esser thad.es...@gmail.com wrote: ** Axton, When we set up our 7.1 servers a couple years ago, I set our cursor sharing to similar based on the BMC white paper: Best practices mandate

AW: ORACLE Cursor Sharing

) [mailto:arsl...@arslist.org] Im Auftrag von Frank Caruso Gesendet: Montag, 22. November 2010 19:46 An: arslist@ARSLIST.ORG Betreff: ORACLE Cursor Sharing ** Does anyone know what effect setting the Oracle Cursor Sharing parameter in the ar.cfg has on performance? I understand what cursor sharing

Re: ORACLE Cursor Sharing

Subject: AW: ORACLE Cursor Sharing ** Frank, IMHO this parameter does not have an effect on performance. Somtimes arserverd issues an alter session set cursor_sharing = exact for some reason. To reset it back to it's desired value you have to specify it in ar.cfg SQL TID: 1081108800 RPC ID

Re: ORACLE Cursor Sharing

Folks, Just to be clear and to not send folks down an incorrect path. Setting the cursor sharing option for Oracle has a SIGNIFICANT impact on performance. Setting at the Oracle level and then telling the AR System through the ar.conf setting is important. (you may be able to just set

ORACLE Cursor Sharing

Does anyone know what effect setting the Oracle Cursor Sharing parameter in the ar.cfg has on performance? I understand what cursor sharing is and have it set at the Oracle (database) level but want to know why it needs to be set in the ARS server config file. Thank you

Re: Oracle Cursor Sharing in ARS7.1

] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Thursday, November 20, 2008 3:15 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle Cursor Sharing in ARS7.1 ** You have to do it on the database server as well

Oracle Cursor Sharing in ARS7.1

All, I am running a server group with 2 AR Servers. I have noticed that saving changes or new objects within the Admin tool takes a long time... 5-7 minutes in some instances. I've seen the article regarding entering the string into the config file: Oracle-Cursor-Sharing: FORCE Are there any

Re: Oracle Cursor Sharing in ARS7.1

discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chowdhury, Tauf Sent: Thursday, November 20, 2008 1:36 PM To: arslist@ARSLIST.ORG Subject: Oracle Cursor Sharing in ARS7.1 ** All, I am running a server group with 2 AR Servers. I have noticed that saving changes or new objects

Re: Oracle Cursor Sharing in ARS7.1

, November 20, 2008 1:36 PM To: arslist@ARSLIST.ORG Subject: Oracle Cursor Sharing in ARS7.1 All, I am running a server group with 2 AR Servers. I have noticed that saving changes or new objects within the Admin tool takes a long time... 5-7 minutes in some instances. I've seen the article regarding

Re: Database cursor sharing

Worthington Sent: Wed 4/9/2008 2:09 PM To: arslist@ARSLIST.ORG Subject: Re: Database cursor sharing ** Sorry -- I usually reference my source. :-) Guess I wasn't thinking rtfm... lol White Paper Oracle's Cursor Sharing for BMC® Remedy® Products January 2007 *67831* -- Tony Worthington Sr

Database cursor sharing

This is NOT happening on the QA server. Both servers have the Oracle-Cursor-Sharing: FORCE parameter set in the ar.conf file and the corresponding appropriate setting is established in Oracle (and we've checked these like 9000 times). Anyone know what setting/config would make Remedy do this to Oracle? William

Re: Database cursor sharing

reports are reporting the same values in the init.ora section? I know you mention you've checked a gazillion times ... but it might be in the spfile and not be recognized by the db. We've also had cursor sharing changes not stick over db restarts. init.ora Parameters Parameter Name

Re: Database cursor sharing

: Database cursor sharing ** Strange that it would alter to both exact and force when having the system set to force in one operation. Are you seeing the alter sessions right next to each other or are there various inserts in between? Exact is used when inserting into long raw. Have you verified

Re: Database cursor sharing

Sorry -- I usually reference my source. :-) Guess I wasn't thinking rtfm... lol White Paper Oracle's Cursor Sharing for BMC® Remedy® Products January 2007 *67831* -- Tony Worthington Sr. Technical Analyst Kohl's Department Stores [EMAIL PROTECTED] 262-703-5911 William Rentfrow [EMAIL

Cursor sharing ?

Alternatively, you may set the parameter cursor_sharing to force.

Re: Cursor sharing ?

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

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

Re: Cursor sharing ?

All workflow is bound to the fieldid. If you drop and recreate a field, with the same id, it will be bound to all the same workflow (given that you don't open the workflow, acknowledge the error you get about missing fields, and save it). Renaming a field (to match the name of a recently delete

Re: Cursor sharing ?

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

Re: Cursor sharing ?

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

Re: Cursor sharing ?: solved

Thanks .. all done.. and working.. On 6/7/07, patrick zandi [EMAIL PROTECTED] wrote: Alternatively, you may set the parameter cursor_sharing to force.

Re: Cursor sharing ?

Not sure if you seen this document: http://www.bmc.com/supportu/documents/78/31/67831/67831.pdf -- Jarl On 6/8/07, patrick zandi [EMAIL PROTECTED] wrote: ** Alternatively, you may set the parameter cursor_sharing to force.

Oracle Cursor Sharing

parses. This whitepaper covers some of the details: http://documents.bmc.com/supportu/documents/78/31/67831/67831.pdf My favorite quote from this doc: Any application that uses all literals without cursor sharing enabled is not a very scalable application. Axton Grams

Re: Oracle Cursor Sharing

favorite quote from this doc: Any application that uses all literals without cursor sharing enabled is not a very scalable application. Axton Grams __20060125___This posting was submitted with HTML in it___