1 Reply Latest reply on Feb 18, 2016 10:19 AM by thatJeffSmith-Oracle

    how to grant privileges and use explain plan

    S123db

      Hi

       

      I am working on  SQL developer and installed oracle Xpress also. So I want to use explain plan to know stats.

      But it says


      Unable to gather statistics please unsure user has correct access.

      The statistic feature requires that the user is granted select on v_$sesstat, v_$statname and v_$session.


      SQL> connect hr/password

      Connected.

      SQL> @$ORACLE_HOME/rdbms/admin/utlxplan.sql

      SP2-0310: unable to open file "$ORACLE_HOME/rdbms/admin/utlxplan.sql"

      SQL>

       

      what I have to do to get prvileges and to  use explain plan

       

      Regards

      M123