5 Replies Latest reply: Jan 28, 2013 12:52 PM by kiranss RSS

    SQL Tuning Task fails with ORA-01727: numeric precision specifier is out of

      Database was recently upgraded from to and the EM dbcontol repository was recreated.

      If I schedule a sql tuning advisor task for any sql query, i get this error. I have also tried to drop sysman user and recreate it, but no luck.

      Type     Findings     Recommendations     Rationale     Benefit (%)     Other Statistics     New Explain Plan     Compare Explain Plans
      Error     ORA-01727: numeric precision specifier is out of range (1 to 38)