Hi Guys,
Versions: Oracle Database 19c; SQLcl 22.4
Edition: Enterprise Edition
Distribution: Linux
When you activate autotrace on SQLcl (set autotrace on), you receive the following message when the user does not have the right privileges and you want the statistics.
The statistic feature requires that the user is granted select on v_$sesstat, v_$statname and v_$session.
I think the good views are v_$sesstat, v_$statname and v_$mystat.
Is there an error on the message or there is a good explanation?