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
sdmrnv, 2019-07-04 [0.425ms, s]