1 2 3 Previous Next 31 Replies Latest reply: Apr 2, 2014 1:59 AM by 846411 Go to original post RSS
      • 30. Re: no rows selected
        Hemant K Chitale

        Remember :  A join between v$esssion and v$sql%  views will return rows only *IF*  the toad session is *CURRENTLY* running a query ; not if it has already run a query even a second ago.

        If you want all the queries run by a toad session, you need to enable sql tracing of the session so that the queries are captured to a trace file.

         

         

        Hemant K Chitale


        • 31. Re: no rows selected
          846411

          Hi,

           

          Do you want to track all the sql queries for sessions logged in using toad ?

           

          In that case you will have to check go for SQL tracing. Please use this with caution on Production database. Please refer below document for the same.

           

          Using SQL Trace and TKPROF

           

          Regards,

          Atif Iqbal

          1 2 3 Previous Next