Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Post Unanswered: Recursive queries

    Hi ,
    I am using Microsoft ODBC driver to connect to an Oracle database...
    My application issues some queries to db.
    For the queries issued from the application, some other queries are getting executed behind the screen querying oracle data dictionary.
    This is the query that is executed internally:
    ************************************************** *
    SELECT TO_CHAR(NULL), ac."OWNER", ac.table_name, acc.column_name,
    acc.position,
    ac.constraint_name
    FROM all_constraints ac, all_cons_columns acc
    WHERE ac."OWNER" = acc."OWNER"
    AND ac.constraint_type = :sys_b_0
    AND ac.constraint_name = acc.constraint_name
    AND ac."OWNER" LIKE :sys_b_1 ESCAPE :sys_b_2
    AND ac.table_name LIKE :sys_b_3 ESCAPE :sys_b_4
    ************************************************** *

    And this is getting executed all the times we query the db(around 20000 times a day!!!)..I dont know how to stop these queries from getting executed..Can some one help me out in this

    Thanks in Advance,

    Rajesh

  2. #2
    Join Date
    Mar 2004
    Location
    Colorado
    Posts
    49
    If you are not submitting this SQL then it must be the ODBC driver. It does not look like normal Oracle recursive SQL. Have you tried a different driver to see if they behave better. (The Oracle driver comes to mind.)

  3. #3
    Join Date
    Apr 2004
    Posts
    2

    Oracle ODBC

    Hi Borzoi,
    Our application is fully dependent on the COM+ transactions and for which the best one i have heard is Microsoft ODBC..SO we are using that..
    Will Oracle ODBC support all the functionalities like Microsoft ODBC

    Thanks in Advance,
    Rajesh

  4. #4
    Join Date
    Mar 2004
    Location
    Colorado
    Posts
    49
    From what I remember the Oracle ODBC drive had a better SQL compatibilty rating then the microsoft but a lot depends on your application we have had times we had to use one version of the Oracle client and only that version. Versions before and after would not work correctly.

  5. #5
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas, USA
    Posts
    68
    This is just a wild guess, but I'd suggest looking into connection pooling. If there are about 20000 sessions being established everyday, I'd be confident that's the problem.

Posting Permissions

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