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

Thread: Tracing in 10g for query with bind variables

Threaded View

  1. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Quote Originally Posted by ggnanaraj
    Thanks for the information provided.

    Can we do the tracing without declaring the bind variables in the query? I know this sounds absurd! Still wanted to double check!!

    TIA.
    No You cannot do the tracing without declaring the bind variables because for tracing the query execution you need to execute the query for which a value needs to binded to the query

    if you are interested in the plan then you can use dbms_xplan
    Last edited by hrishy; 02-27-2008 at 07:30 AM.

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