1 Reply Latest reply on Feb 7, 2013 9:20 PM by Srini Chavali-Oracle

    Database migrated from Oracle 10g to 11g Discoverer report performance issu

      Hi All,

      We are now getting issue in Discoverer Report performance as the report is keep on running when database got upgrade from 10g to 11g.
      In database 10g the report is working fine but the same report is not working fine in 11g.
      The query i have changed as I have passed the date format TO_CHAR("DD-MON-YYYY" and removed the NVL & TRUNC function from the existing query.
      The report is now working fine in Database 11g backhand but when I am using the same query in Discoverer it is not working and report is keep on running.

      Please advise.