Database entities and metrics

Specific types

Icon

System name

Description

Cluster Database

a DBMS cluster

Database Instance

a DBMS instance

Icon

Business driver name

Description

Database business driver

business driver on database instances

Datasets

Dataset name

Description

DBCNF

Database configuration data

DBEVENT

Database events

DBFSSTOR

Database file system configuration

DBMEM

Database memory configuration

DBOBJST

Database objects storage size

DBPKGAUTH

Database package authorization

DBRES

Database resources

DBSTAT

Database statistics

DBSTOR

Database Data storage

DBTDSTAT

Teradata Database statistics

Metrics

Dataset name

Metric name

Description

DBCNF

DB_CPU_COUNT

DB CPU Count

DBCNF

DB_HOST_NAME

DB Host Name

DBCNF

DB_NAME

DB Name

DBCNF

DB_PRODUCT_NAME

DB Product Name

DBCNF

DB_PRODUCT_TYPE

DB Product Type

DBCNF

DB_PRODUCT_VERSION

DB Product Version

DBCNF

DB_ROLE

Database role

DBEVENT

DB_BUFFER_BUSY_WAITS

DB Buffer Busy Waits

DBEVENT

DB_BUFFER_BUSY_WAITS_COUNT

DB Buffer Busy Waits Count

DBEVENT

DB_DIRECT_PATH_READ

DB Direct Path Read

DBEVENT

DB_DIRECT_PATH_READ_COUNT

DB Direct Path Read Count

DBEVENT

DB_DIRECT_PATH_WRITE

DB Direct Path Write

DBEVENT

DB_DIRECT_PATH_WRITE_COUNT

DB Direct Path Write Count

DBEVENT

DB_ENQUEUE

DB Enqueue

DBEVENT

DB_ENQUEUE_COUNT

DB Enqueue Count

DBEVENT

DB_FILE_SCATTERED_READ

DB File Scattered Read

DBEVENT

DB_FILE_SCATTERED_READ_COUNT

DB File Scattered Read Count

DBEVENT

DB_FILE_SEQUENTIAL_READ

DB File Sequential Read

DBEVENT

DB_FILE_SEQUENTIAL_READ_COUNT

DB File Sequential Read Count

DBEVENT

DB_LOG_FILE_SYNC

DB Log File SYNC

DBEVENT

DB_LOG_FILE_SYNC_COUNT

DB Log File Sync Count

DBFSSTOR

CONF_C

Test metrica di conf

DBFSSTOR

DB_CF_ALLOCATED_SIZE

DB ControlFile Allocated Size

DBFSSTOR

DB_CF_ALLOCATED_SIZE_PCT

DB ControlFile Allocated Size %

DBFSSTOR

DB_CF_FREE_SIZE

DB ControlFile Free Size

DBFSSTOR

DB_CF_MAX_SIZE

DB ControlFile Max Size

DBFSSTOR

DB_CF_USED_SIZE

DB ControlFile Used Size

DBFSSTOR

DB_CF_USED_SIZE_PCT

DB ControlFile Used Size %

DBFSSTOR

DB_DATA_ALLOCATED_SIZE

DB Data Allocated Size

DBFSSTOR

DB_DATA_ALLOCATED_SIZE_PCT

DB Data Allocated Size %

DBFSSTOR

DB_DATA_FREE_SIZE

DB Data Free Size

DBFSSTOR

DB_DATA_MAX_SIZE

DB Data Max Size

DBFSSTOR

DB_DATA_USED_SIZE

DB Data Used Size

DBFSSTOR

DB_DATA_USED_SIZE_PCT

DB Data Used Size %

DBFSSTOR

DB_FILE_SYSTEM_SIZE

DB File System Size

DBFSSTOR

DB_LOG_ALLOCATED_SIZE

DB Log Allocated Size

DBFSSTOR

DB_LOG_ALLOCATED_SIZE_PCT

DB Log Allocated Size %

DBFSSTOR

