Search Results for "sysstat"

...It will ask for few permission: grant select on gv_$active_session_history to $USER_NAME; grant select on gv_$SQL to $USER_NAME; grant select on gv_$SQL_MONITOR to $USER_NAME; grant select on gv_$SQLSTATS to $USER_NAME; grant select on v_$database to $USER_NAME; grant select on gv_$instance to $USER_NAME; grant select on gv_$statname to $USER_NAME; grant select on gv_$sysstat to $USER_NAME; grant select on gv_$osstat to $USER_NAME; grant select on gv_$dlm_misc to $USER_NAME; grant create session to $USER_NAME; OraGlance is free software , use it as you like.

you need permission to dictionary views. GV$SYSMETRIC GV$SESSION GV$INSTANCE GV$OSSTAT GV$SGA GV$SYSTEM_EVENT GV$SYSSTAT GV$DIAG_INFO GV$PGASTAT GV$PROCESS GV$SESSION_WAIT_CLASS GV$SESSTAT GV$RECOVERY_PROGRESS V$ACTIVE_SERVICES V$SESSION V$PARAMETER V$ASM_DISKGROUP V$RECOVERY_FILE_DEST V$SQL_PLAN_STATISTICS_ALL V$SQL V$SQL_BIND_CAPTURE DBA_INDEXES DBA_CLU_COLUMNS DBA_IND_COLUMNS

The sysstat utilities are a collection of performance monitoring tools for Linux. These include sar, sadf, mpstat, iostat, nfsiostat-sysstat, cifsiostat, pidstat and sa tools.

Command line tool that creates charts from SysStat output and presents them through HTML pages. It is also capable to display charts from several machines at a single site.