Oracle Prerequisites

Before attempting to monitor your Oracle database with SelectStar, ensure you are running Oracle 11.2 or greater.

Connection Information

The following information is required by SelectStar in order to monitor to your Oracle database:

HostHostname or IP address of the system on which your database is running
PortPort on which your database is listening [default: 1521]
SIDOracle System Identifier of your database instance
Service NameGlobal database name

Credentials

UsernameOracle database user
RoleUser role. One of:
  • normal
  • SYSDBA
  • SYSOPER
PasswordUser's password

Access Rights

The following list contains the minimum Oracle Database user privileges required for monitoring with SelectStar. Ensure the Oracle Database user has these permissions granted:

  • create session
  • connect
  • select on dba_data_files
  • select on dba_free_space
  • select on dba_outstanding_alerts
  • select on dba_tablespaces
  • select on dba_temp_files
  • select on dba_temp_free_space
  • select on dba_undo_extents
  • select on global_name
  • select on gv_$archive_dest
  • select on gv_$filestat
  • select on gv_$instance
  • select on gv_$parameter
  • select on gv_$resource_limit
  • select on gv_$session
  • select on gv_$sgainfo
  • select on gv_$sql
  • select on gv_$sysmetric
  • select on gv_$system_event
  • select on gv_$system_wait_class
  • select on gv_$tempstat
  • select on v_$archive_dest
  • select on v_$controlfile
  • select on v_$database
  • select on v_$datafile
  • select on v_$filestat
  • select on v_$instance
  • select on v_$log
  • select on v_$logfile
  • select on v_$parameter
  • select on v_$recovery_area_usage
  • select on v_$resource_limit
  • select on v_$rman_backup_job_details
  • select on v_$tempfile
  • select on v_$version

Creating user for RDS

Run the following command for the monitoring user:

CREATE USER SELECTSTAR_USER IDENTIFIED BY yourmonitoringpassword;

GRANT CONNECT TO SELECTSTAR_USER;
GRANT SELECT on gv$instance to SELECTSTAR_USER
GRANT SELECT on dba_data_files TO SELECTSTAR_USER;
GRANT SELECT on dba_free_space TO SELECTSTAR_USER;
GRANT SELECT on dba_tablespaces TO SELECTSTAR_USER;
GRANT SELECT on dba_temp_files TO SELECTSTAR_USER;
GRANT SELECT on global_name TO SELECTSTAR_USER;

CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$ARCHIVE_DEST','SELECTSTAR_USER','SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$FILESTAT', 'SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$INSTANCE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$PARAMETER','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$RESOURCE_LIMIT','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$SESSION','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$SGAINFO','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$SQL','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$SYSMETRIC','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$SYSTEM_EVENT','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$SYSTEM_WAIT_CLASS','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$TEMPSTAT','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$ARCHIVE_DEST','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$CONTROLFILE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$DATABASE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$DATAFILE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$FILESTAT','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$INSTANCE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$LOG','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$LOGFILE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$PARAMETER','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$RECOVERY_AREA_USAGE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$RESOURCE_LIMIT','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$RMAN_BACKUP_JOB_DETAILS','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$TEMPFILE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$VERSION','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('DBA_UNDO_EXTENTS', 'SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('DBA_UNDO_EXTENTS', 'SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('DBA_TEMP_FREE_SPACE', 'SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('DBA_OUTSTANDING_ALERTS', 'SELECTSTAR_USER', 'SELECT');

Metrics

Database

Archive Log Files Count
Integer
Archive Logging Enabled Score
Integer
Archive Log Mode
String
Average Configuration And Health Score
Integer
Average Datafile Read Time (ms)
Integer
Average Datafile Read Time < 1ms Score
Integer
Controlfile Count
Integer
Days Since Last RMAN Backup
Integer
Expired Undo Extents Size (kB)
Integer
Fast Recovery Area Configured
String
Fast Recovery Area Configured Score
Integer
Fast Recovery Area Usage
Integer
Fast Recovery Area Usage Score
Integer
Flashback Enabled
String
Flashback Enabled Score
Integer
Host List
String
Multiplexed Archive Log Files Score
Integer
Multiplexed Controlfile Score
Integer
Multiplexed Online Log Files Score
Integer
OMF Configured
String
OMF Configured Score
Integer
Online Log Files Average Count
Integer
Processes Limit Score
Integer
Processes Usage (%)
Integer
Release Information
String
RMAN Backup In Last 24 Hours Score
Integer
Sessions Limit Score
Integer
Sessions Usage (%)
Integer
SQL Version
String
Undo Tablespace Size (kB)
Integer
Unexpired Undo Extents Size (kB)
Integer

Cache Advice

Buffer Pool Name
String
Estimated Physical Reads
String
Size Factor
Float

Application

Active User Sessions
Integer
Background Types
Integer
Blocked by Unknown User Sessions
Integer
Blocked User Sessions
Integer
Cached User Sessions
Integer
Inactive User Sessions
Integer
Killed User Sessions
Integer
Non-Waiting User Sessions
Integer
O/S Client Users
Integer
O/S Machines
Integer
Sessions Count
Integer
Sniped User Sessions
Integer
Unblocked User Sessions
Integer
Unknown Wait Time User Sessions
Integer
User Types
Integer
Waiting User Sessions
Integer

Data Guard Destination

Destination Name
String
Status
String

Event

Average Time Waited (ms)
Float
Timeouts
Integer
Time Waited (ms)
Integer
Wait Class
String
Waits
Integer

Event Wait Group

Time Waited (ms)
Integer
Waits
Integer

OS User

Active User Sessions
Integer
Applications
Integer
Background Types
Integer
Blocked by Unknown User Sessions
Integer
Blocked User Sessions
Integer
Cached User Sessions
Integer
Inactive User Sessions
Integer
Killed User Sessions
Integer
Non-Waiting User Sessions
Integer
O/S Machines
Integer
Sessions Count
Integer
Sniped User Sessions
Integer
Unblocked User Sessions
Integer
Unknown Wait Time User Sessions
Integer
User Types
Integer
Waiting User Sessions
Integer

Parameter

Parameter Description
String
Parameter has been Modified after Instance Startup
String
Parameter has not been Modified by Configuration File
String
Parameter Value
String
Parameter Value Type
Integer

Query

Application Wait Time (μs)
Integer
Average Time (μs)
Float
Average elapsed time per execution of this query
Buffer Gets
Integer
Number of logical reads, including reads from disk as well as reads from memory. Excellent metric for overall efficiency.
Child Count
Integer
Number of child cursors represented by this query
Concurrency Wait Time (μs)
Integer
CPU Time (μs)
Integer
CPU time used for parsing, executing, and fetching
Direct Writes
Integer
Disk Reads
Integer
Elapsed Time (μs)
Integer
Elapsed time used for parsing, executing, and fetching. In the case of parallel execution, this is the cumulative time for the query coordinator, plus all parallel query slave processes.
Executions
Integer
Number of executions that took place on this object since it was brought into the library cache
I/O Interconnect Data (kB)
Integer
Number of I/O bytes exchanged between Oracle Database and the storage system
Last Active Time
String
Time at which the query plan was last active
Last Load Time
String
Optimized Physical Read Requests
Integer
Number of physical read I/O requests from Database Smart Flash Cache issued by the monitored SQL
Parse Calls
Integer
Physical Read Data (kB)
Integer
Number of bytes read from disks by the monitored SQL
Physical Read Requests
Integer
Number of physical read I/O requests issued by the monitored SQL
Physical Write Data (kB)
Integer
Number of bytes written to disks by the monitored SQL
Physical Write Requests
Integer
Number of physical write I/O requests issued by the monitored SQL
Rank
Integer
Rows Processed
Integer
Total number of rows the parsed SQL statement returns
Runtime Memory Used (kB)
Integer
Fixed amount of memory required during the execution of this query
Sharable Memory (kB)
Integer
Amount of shared memory used by this query
SQL Text
String
Total Locks
Integer
Total number of times the related child cursors have been locked
Total Pins
Integer
Total number of times the related child cursors have been pinned
User I/O Wait Time (μs)
Integer
Users Executing
Integer
Number of users executing the statement

Session

Application
String
Blocking Instance ID
String
Blocking Session ID
String
Blocking Session Status
String
Client Port
String
Final Blocking Instance ID
String
Final Blocking Session ID
String
Final Blocking Session Status
String
Lock Address
String
Oracle User Name
String
O/S Client User Name
String
O/S Machine
String
Schema Name
String
Serial #
Integer
SQL Execution Start Time
String
SQL Text
String
Status
String
Time Since Last Wait (μs)
Integer
Type
String
Wait Event
String
Wait State
String
Wait Time (μs)
Integer
Wait Time Remaining (μs)
Integer

Control File

Control File Size (kB)
Integer

Database File

Autoextensible
String
Average I/O Time (ms)
Integer
Average Read Time (ms)
Integer
Average Write Time (ms)
Integer
Max Read Time (ms)
Integer
Max Size (kB)
Integer
Max Write Time (ms)
Integer
Physical Blocks Read
Integer
Physical Blocks Written
Integer
Physical Reads
Integer
Physical Writes
Integer
Read Time (ms)
Integer
Single Blocks Read
Integer
Size (kB)
Integer
Status
String
Tablespace Name
String
Write Time (ms)
Integer

PGA Advice

Estimated Cache Hit (%)
Integer
Estimated Extra R/W Data (kB)
Integer
Estimated PGA Memory Over-Allocations
Integer
PGA Target Factor
Float

Redo Log File

Member Name
String
Sequence #
Integer
Size (kB)
Integer
Status
String
Status Extended
String
Thread #
Integer

SGA Advice

Estimated Buffer Cache Size (MB)
Integer
Estimated DB_TIME
Integer
Estimated Physical Reads
String
Estimated Shared Pool Size (MB)
Integer
SGA Size Factor
Float

Shared Pool Advice

Estimated Elapsed Parse Time Saved (s)
Integer
Shared Pool Size Factor
Float

Memory Advice

Estimated DB_TIME
Integer
Memory Size Factor
Float

Tablespace

Allocated Size (kB)
Integer
Contents
String
Free Space (kB)
Integer
Status
String

Instance

Active Parallel Sessions
Float
Active Serial Sessions
Float
Active State
String
Active User Sessions
Integer
_advanced_index_compression_options
String
allow_group_access_to_sga
String
Applications
Integer
aq_tm_processes
String
archive_lag_target
String
Archiver
String
asm_power_limit
String
audit_file_dest
String
audit_sys_operations
String
audit_trail
String
Average Active Sessions
Float
Average I/O Time (ms)
Integer
Average Read Time (ms)
Integer
Average Synchronous Single-Block Read Latency (ms)
Float
Average Write Time (ms)
Integer
_awr_mmon_deep_purge_all_expired
String
awr_snapshot_time_offset
String
Background Checkpoints
Float
background_core_dump
String
Background CPU Usage (centisecond)
Float
background_dump_dest
String
Background Time
Float
Background Types
Integer
backup_tape_io_slaves
String
bitmap_merge_area_size
String
blank_trimming
String
Blocked
String
Blocked by Unknown User Sessions
Integer
Blocked User Sessions
Integer
Branch Node Splits
Float
Branch Node Splits Per Txn
Float
_b_tree_bitmap_plans
String
Buffer Cache Hit Ratio (%)
Float
Buffer Cache Size (kB)
Integer
Cached User Sessions
Integer
cell_offload_compaction
String
cell_offload_decryption
String
cell_offload_plan_display
String
cell_offload_processing
String
cell_partition_large_extents
String
Cell Physical I/O Interconnect (kB)
Float
_client_enable_auto_unregister
String
client_result_cache_lag
String
client_result_cache_size
String
clonedb
String
cluster_database
String
cluster_database_instances
String
commit_point_strength
String
common_user_prefix
String
compatible
String
connection_brokers
String
Consistent Read Changes
Float
Consistent Read Changes Per Txn
Float
Consistent Read Gets
Float
Consistent Read Gets Per Txn
Float
control_file_record_keep_time
String
control_files
String
control_management_pack_access
String
core_dump_dest
String
cpu_count
String
CPU Usage (centisecond)
Float
CPU Usage Per Txn (centisecond)
Float
CR Blocks Created
Float
CR Blocks Created Per Txn
Float
create_bitmap_area_size
String
CR Undo Records Applied
Float
CR Undo Records Applied Per Txn
Float
Current Logons Count
Float
Current Open Cursors Count
Float
Current OS Processes Load
Float
cursor_bind_capture_destination
String
Cursor Cache Hit Ratio (%)
Float
cursor_sharing
String
cursor_space_for_time
String
Database CPU Time Ratio (%)
Float
Database Status
String
Database Time (centisecond)
Float
Database Wait Time Ratio (%)
Float
Data Transfer Cache Size (kB)
Integer
db_16k_cache_size
String
db_2k_cache_size
String
db_32k_cache_size
String
db_4k_cache_size
String
db_8k_cache_size
String
db_big_table_cache_percent_target
String
db_block_buffers
String
DB Block Changes
Float
DB Block Changes Per Txn
Float
DB Block Changes Per User Call
Float
db_block_checking
String
db_block_checksum
String
DB Block Gets
Float
DB Block Gets Per Txn
Float
DB Block Gets Per User Call
Float
db_block_size
String
db_cache_advice
String
db_cache_size
String
db_create_file_dest
String
db_domain
String
db_file_multiblock_read_count
String
db_files
String
DBFIPS_140
String
db_flashback_retention_target
String
db_flash_cache_size
String
db_index_compression_inheritance
String
db_keep_cache_size
String
db_lost_write_protect
String
db_name
String
db_recovery_file_dest
String
db_recovery_file_dest_size
String
db_recycle_cache_size
String
db_securefile
String
db_ultra_safe
String
db_unique_name
String
db_unrecoverable_scn_tracking
String
DBWR Checkpoints
Float
dbwr_io_slaves
String
db_writer_processes
String
ddl_lock_timeout
String
DDL statements parallelized
Float
deferred_segment_creation
String
dg_broker_config_file1
String
dg_broker_config_file2
String
dg_broker_start
String
diagnostic_dest
String
disk_asynch_io
String
Disk Sort
Float
Disk Sort Per Txn
Float
dispatchers
String
distributed_lock_timeout
String
dml_locks
String
DML statements parallelized
Float
dnfs_batch_size
String
dst_upgrade_insert_conv
String
enable_ddl_logging
String
enable_goldengate_replication
String
enable_pluggable_database
String
encrypt_new_tablespaces
String
Enqueue Deadlocks
Float
Enqueue Deadlocks Per Txn
Float
Enqueue Locks Current Utilization
Integer
Enqueue Locks Limit
Integer
Enqueue Requests
Float
Enqueue Requests Per Txn
Float
Enqueue Timeouts
Float
Enqueue Timeouts Per Txn
Float
Enqueue Waits
Float
Enqueue Waits Per Txn
Float
event
String
exafusion_enabled
String
exclude_seed_cdb_view
String
Execute Without Parse Ratio (%)
Float
Executions
Float
Executions Per Txn
Float
Executions Per User Call
Float
fal_server
String
fast_start_io_target
String
fast_start_mttr_target
String
fast_start_parallel_rollback
String
file_mapping
String
filesystemio_options
String
_fix_control
String
Fixed SGA Size (kB)
Integer
Free SGA Memory Available (kB)
Integer
Full Index Scans
Float
Full Index Scans Per Txn
Float
GC CR Block Received
Float
GC CR Block Received Per Txn
Float
GC Current Block Received
Float
GC Current Block Received Per Txn
Float
gcs_server_processes
String
Global Cache Average CR Get Time (centisecond)
Float
Global Cache Average Current Get Time (centisecond)
Float
Global Cache Blocks Corrupted
Float
Global Cache Blocks Lost
Float
global_names
String
global_txn_processes
String
Granule Size (kB)
Integer
Hard Parse Count
Float
Hard Parse Count Per Txn
Float
hash_area_size
String
heat_map
String
hi_shared_memory_address
String
Host CPU Usage (centisecond)
Float
Host CPU Utilization (%)
Float
Host Name
String
hs_autoregister
String
Inactive User Sessions
Integer
_index_join_enabled
String
inmemory_force
String
inmemory_max_populate_servers
String
inmemory_query
String
inmemory_size
String
inmemory_trickle_repopulate_servers_percent
String
_in_memory_undo
String
instance_name
String
Instance Name
String
instance_number
String
Instance Role
String
instance_type
String
instant_restore
String
I/O Requests
Float
I/O Throughput (MB/s)
Float
java_jit_enabled
String
java_max_sessionspace_size
String
java_pool_size
String
Java Pool Size (kB)
Integer
java_restrict
String
java_soft_sessionspace_limit
String
job_queue_processes
String
_kgl_large_heap_warning_threshold
String
Killed User Sessions
Integer
_ktb_debug_flags
String
large_pool_size
String
Large Pool Size (kB)
Integer
Latch Timeouts
Integer
Latch Time Waited (ms)
Integer
Latch Waits
Integer
ldap_directory_access
String
ldap_directory_sysauth
String
Leaf Node Splits
Float
Leaf Node Splits Per Txn
Float
Library Cache Hit Ratio (%)
Float
Library Cache Miss Ratio (%)
Float
license_max_sessions
String
license_max_users
String
license_sessions_warning
String
local_listener
String
lock_sga
String
log_archive_config
String
log_archive_dest
String
log_archive_dest_1
String
log_archive_dest_2
String
log_archive_dest_state_1
String
log_archive_dest_state_10
String
log_archive_dest_state_11
String
log_archive_dest_state_12
String
log_archive_dest_state_13
String
log_archive_dest_state_14
String
log_archive_dest_state_15
String
log_archive_dest_state_16
String
log_archive_dest_state_17
String
log_archive_dest_state_18
String
log_archive_dest_state_19
String
log_archive_dest_state_2
String
log_archive_dest_state_20
String
log_archive_dest_state_21
String
log_archive_dest_state_22
String
log_archive_dest_state_23
String
log_archive_dest_state_24
String
log_archive_dest_state_25
String
log_archive_dest_state_26
String
log_archive_dest_state_27
String
log_archive_dest_state_28
String
log_archive_dest_state_29
String
log_archive_dest_state_3
String
log_archive_dest_state_30
String
log_archive_dest_state_31
String
log_archive_dest_state_4
String
log_archive_dest_state_5
String
log_archive_dest_state_6
String
log_archive_dest_state_7
String
log_archive_dest_state_8
String
log_archive_dest_state_9
String
log_archive_format
String
log_archive_local_first
String
log_archive_max_processes
String
log_archive_min_succeed_dest
String
log_archive_start
String
log_archive_trace
String
log_buffer
String
log_checkpoint_interval
String
log_checkpoints_to_alert
String
log_checkpoint_timeout
String
Logical Reads
Float
Logical Reads Per Txn
Float
Logical Reads Per User Call
Float
Login Mode
String
Logons
Float
Logons Per Txn
Float
Long Table Scans
Float
Long Table Scans Per Txn
Float
max_dump_file_size
String
max_enabled_roles
String
Maximum SGA Size (kB)
Integer
Max Read Time (ms)
Integer
max_string_size
String
Max Write Time (ms)
Integer
memory_max_target
String
Memory Sorts Ratio (%)
Float
memory_target
String
_mutex_wait_scheme
String
_mutex_wait_time
String
Network Traffic Volume
Float
nls_comp
String
nls_date_format
String
nls_language
String
nls_length_semantics
String
nls_nchar_conv_excp
String
nls_territory
String
noncdb_compatible
String
Non-Waiting User Sessions
Integer
O7_DICTIONARY_ACCESSIBILITY
String
object_cache_max_size_percent
String
object_cache_optimal_size
String
olap_page_pool_size
String
open_cursors
String
Open Cursors
Float
Open Cursors Per Txn
Float
open_links
String
open_links_per_instance
String
_optimizer_adaptive_cursor_sharing
String
optimizer_adaptive_features
String
optimizer_adaptive_reporting_only
String
_optimizer_aggr_groupby_elim
String
_optimizer_batch_table_access_by_rowid
String
optimizer_capture_sql_plan_baselines
String
optimizer_dynamic_sampling
String
_optimizer_extended_cursor_sharing_rel
String
optimizer_features_enable
String
optimizer_index_caching
String
optimizer_index_cost_adj
String
optimizer_inmemory_aware
String
_optimizer_mjc_enabled
String
optimizer_mode
String
optimizer_secure_view_merging
String
_optimizer_use_feedback
String
optimizer_use_invisible_indexes
String
optimizer_use_pending_statistics
String
optimizer_use_sql_plan_baselines
String
_optim_peek_user_binds
String
os_authent_prefix
String
OS Client Users
String
OS Machines
Integer
os_roles
String
Parallel
String
parallel_adaptive_multi_user
String
parallel_automatic_tuning
String
parallel_degree_level
String
parallel_degree_limit
String
parallel_degree_policy
String
parallel_execution_message_size
String
parallel_fault_tolerance_enabled
String
parallel_force_local
String
parallel_io_cap_enabled
String
parallel_max_servers
String
Parallel Max Servers Current Utilization
Integer
Parallel Max Servers Limit
Integer
parallel_min_percent
String
parallel_min_servers
String
parallel_min_time_threshold
String
parallel_server
String
parallel_server_instances
String
parallel_servers_target
String
parallel_threads_per_cpu
String
Parse Failure Count
Float
Parse Failure Count Per Txn
Float
permit_92_wrap_format
String
pga_aggregate_limit
String
pga_aggregate_target
String
PGA Cache Hit (%)
Float
Physical Blocks Read
Integer
Physical Blocks Written
Integer
Physical Read (kB/s)
Float
Physical Read I/O Requests
Float
Physical Reads
Integer
Physical Reads
Float
Physical Reads Direct
Float
Physical Reads Direct Lobs
Float
Physical Reads Direct Lobs Per Txn
Float
Physical Reads Direct Per Txn
Float
Physical Reads Per Txn
Float
Physical Read Total (kB/s)
Float
Physical Read Total I/O Requests
Float
Physical Write (kB/s)
Float
Physical Write I/O Requests
Float
Physical Writes
Float
Physical Writes
Integer
Physical Writes Direct
Float
Physical Writes Direct Lobs
Float
Physical Writes Direct Lobs Per Txn
Float
Physical Writes Direct Per Txn
Float
Physical Writes Per Txn
Float
Physical Write Total (kB/s)
Float
Physical Write Total I/O Requests
Float
plscope_settings
String
plsql_code_type
String
plsql_debug
String
plsql_optimize_level
String
plsql_v2_compatibility
String
plsql_warnings
String
PQ QC Session Count
Float
PQ Slave Session Count
Float
pre_page_sga
String
processes
String
Processes Current Utilization
Integer
Processes Limit
Integer
Process Limit (%)
Float
PX downgraded to serial
Float
PX operations not downgraded
Float
Queries parallelized
Float
query_rewrite_enabled
String
query_rewrite_integrity
String
read_only_open_delayed
String
Read Time (ms)
Integer
recovery_parallelism
String
Recursive Calls
Float
Recursive Calls Per Txn
Float
recyclebin
String
Redo Allocation Hit Ratio (%)
Float
Redo Buffers Size (kB)
Integer
Redo Generated
Float
Redo Generated Per Txn (kB)
Float
Redo Writes
Float
Redo Writes Per Txn
Float
remote_dependencies_mode
String
remote_listener
String
remote_login_passwordfile
String
remote_os_authent
String
remote_os_roles
String
replication_dependency_tracking
String
resource_limit
String
resource_manager_cpu_allocation
String
resource_manager_plan
String
Response Time Per Txn (centisecond)
Float
result_cache_max_result
String
result_cache_max_size
String
result_cache_mode
String
result_cache_remote_expiration
String
resumable_timeout
String
Row Cache Hit Ratio (%)
Float
Row Cache Miss Ratio (%)
Float
Rows Per Sort
Float
Run Queue Processes
Float
sec_case_sensitive_logon
String
sec_max_failed_login_attempts
String
sec_protocol_error_further_action
String
sec_protocol_error_trace_action
String
sec_return_server_release_banner
String
_securefiles_concurrency_estimate
String
serial_reuse
String
service_names
String
session_cached_cursors
String
Session Count
Float
Session Limit (%)
Float
session_max_open_files
String
sessions
String
Sessions Count
Integer
Sessions Current Utilization
Integer
Sessions Limit
Integer
sga_max_size
String
sga_target
String
shadow_core_dump
String
Shared IO Pool Size (kB)
Integer
shared_memory_address
String
Shared Pool Free (%)
Float
shared_pool_reserved_size
String
shared_pool_size
String
Shared Pool Size (kB)
Integer
shared_servers
String
Shutdown Pending
String
Single Blocks Read
Integer
skip_unusable_indexes
String
Sniped User Sessions
Integer
Soft Parse Ratio (%)
Float
sort_area_retained_size
String
sort_area_size
String
_sort_elimination_cost_ratio
String
spatial_vector_acceleration
String
spfile
String
sql92_security
String
SQL Service Response Time (centisecond)
Float
sql_trace
String
sqltune_category
String
standby_archive_dest
String
standby_file_management
String
star_transformation_enabled
String
Startup overhead in Shared Pool (kB)
Integer
Startup Time
String
statistics_level
String
Status
String
streams_pool_size
String
Streams Pool Size (kB)
Integer
Streams Pool Usage (%)
Float
_suppress_identifiers_on_dupkey
String
_table_lookup_prefetch_size
String
tape_asynch_io
String
Temp Space Used (kB)
Float
temp_undo_enabled
String
thread
String
threaded_execution
String
timed_os_statistics
String
timed_statistics
String
Timeouts
Integer
Time Waited (ms)
Integer
Total Index Scans
Float
Total Index Scans Per Txn
Float
Total Parse Count
Float
Total Parse Count Per Txn
Float
Total PGA Allocated (kB)
Float
Total PGA Used by SQL Workareas (kB)
Float
Total Sorts Per User Call
Float
Total Table Scans
Float
Total Table Scans Per Txn
Float
Total Table Scans Per User Call
Float
trace_enabled
String
transactions
String
transactions_per_rollback_segment
String
Txns Per Logon
Float
Unblocked User Sessions
Integer
undo_management
String
undo_retention
String
undo_tablespace
String
unified_audit_sga_queue_size
String
Unknown Wait Time User Sessions
Integer
use_dedicated_broker
String
use_indirect_data_buffers
String
use_large_pages
String
User Calls
Float
User Calls Per Txn
Float
User Calls Ratio (%)
Float
User Commits (%)
Float
User Commits
Float
user_dump_dest
String
User Limit (%)
Float
User Rollbacks
Float
User Rollbacks (%)
Float
User Rollback UndoRec Applied
Float
User Rollback Undo Records Applied Per Txn
Float
User Transactions
Float
User Types
Integer
_use_single_log_writer
String
utl_file_dir
String
Version
String
Waiting User Sessions
Integer
Waits
Integer
workarea_size_policy
String
Workload Capture and Replay status
Integer
Write Time (ms)
Integer
xml_db_events
String