This discussion is archived
5 Replies Latest reply: Sep 10, 2013 12:42 AM by bas_ua RSS

Find bind variables from AWR

bas_ua Newbie
Currently Being Moderated

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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points