5 Replies Latest reply: Sep 10, 2013 2:42 AM by bas_ua RSS

    Find bind variables from AWR

    bas_ua

      Hi, guys!

       

      I'm trying to find bind values for specific sql with dbms_xplan.display_awr

       

      I run somthing like this:

      select * from table(dbms_xplan.display_awr('2199vz897asdw',null,null,'ADVANCED'));

       

      and got (among others) bind section:

       

      Peeked Binds (identified by position):

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

       

         1 - :B7 (NUMBER): 62500

         2 - :B6 (NUMBER): 261161

         3 - :B5 (NUMBER): 3

         4 - :B4 (NUMBER): 0

         6 - :B2 (NUMBER): 0

         7 - :B1 (NUMBER): 0

         8 - :B7 (NUMBER, Primary=1)

         9 - :B5 (NUMBER, Primary=3)

        10 - :B6 (NUMBER, Primary=2)

        11 - :B4 (NUMBER, Primary=4)

        13 - :B2 (NUMBER, Primary=6)

        14 - :B1 (NUMBER, Primary=7)

        15 - :B7 (NUMBER, Primary=1)

        16 - :B6 (NUMBER, Primary=2)

        20 - :B2 (NUMBER, Primary=6)

        22 - :B7 (NUMBER, Primary=1)

        23 - :B5 (NUMBER, Primary=3)

        24 - :B6 (NUMBER, Primary=2)

        25 - :B4 (NUMBER, Primary=4)

        27 - :B2 (NUMBER, Primary=6)

        28 - :B1 (NUMBER, Primary=7)

        29 - :B7 (NUMBER, Primary=1)

        30 - :B5 (NUMBER, Primary=3)

        31 - :B6 (NUMBER, Primary=2)

        32 - :B4 (NUMBER, Primary=4)

        34 - :B2 (NUMBER, Primary=6)

        35 - :B1 (NUMBER, Primary=7)

       

      The query has exactly 35 bind variables.

      And we can see 35 bind position in this report. But indeed there're absent positions... like position 5, 12, 17,18, 19 etc...

      Where they are?

       

      Thanks!