DB_LOG_FREE_SIZE

DB Log Free Size

DBFSSTOR

DB_LOG_MAX_SIZE

DB Log Max Size

DBFSSTOR

DB_LOG_USED_SIZE

DB Log Used Size

DBFSSTOR

DB_LOG_USED_SIZE_PCT

DB Log Used Size %

DBFSSTOR

DB_RESERVED_SIZE

DB Reserved Size

DBFSSTOR

DB_TOTAL_ALLOCATED_SIZE

DB Total Allocated Size

DBFSSTOR

DB_TOTAL_ALLOCATED_SIZE_PCT

DB Total Allocated Size %

DBFSSTOR

DB_TOTAL_FREE_SIZE

DB Total Free Size

DBFSSTOR

DB_TOTAL_MAX_SIZE

DB Total Max Size

DBFSSTOR

DB_TOTAL_UNALLOCATED_SIZE

DB Total Unallocated Size

DBFSSTOR

DB_TOTAL_USED_SIZE

DB Total Used Size

DBFSSTOR

DB_TOTAL_USED_SIZE_PCT

DB Total Used Size %

DBMEM

DB_DATA_CACHE_SIZE

DB Data Cache Size

DBMEM

DB_MEM_ALLOCATED

DB Memory Allocated

DBMEM

DB_MEM_CONNECTION

DB Connection Memory

DBMEM

DB_MEM_GRANTED_WORKSPACE

DB Granted Workspace Memory

DBMEM

DB_MEM_LOCK

DB Lock Memory

DBMEM

DB_MEM_LOGICAL

DB Logical Memory

DBMEM

DB_MEM_MAX_PAGES

DB Mem Max Size Pages

DBMEM

DB_MEM_MAX_SIZE

DB Mem Max Size

DBMEM

DB_MEM_MAX_WORKSPACE

DB Maximum Workspace Memory

DBMEM

DB_MEM_OPTIMIZER

DB Optimizer Memory

DBMEM

DB_MEM_PHYSICAL

DB Physical Memory

DBMEM

DB_MEM_SQL_CACHE

DB SQL Cache Memory

DBMEM

DB_MEM_TARGET_SERVER

DB Target Server Memory

DBMEM

DB_MEM_TOTAL_SERVER

DB Total Server Memory

DBMEM

DB_MEM_VIRTUAL

DB Virtual Memory

DBMEM

DB_PGA_SIZE

DB PGA Size

DBMEM

DB_PROCEDURE_CACHE_SIZE

DB Procedure Cache Size

DBMEM

DB_PROCEDURE_CACHE_USED

DB Procedure Cache Used

DBMEM

DB_SGA_DATABASE_BUFFERS

DB SGA Database Buffers

DBMEM

DB_SGA_FIXED_SIZE

DB SGA Fixed Size

DBMEM

DB_SGA_POOL_SIZE

SGA pool size

DBMEM

DB_SGA_REDO_BUFFERS

DB SGA Redo Buffers

DBMEM

DB_SGA_VARIABLE_SIZE

DB SGA Variable Size

DBMEM

DB_UGA_SIZE

DB UGA Size

DBPKGAUTH

BYPKGAUTH_CPU_TIME

CPU time by package

DBPKGAUTH

BYPKGAUTH_ELAPSED_TIME

Elapsed time by package

DBPKGAUTH

BYPKGAUTH_IO_WAIT_TIME

IO wait time by package

DBPKGAUTH

BYPKGAUTH_LOCK_WAIT_TIME

Lock wait time by package

DBPKGAUTH

BYPKGAUTH_PER_RUN_CPU_TIME

CPU time by package, per run

DBPKGAUTH

BYPKGAUTH_PER_RUN_ELAPSED_TIME

Elapsed time by package, per run

DBPKGAUTH

BYPKGAUTH_PER_RUN_IO_WAIT_TIME

IO wait time by package, per run

DBPKGAUTH

