DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: CURSOR_SHARING = exact VS CURSOR_SHARING = EXACT

  1. #1
    Join Date
    Jan 2013
    Posts
    1

    CURSOR_SHARING = exact VS CURSOR_SHARING = EXACT

    CURSOR_SHARING = exact VS CURSOR_SHARING = EXACT
    We are running Oracle 10.2.0.4 with the compatible parameter of 9.2.0.5. My question is fairly simple - does Oracle require parameters to be in uppercase or can they be in lowercase?

    Most of our business users are reporting slow response time. Among other observations which are being investigated, it appears that users are often in a wait state for a specified cursor which seems to indicate that cursors are being shared. The application, as it comes from the vendor - all of the cursors are defined as CURSOR_SHARING = SIMILAR. In the ora.init CURSOR_SHARING is set to exact and DEFAULT indicates NO. Does it matter that exact is in lowercase?

    Any insight would be much appreciated

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    Quote Originally Posted by mzehow01 View Post
    CURSOR_SHARING = exact VS CURSOR_SHARING = EXACT
    We are running Oracle 10.2.0.4 with the compatible parameter of 9.2.0.5. My question is fairly simple - does Oracle require parameters to be in uppercase or can they be in lowercase?
    . . . Etc . . .
    Does it matter that exact is in lowercase?
    NO, but your issue may be this: "We are running Oracle 10.2.0.4 with the compatible parameter of 9.2.0.5"
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width