8 Replies Latest reply on Jul 26, 2013 7:58 AM by Trotty

    4.0 EA1 - New Explain Plan Functionality


      Hi i was just trying the new Explain Plan functionality(which i like the look of) mentioned by Jeff Smith on his blog but if it i get a "ORA-00942: table or view does not exist"

      I get this doing the explain plan drop down, selecting from V$SQL_PLAN (Synonym) and from the base underlying table V_$SQL_PLAN. I'm logged in as APPS but that user doesn't have select privileges on those sys objects for me. Not sure how you've/he has got it to work(logged in as sys?) or if i have grants missing?