BYPKGAUTH_PER_RUN_LOCK_WAIT_TIME

Lock wait time by package, per run

DBPKGAUTH

BYPKGAUTH_PER_RUN_READ_WAIT_TIME

Read wait time by package, per run

DBPKGAUTH

BYPKGAUTH_PER_RUN_SQL_STATEMENTS

SQL statements by package, per run

DBPKGAUTH

BYPKGAUTH_PER_RUN_SYNC_WAIT_TIME

Sync wait time by package, per run

DBPKGAUTH

BYPKGAUTH_PER_RUN_TOTAL_WAIT_TIME

Total wait time by package, per run

DBPKGAUTH

BYPKGAUTH_PER_RUN_WRITE_WAIT_TIME

Write wait time by package, per run

DBPKGAUTH

BYPKGAUTH_READ_WAIT_TIME

Read wait time by package

DBPKGAUTH

BYPKGAUTH_RUNS

Package runs

DBPKGAUTH

BYPKGAUTH_SYNC_WAIT_TIME

Sync wait time by package

DBPKGAUTH

BYPKGAUTH_TOTAL_WAIT_TIME

Total wait time by package

DBPKGAUTH

BYPKGAUTH_WRITE_WAIT_TIME

Write wait time by package

DBRES

DB_BLOCKED_OBJS

DB Blocked Objects

DBRES

DB_ENQUEUE_LOCKS

DB Enqueue Locks

DBRES

DB_ENQUEUE_LOCKS_LIMIT

DB Enqueue Locks Limit

DBRES

DB_ENQUEUE_LOCKS_PEAK

DB Enqueue Locks Peak

DBRES

DB_PARALLEL_MAX_SERVERS

DB Parallel Max Servers

DBRES

DB_PARALLEL_MAX_SERVERS_LIMIT

DB Parallel Max Servers Limit

DBRES

DB_PARALLEL_MAX_SERVERS_PEAK

DB Parallel Max Servers Peak

DBRES

DB_PROCESSES

DB Processes

DBRES

DB_PROCESSES_LIMIT

DB Processes Limit

DBRES

DB_PROCESSES_PEAK

DB Processes Peak

DBRES

DB_SESSIONS

DB Session

DBRES

DB_SESSIONS_LIMIT

DB Session Limit

DBRES

DB_SESSIONS_PEAK

DB Session Peak

DBSTAT

DB_ACTIVE_TRANSACTIONS

DB Active Transactions

DBSTAT

DB_BLOCK_CHANGES

DB Block Changes

DBSTAT

DB_BLOCK_GETS

DB Block Gets

DBSTAT

DB_BLOCK_GETS_CACHE

DB Block Gets From Cache

DBSTAT

DB_BUFFER_CACHE_HIT_RATIO

DB Buffer Cache Hit Ratio

DBSTAT

DB_BUFFER_GETS

DB Buffer Gets

DBSTAT

DB_BUFFER_HIT_RATIO

DB Buffer Hit Ratio

DBSTAT

DB_BUFFER_NOWAIT_PCT

DB Buffer No Wait %

DBSTAT

DB_BUFFER_WAITS

DB Buffer Waits

DBSTAT

DB_BYTES_RECEIVED

DB Bytes Received

DBSTAT

DB_BYTES_RECEIVED_DBLINK

DB Bytes Received DB Link

DBSTAT

DB_BYTES_RECEIVED_RATE

DB Byte Received Rate

DBSTAT

DB_BYTES_SENT

DB Bytes Sent

DBSTAT

DB_BYTES_SENT_DBLINK

DB Bytes Sent DB Link

DBSTAT

DB_BYTES_SENT_RATE

DB Byte Sent Rate

DBSTAT

DB_CACHE_USED_PCT

DB Used Cache %

DBSTAT

DB_COMMIT_RATE

DB Commits Rate

DBSTAT

DB_CONF_DATA_CACHE_PCT

DB Data Cache %

DBSTAT

