2 Replies Latest reply: Apr 27, 2012 1:51 PM by _Joao_ RSS

    Possible bug on compare Autotrace results panel

    _Joao_
      I think there is a bug on compare Autotrace statistics results panel.
      Apparently the comparison is executed just line by line instead of consider statistics names.
      Some times when there are different statistics between executions, the results are
      showed in red because the values are of a different statistic.

      Some results for first execution:
      parse count (total) 5
      recursive calls 22
      session cursor cache count 2
      session cursor cache hits 3
      session logical reads 4999

      Second execution:
      parse count (total) 5
      recursive calls 22
      session cursor cache hits 4
      session logical reads 4999
      session pga memory -131072


      Compare panel:
      parse count (total) 5 5
      recursive calls 22 22
      session cursor cache hits 4 2 <<=====
      session logical reads 4999 3 <<=====
      session pga memory -131072 4999 <<=====


      My environment:
      SQLDeveloper 3.1.07.42 (Windows XP SP3)
      Oracle 11.2.0.1.0

      Thanks