In the Toad for Oracle Help, with the SGA Trace/ Optimization feature, it states the following regarding permission to use the SGA Trace.
Database | Monitor | SGA Trace
The following public synonyms must be present.
v$sqlarea
v$sqltext_with_newlines
You must also have:
access to the V$ Oracle Dictionary views
What does access to the V$ Oracle Dictionary views include? Does it mean they need access to all user, all, and DBA objects views?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center