DB_CONSISTENT_CHANGES

DB Consistent Changes

DBSTAT

DB_CONSISTENT_GETS

DB Consistent Gets

DBSTAT

DB_CONSISTENT_GETS_CACHE

DB Consistent Gets From Cache

DBSTAT

DB_CPU_PARSE_TIME

DB CPU Parse Time

DBSTAT

DB_CPU_USED

DB CPU Used %

DBSTAT

DB_DDL_COUNT

DB SQL DDL operations

DBSTAT

DB_DEADLOCKS

DB Deadlocks

DBSTAT

DB_DELETE_COUNT

DB SQL Delete operations

DBSTAT

DB_DICTIONARY_HIT_RATIO

Procedure Hit Percent

DBSTAT

DB_DML_USED_LOCKS_PCT

DB DML Locks %

DBSTAT

DB_ELAPSED_PARSE_TIME

DB Elapsed Parse Time

DBSTAT

DB_ENGINES_AT_STARTUP

DB Engines at Startup

DBSTAT

DB_EXECUTE_COUNT

DB Execute Count

DBSTAT

DB_EXECUTE_TO_PARSE_PCT

DB Execute To Parse %

DBSTAT

DB_EXTENTS_ALLOCATED

DB Extents Allocated

DBSTAT

DB_FRAG_TBL_SPACE

DB Fragmented Tablespaces

DBSTAT

DB_FULL_SCANS

DB Full Scans

DBSTAT

DB_FULL_SCANS_RATE

DB Full Scans Rate

DBSTAT

DB_GETS

DB Gets

DBSTAT

DB_IDLE

DB Idle %

DBSTAT

DB_INDEX_SEARCHES

DB Index Searches

DBSTAT

DB_INSERT_COUNT

DB SQL Insert operations

DBSTAT

DB_IO_RATE

DB I/O rate

DBSTAT

DB_IO_USED

DB I/O Used %

DBSTAT

DB_LATCH_HIT_RATIO

DB Latch Hit Ratio

DBSTAT

DB_LIBRARY_CACHE_HIT_RATIO

DB Library Cache Hit Ratio

DBSTAT

DB_LOCK_RATE

DB Lock Rate

DBSTAT

DB_LOCKS

DB Locks Count

DBSTAT

DB_LOGICAL_READS

DB Logical Reads

DBSTAT

DB_LOGICAL_READS_RATE

DB Logical Reads Rate

DBSTAT

DB_LOGON_RATE

DB Logon Rate

DBSTAT

DB_LOGONS

DB Logons

DBSTAT

DB_LOGONS_CURRENT

DB Logons Current

DBSTAT

DB_MAX_ONLINE_ENGINES

DB Max Online Engines

DBSTAT

DB_MEM_ERRORS

DB Memory Errors

DBSTAT

DB_MEMORY_FAILURES

DB Memory failures

DBSTAT

DB_MISSES

DB Misses

DBSTAT

DB_NON_PARSE_CPU_PCT

DB Non Parse CPU %

DBSTAT

DB_OPENED_CURSORS

DB Opened Cursors

DBSTAT

DB_OPENED_CURSORS_CURRENT

DB Current Opened Cursors

DBSTAT

DB_OTHER_STATEMENT_COUNT

DB SQL Other Statements

DBSTAT

DB_PACKETS_ERROR

DB Packets Error

DBSTAT

DB_PACKETS_RECEIVED

DB Packets Received

DBSTAT

DB_PACKETS_SENT

DB Packets Sent

DBSTAT

DB_PAGE_ALLOCATED

DB Page Allocated

DBSTAT

DB_PAGE_LOOKUP

DB Page Lookup

DBSTAT

DB_PAGE_READS

DB Page Reads

DBSTAT

DB_PAGE_SPLITS

DB Page Splits

DBSTAT

DB_PAGE_WRITES

DB Page Writes

DBSTAT

DB_PARSE_COUNT_HARD

DB Parse Count Hard

