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?
Some data dictionary views start with the characters V$. Quest Software calls them the V$ dictionary views.
For the SGA Trace, one needs select privileges on
v$sqlarea, v$sqltext_with_newlines, v$sql_plan, v$session, v$open_cursor, and v$sql_bind_capture.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center