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

Thread: Oracle/ColdFusion/bind variables

  1. #1
    Join Date
    Sep 2002
    Posts
    3
    Folks,

    I’m trying to resolve the performance issue related to ColdFusion and dynamic list of variables in IN-list clause for various SQL statements. ColdFusion is not very good with bind variables and after several attempts developers made a decision not to use them. As a result, database is flooded with a bunch of similar SQL statements with the only difference in IN clause. The result – high latch waits/contention and poor overall performance. The solution – get back to bind variables. Do you know what be the best approach to it? Unfortunately, I don’t have a lot of experience in this area.

    Your help will be greatly appreciated.

    Thanks a lot.

    Mike Darevsky

  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    maybe this can help you


    CURSOR_SHARING
    Parameter type String

    Syntax CURSOR_SHARING = {SIMILAR | EXACT | FORCE}

    Default value EXACT

    Parameter class Dynamic: ALTER SESSION, ALTER SYSTEM




    CURSOR_SHARING determines what kind of SQL statements can share the same cursors.

    Values:

    FORCE

    Forces statements that may differ in some literals, but are otherwise identical, to share a cursor, unless the literals affect the meaning of the statement.

    SIMILAR

    Causes statements that may differ in some literals, but are otherwise identical, to share a cursor, unless the literals affect either the meaning of the statement or the degree to which the plan is optimized.

    EXACT

    Only allows statements with identical text to share the same cursor.


    --------------------------------------------------------------------------------
    Note:
    Forcing cursor sharing among similar (but not identical) statements can have unexpected results in some DSS applications, or applications that use stored outlines.

    --------------------------------------------------------------------------------




    See Also:
    Oracle9i Database Performance Guide and Reference for information on setting this parameter in these and other environments




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