DBSTAT

DB_PARSE_COUNT_TOTAL

DB Parse Count Total

DBSTAT

DB_PARSE_CPU_TO_ELAPSED_PCT

DB Parse CPU to Elapsed %

DBSTAT

DB_PHYSICAL_READS

DB Physical Reads

DBSTAT

DB_PHYSICAL_READS_CACHE

DB Physical Reads From Cache

DBSTAT

DB_PHYSICAL_READS_RATE

DB Physical Reads Rate

DBSTAT

DB_PHYSICAL_WRITES

DB Physical Writes

DBSTAT

DB_PIN_HITS

DB Pin Hits

DBSTAT

DB_PINS

DB Pins

DBSTAT

DB_PROCESSES_PCT

DB Processes %

DBSTAT

DB_REDO_BLOCKS_WRITTEN

DB Redo Blocks Written

DBSTAT

DB_REDO_ENTRIES

DB Redo Entries

DBSTAT

DB_REDO_LOG_SPACE_REQUESTS

DB Redo Log Space Requests

DBSTAT

DB_REDO_NOWAIT_PCT

DB Redo No Wait %

DBSTAT

DB_REDO_SIZE

DB Redo Size

DBSTAT

DB_REDO_WRITES

DB Redo Writes

DBSTAT

DB_ROWS_DELETED_RATE

DB Rows Deleted Rate

DBSTAT

DB_ROWS_INSERTED_RATE

DB Rows Inserted Rate

DBSTAT

DB_ROWS_READ

DB Read Rows

DBSTAT

DB_ROWS_UPDATED

DB Updated Rows

DBSTAT

DB_ROWS_UPDATED_RATE

DB Rows Updated Rate

DBSTAT

DB_SELECT_RATE

DB Select Rate

DBSTAT

DB_SESSION_CURSORS_CACHE

DB Session Cached Cursors

DBSTAT

DB_SESSIONS_PCT

DB Session %

DBSTAT

DB_SOFT_PARSE_PCT

DB Soft Parse %

DBSTAT

DB_SORT_MEM_HIT_RATIO

DB In-memory Sort %

DBSTAT

DB_SORTS_DISK

DB Sorts Disk

DBSTAT

DB_SORTS_MEMORY

DB Sorts Memory

DBSTAT

DB_SORTS_ROWS

DB Sorts Rows

DBSTAT

DB_SPIN_LOCK_CONT_PCT

DB Cache Spinlock Contentions %

DBSTAT

DB_SQL_READ

DB SQL Read

DBSTAT

DB_SQL_UPDATE

DB SQL Update

DBSTAT

DB_TABLE_FETCH_BY_ROWID

DB Table Fetch By ROWID

DBSTAT

DB_TABLE_FETCH_CONTINUED_ROW

DB Table Fetch Continued Row

DBSTAT

DB_TABLE_SCAN_ROWS_GOTTEN

DB Table Scans Rows Gotten

DBSTAT

DB_TABLE_SCANS_LONG_TABLES

DB Table Scans Long Tables

DBSTAT

DB_TABLE_SCANS_SHORT_TABLES

DB Table Scans Short Tables

DBSTAT

DB_TASK_CTX_SWITCH_PCT

DB Context Task Switching %

DBSTAT

DB_TOP_DEVICE_IO_RATE

DB most used device I/O rate

DBSTAT

DB_TOTAL_IO

DB Total IO

DBSTAT

DB_TRAN_RATE

DB Transactions Rate

DBSTAT

DB_TRANSACTIONS

DB Transactions

DBSTAT

DB_TRANSACTIONS_PCT

DB Transactions %

DBSTAT

DB_UNANALYZED_OBJ_RATIO

DB Unanalyzed Object Ratio

DBSTAT

DB_UPDATE_COUNT

DB SQL Update operations

DBSTAT

DB_USER_CALLS

DB Users Calls

DBSTAT

DB_USER_COMMITS

DB Users Commits

