3 Replies Latest reply: Mar 14, 2014 7:04 AM by BluShadow RSS

    Execution plan issue

    petez

      Hi Guys,

       

      I have problem with one query, database is 11.1.0.7.0.

       

      Query is executed in package procedure as dynamic SQL.

       

      When I run this query from package but with RULE hint - it is ok.

      I see in SQL monitor:

      buffer gets: 10390

      i/o count: 166 IO

      Database time: 1s

       

      When I run this query from package but without RULE hint - it is NOT ok.

      buffer gets:529K

      i/o count: no value

      Database time: executing...

       

      When I run this query ( as static SQL without RULE ) from sqlplus it is ok.

       

      I checked all tables used and all have stats.

       

      What to check,

       

      thanks