What views or other objects are required to use Session Browser?
You just need SELECT privileges on the data dictionary views that it uses. It also depends on what you want to get in the Session Browser. If any privileges are missing, Toad will let the user know and build a script to grant the missing privileges.
Here is a list of packages and views that the Session Browser uses:
Packages:
DBMS_MONITOR
Views:
V$SESSION
V$PROCESS
V$SESS_IO
V$SESSION_WAIT
V$SESSION_EVENT
V$SESSTAT
V$STATNAME
V$OPEN_CURSOR
V$PX_SESSION
V$PARAMETER
V$SQL
V$SQL_PLAN
V$LOCK
V$SESSION_LONGOPS
V$TRANSACTION
V$ROLLNAME
V$SQLTEXT_WITH_NEWLINES
DBA_ROLLBACK_SEGS
DBA_OBJECTS
DBA_ENABLED_TRACES
V$EVENTMETRIC
V$EVENT_NAME
V$SESSION_EVENT
V$SESSION_CONNECT_INFO
© ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center