DBSTAT

DB_USER_ROLLBACKS

DB Users Rollbacks

DBSTAT

DB_USERS

DB Users

DBSTAT

DB_UTILITY_STATEMENT_COUNT

DB SQL Utility Statements

DBSTAT

DB_WRITE_ERRORS

DB Write Errors

DBSTOR

BYDS_CF_ALLOCATED_SIZE

DS CF Allocated Size

DBSTOR

BYDS_CF_USED_SIZE

DS CF Used Size

DBSTOR

BYDS_CF_USED_SIZE_PCT

DS CF Used Size %

DBSTOR

BYDS_DATA_ALLOCATED_SIZE

DS Data Allocated Size

DBSTOR

BYDS_DATA_USED_SIZE

DS Data Used Size

DBSTOR

BYDS_DATA_USED_SIZE_PCT

DS Data Used Size %

DBSTOR

BYDS_LOG_ALLOCATED_SIZE

DS Log Allocated Size

DBSTOR

BYDS_LOG_USED_SIZE

DS Log Used Size

DBSTOR

BYDS_LOG_USED_SIZE_PCT

DS Log Used Size %

DBSTOR

BYDS_TOTAL_PHYSICAL_IO

By Data Storage Total Physical IO

DBSTOR

BYIDX_USED_SPACE

Index Used Size

DBSTOR

BYTBL_USED_SPACE

Table Used Size

DBSTOR

DB_TRANSACTION_RESPONSE_TIME

DB Transaction response time

DBTDSTAT

CPU_UTIL_SKEW

CPU Utilization Skew

DBTDSTAT

DB_AWT_FLOW_CONTROL_COUNT

AWT Flow control state

DBTDSTAT

DB_AWT_RUNNING_PEAK

AWT Running on this node

Analysis templates

Group

Name

Description

Database

Allocated Storage Space Pie

Shows the data, control file and log allocated storage space for the database.

Database

Average Active Transactions

Shows average active transactions for each database.

Database

Average Event Wait Time

Shows DB_BUFFER_BUSY_WAITS, DB_DIRECT_PATH_READ, DB_ENQUEUE, DB_FILE_SCATTERED_READ, DB_FILE_SEQUENTIAL_READ, DB_LOG_FILE_SYNC for each system.

Database

Average Logons Current

Shows DB_LOGONS_CURRENT.

Database

Average Transaction Rate

Shows DB_TRAN_RATE.

Database

Block Activity

Shows DB_REDO_BLOCKS_WRITTEN, DB_CONSISTENT_CHANGES, DB_CONSISTENT_GETS, DB_BLOCK_CHANGES, DB_BLOCK_GETS.

Database

Buffer Cache Efficiency

Shows DB_BUFFER_CACHE_HIT_RATIO.

Database

Buffer Efficiency

Shows Database Buffer Hit Ratio and Database Buffer No-Wait Percentage.

Database

Configuration History

Shows the historical values of the configuration metrics for the database.

Database

Control File Storage Space Allocation

Shows the control file storage space allocation for each database.

Database

Data Storage Space Allocation

Shows the data storage space allocation for each database

Database

Database host storage analysis

Shows allocated, free and used space of total and data space on the database host.

Database

DB CPU Utilization

Shows DB_CPU_USED, DB_IO_USED.

Database

Disk Activity

Shows DB_PHYSICAL_WRITES, DB_PHYSICAL_READS, DB_TOTAL_IO, DB_LOGICAL_READS, DB_REDO_WRITES.

Database

Efficiency

Shows Database latch hit ratio, library cache hit ratio, redo no wait percentage and in-memory sort hit ratio.

Database

Enqueue Locks

Shows ENQUEUE_LOCKS current value, max value and limit value for each system.

Database

Event Count Analysis

Shows DB_BUFFER_BUSY_WAITS_COUNT, DB_DIRECT_PATH_READ_COUNT, DB_ENQUEUE_COUNT, DB_FILE_SCATTERED_READ_COUNT, DB_FILE_SEQUENTIAL_READ_COUNT, DB_LOG_FILE_SYNC_COUNT for each system.

