Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2010
    Posts
    27

    Unanswered: Set cursor_sharing=FORCE

    I am working on Oracle 10.2.0.4(RAC). I am trying to set Cursor_sharing=Force
    SQL>alter system set cursor_sharing='FORCE' scope=both;

    Do I need to shutdown and startup the database. Is it required or not and if required how I need to do as per RAC.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    alter system set cursor_sharing='FORCE' scope=both sid=*;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2010
    Posts
    27

    Set cursor_sharing=FORCE

    I am working on Oracle 10.2.0.4(RAC). I am trying to set Cursor_sharing=Force
    SQL>alter system set cursor_sharing='FORCE' scope=both sid=dbtst;

    Do I need to shutdown and startup the database. Is it required or not and if required how I need to shutdown and startup as per RAC

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    what does SCOPE=BOTH accomplish?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    what does SCOPE=BOTH accomplish?
    The change is done in memory & spfile

    sid=* (default) means all instances of a RAC
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

Posting Permissions

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