-- execute from SYS (not SYSTEM)
grant select on v_$thread to SCOTT;

--Optimization & Session Info screens
grant select on v_$rowcache to SCOTT;
grant select on v_$sysstat to SCOTT;
grant select on v_$system_event to SCOTT;
grant select on v_$librarycache to SCOTT;
grant select on v_$STATNAME to SCOTT;
grant select on v_$SESSTAT to SCOTT;
grant select on v_$sess_io to SCOTT;
grant select on v_$session to SCOTT;
grant select on v_$process to SCOTT;
grant select on v_$latch to SCOTT;

--DBA > Database Monitor
grant select on v_$sysstat to SCOTT; 
grant select on v_$system_event to SCOTT;
grant select on v_$session to SCOTT;
grant select on v_$librarycache to SCOTT;
grant select on sys.x_$ksllt to SCOTT;
grant select on v_$sgastat to SCOTT;

--DBA > Database Health Check

grant select on v_$version to SCOTT;
grant select on v_$instance to SCOTT;
grant select on v_$sysstat to SCOTT;
grant select on v_$librarycache to SCOTT;
grant select on v_$rowcache to SCOTT;
grant select on v_$sgastat to SCOTT;
grant select on v_$parameter to SCOTT;
grant select on v_$database to SCOTT;
grant select on v_$log_history to SCOTT;
grant select on v_$filestat to SCOTT;
grant select on v_$datafile to SCOTT;
grant select on v_$tablespace to SCOTT;

--DBA > Oracle Parameters
grant select on v_$parameter to SCOTT;

--DBA > Kill/Trace
grant select on v_$lock to SCOTT;
grant select on v_$locked_object to SCOTT;
grant select on v_$open_cursor to SCOTT;

--DBA > Log Miner
grant select on v_$logmnr_contents to SCOTT;
grant select on v_$logmnr_logs to SCOTT;

--Tools > SGA Trace 
grant select on v_$sqlarea to SCOTT;
grant select on v_$sqltext_with_newlines to SCOTT;
--access to the v_$ Oracle Dictionary views 

--Instance Manager > Shutdown
grant select on v_$parameter to SCOTT;

--TOAD Server Statistics > Analysis
grant select on SYS.V_$SESS_IO to SCOTT;
grant select on SYS.V_$SESSION to SCOTT;
grant select on SYS.V_$PROCESS to SCOTT;
grant select on SYS.V_$STATNAME to SCOTT;
grant select on SYS.V_$ROWCACHE to SCOTT;
grant select on SYS.V_$SYSSTAT to SCOTT;
grant select on SYS.V_$SYSTEM_EVENT to SCOTT;
grant select on SYS.V_$LIBRARYCACHE to SCOTT;
grant select on SYS.SESSION_PRIVS to SCOTT;

--TOAD Server Statistics > Waits
grant select on SYS.V_$SYSTEM_EVENT to SCOTT;

--TOAD Server Statistics > Latches
grant select on SYS.V_$LATCH to SCOTT;

--TOAD Server Statistics > Sessions
grant select on SYS.V_$SESS_IO to SCOTT;
grant select on SYS.V_$SESSION to SCOTT;
grant select on SYS.V_$PROCESS to SCOTT;
grant select on SYS.V_$STATNAME to SCOTT;

--TOAD Server Statistics > Instance Summary
grant select on SYS.V_$SYSSTAT to SCOTT;

--Space Manager Setup
grant select on SYS.V_$SYSSTAT to SCOTT;
grant select on V_$FILESTAT to SCOTT;

-- another useful one...
grant select on v_$mystat to SCOTT;