Database

Extents Allocation

Shows extents allocated for each database.

Database

Global Metrics

Shows all database GLOBAL metrics for each system.

Database

Last Configuration

Shows the current values of the configuration metrics for the database.

Database

Load Indicators

Shows Database Execute Count, Logical and Physical Reads, Transactions on a summary table chart. One table for each Database is shown.

Database

Log Storage Space Allocation

Shows the log storage space allocation for each database.

Database

Logons Volume

Shows DB_LOGONS

Database

Memory Allocation

Shows Memory Allocation for each database.

Database

Memory Composition Pie

Shows Memory Composition for each database.

Database

Network Traffic

Shows DB_BYTES_RECEIVED, DB_BYTES_RECEIVED_DBLINK, DB_BYTES_SENT, DB_BYTES_SENT_DBLINK.

Database

Packet Activity

Shows number of packets received, sent and the number of packet errors for each database.

Database

Page Activity

Shows number of page reads, writes, splits, lookups and the number of pages allocated for each database.

Database

Parallel Max Servers

Shows PARALLEL_MAX_SERVERS current value, max value and limit value for each system.

Database

Parse Behaviour

Shows Database execute to parse, non-parse CPU, parse CPU to elapsed and soft parse percentages.

Database

PGA-UGA Analysis

Shows PGA and UGA behaviour for each Database over time.

Database

Processes

Shows PROCESSES current value, max value and limit value for each system.

Database

Query Activity

Shows DB_EXECUTE_COUNT, DB_PARSE_COUNT_HARD, DB_PARSE_COUNT_TOTAL, DB_OPENED_CURSORS, DB_USER_CALLS.

Database

Reserved Storage Space Pie

Shows the reserved storage space allocation for the database.

Database

Resource Analysis

Shows DB_ENQUEUE_LOCKS, DB_PARALLEL_MAX_SERVERS, DB_PROCESSES, DB_SESSIONS for each system.

Database

Row Access

Shows DB_SORTS_ROWS, DB_TABLE_SCAN_ROWS_GOTTEN.

Database

Sessions

Shows SESSIONS current value, max value and limit value for each system.

Database

SGA Configuration

Shows the SGA Analysis for each Database as a summary table.

Database

Sorts

Shows DB_SORTS_MEMORY, DB_SORTS_DISK.

Database

Storage Analysis by Datastore

Shows used and allocated storage spaces for each datastore of the database.

Database

Storage Analysis

Shows used and allocated storage spaces for each database.

Database

Storage Space Allocation Percentage

Shows the storage allocation space percentage for each database.

Database

Storage Summary Pie

Shows summary of storage usage, reporting disk space used by LOG and DATA.

Database

Storage Used Space

Show used space percentage for the database.

Database

Table Access

Shows DB_TABLE_FETCH_BY_ROWID, DB_TABLE_FETCH_CONTINUED_ROW, DB_TABLE_SCANS_LONG_TABLES, DB_TABLE_SCANS_SHORT_TABLES, DB_INDEX_SEARCHES.

Database

Top 10 database indexes by size over time

Shows used space over time of the top 10 indexes for each database.

Database

Top 10 database indexes by size

Shows a summary of the top 10 indexes by used space for each database.

Database

Top 10 database tables by size over time

Shows used space over time of the top 10 tables for each database.

Database

Top 10 database tables by size

Shows a summary of the top 10 tables by used space for each database.

Database

Transaction Volume

Shows DB_TRANSACTIONS, DB_USER_COMMITS, DB_USER_ROLLBACKS for each system.

Database

Used Storage Space Pie

Shows the data, control file and log used storage space for the database.

Database

Used Storage Space

Shows data, control file and log used storage space percentage for each database.

Was this page helpful? Yes No Submitting... Thank you

Comments