homme.io

Clean.Precise.Quick.

If autotrace not working

set autotrace on;

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.

 

solution is: connect as sysdba and

grant SELECT_CATALOG_ROLE to scott
grant SELECT ANY DICTIONARY to scott