System information

12
 Using STM
Communication
SQL Queries over IP
Oracle:
Versions/Models
10G, 11G
Requires Agent?
No
Requires a Proxy
Agent?
Yes – via STM Server
Prerequisites
Requires ID with Table name Permissions
V$SGASTAT select
v$version select
v$statname select
v$sesstat select
v$session select
v$sysstat select
dba_rollback_segs select
dba_indexes select
dba_tables select
dba_segments select
sys.dba_extents select
sys.dba_data_files select
sys.dba_tablespaces select
sys.dba_free_space select
V$OSSTAT select
V$SYSMETRIC_HISTORY select
Credentials
Account and password stored in STM database and
configuration files on proxy agent using custom
encryption
Read/Write Actions
Read Only
Ports Used
Depends on Oracle configuration
Communication
SQL Queries over IP