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

Thread: SQL Text

  1. #1
    Join Date
    Jun 2001
    Posts
    2

    Exclamation

    As a DBA, how do you know or where to get , what are all the binding variables used by an Oracle user in his SQL statement?

  2. #2
    Join Date
    Jul 2000
    Posts
    521
    Do you mean actual variables or values used in executing the SQL statement that has bind variable in it ?
    svk

  3. #3
    Join Date
    Jun 2001
    Posts
    2
    I mean values of the bind varaiables.

  4. #4
    Join Date
    Jul 2000
    Posts
    521
    Try using LogMiner.
    svk

  5. #5
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    you can use sql_trace to establish this.

    execute the following command before your user execute the statements

    alter session set events = '10046 trace name context forever, level 4'

    this generates lot's of info in the trace file.
    You can find the values of the bind variables in the trace file.

    Or you can do it using svrmgr

    SVRMGR>oradebug setospid

    SVRMGR>oradebug event 10046 trace name context forever, level 4

    I found this info in "Oracle8i & UNIX performance tuning" from Alomari


    Hope this helps
    Gert

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