This discussion is archived
5 Replies Latest reply: Jan 28, 2013 10:52 AM by kiranss RSS

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

kiranss Newbie
Currently Being Moderated
Database was recently upgraded from 10.2.0.4 to 11.2.0.3 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)

Legend

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