Skip Headers
Oracle® Enterprise Manager System Monitoring Plug-in for Oracle TimesTen In-Memory Database User's Guide
Release 12.1.0.2.0

E28645-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

6 Viewing Metrics

This chapter details metric information collected for your TimesTen database to assist you in determining the efficiency and performance of your database.

Topics include:

Navigating to the metrics page

Make sure you are on the TimesTen target page. For more information on navigating to the TimesTen target page, see "Navigating to the TimesTen target page".

  1. From the TimesTen IMDB menu, select Monitoring, then select All Metrics.

    The All Metrics page displays. Locate the name of the metric group.

  2. Expand the metric group, and click the name of the metric.

    The metric information displays in table format.

Viewing metrics

There are 12 groups of metrics:

Figure 6-2 Groups of metrics

Description of Figure 6-2 follows
Description of "Figure 6-2 Groups of metrics"

Some metrics have predefined warning and critical thresholds. You can modify and add new thresholds. The Oracle Enterprise Manager Cloud Control issues alerts and warnings when the values collected for the metrics surpass the set threshold.

Checkpoint history

Table 6-1 lists each metric and provides a description of the metric.

Table 6-1 Checkpoint History

Metric Description

Bytes written in MB

Bytes written in megabytes.

Bytes written per sec

Bytes written per second.

Checkpoint sequence number

Checkpoint sequence number.

Of blksTotal, the number of blocks currently in use

Of blksTotal, the number of blocks currently in use.

Permanent blocks currently allocated in the database

Permanent blocks currently allocated in the database.

Status of the checkpoint operation

Status of the checkpoint operation.

The database file number used by the checkpoint

The database file number used by the checkpoint.

The number of bytes occupied by blksDirty

The number of bytes occupied by blksDirty.

The number of bytes occupied by blksInUse

The number of bytes occupied by blksInUse.

The number of bytes occupied by blksTotal

The number of bytes occupied by blksTotal.

The number of dirty blocks written by this checkpoint

The number of dirty blocks written by this checkpoint.

The source of the checkpoint request

The source of the checkpoint request.

The total number of bytes written by this checkpoint

The total number of bytes written by this checkpoint.

The transaction log file number of the checkpoint log record

The transaction log file number of the checkpoint log record.

The transaction log file offset of the checkpoint log record

The transaction log file offset of the checkpoint log record.

Percentage of the checkpoint that has been completed

Indicates the percentage of the checkpoint that has been completed. If there is no checkpoint in progress, the value is NULL.

The type of checkpoint

The type of checkpoint.

Time when the checkpoint completed

Time when the checkpoint completed.

Time when the checkpoint was begun

Time when the checkpoint began.

TimesTen error number which indicates the reason for the failure

TimesTen error number that indicates the reason for the failure.


Checkpoint and transaction log file system usage

Table 6-2 lists each metric and provides a description of the metric.

Table 6-2 Checkpoint and Transaction Log File System Usage

Metric Description

Checkpoint file system

Checkpoint file system.

Checkpoint file system mount Point

Checkpoint file system mount point.

Checkpoint file system size (MB)

Checkpoint file system size in megabytes.

Checkpoint file system space available (%)

Checkpoint file system space available (expressed as a percentage).

Checkpoint file system space available (MB)

Checkpoint file system space available in megabytes.

Transaction log file system size (MB)

Transaction log file system size in megabytes.

Transaction log file system

Transaction log file system.

Transaction log file system mount point

Transaction log file system mount point.

Transaction log file system space available (%)

Transaction log file system space available (expressed as a percentage).

Transaction log file system space available (MB)

Transaction log file system space available in megabytes.


Database Information

Table 6-3 shows information about your database.

Table 6-3 Database Information

Database information Description

Active standby pair table creation replication

Database attribute is DDLReplicationAction.

If set to 'INCLUDE' (the default): When a table is created, the table is automatically added to the active standby pair scheme. If set to 'EXCLUDE': When a table is created, the table is not automatically included in the active standby pair.

Amount of data in log between background checkpoints

Amount of data in megabytes that collects in log between background checkpoints.

Cache agent policy

Cache agent policy (always, manual).

Cache agent running

1 if running; 0 if not running.

Character encoding for the connection

Character encoding for the connection. May be different than database character set.

Commit operations should write log records to disk

If set (=1), commit operations write log records to disk.

Controls conditional compilation of PL/SQL units

Controls conditional compilation of PL/SQL units.

Controls transactional commit behavior in relation to DDL

Controls transactional commit behavior in relation to DDL. If 0, Oracle. If 1, Timesten.

Determines if commands are shared between connections

Determines if commands are shared between connections.

Determines whether PL/SQL is enabled

Determines if PL/SQL is enabled. (1 = enabled.)

Enables AWT propagation method to be used on Oracle tables

Database attribute is CacheAWTMethod.

Determines whether PL/SQL execution method or SQL array execution method is used for Asynchronous Writethrough propagation to apply changes to the Oracle server.

If 0, SQL array execution method is used.

If 1 (the default), PL/SQL execution method is used.

Enables cache grid

If set (=1), cache grid is enabled.

Enables transparent load to dynamic cache groups

If set (=1), enables transparent load of Oracle data to dynamic cache groups.

Error returned upon transparent load failure

If set (=1), error message is returned if there is a transparent load failure.

Expected upper bound for concurrent connections

Indicates the expected upper bound on the number of concurrent connections to the database.

Frequency in seconds for background checkpoint

Frequency in seconds that TimesTen performs a background checkpoint.

Identifies the character set used by the data store

Identifies the character set used by the database.

Identifies the physical data store

Identifies the physical database.

Is error reported for data loss from character type conversion

Determines if error is reported when there is data loss during an implicit or explicit character type conversion between NCHAR/NVARCHAR2 and CHAR/VARCHAR2 data.

Isolation level read committed or serializable

Specifies whether the isolation level is read committed or serializable. If 1, read committed.

Level of DDL replication enabled

Database attribute is DDLReplicationLevel.

If 1, replicates ALTER TABLE ADD or DROP COLUMN to the standby database. Does not replicate CREATE and DROP operations for tables, indexes or synonyms to the standby database.

If 2 (the default), replicates creating and dropping of tables, indexes and synonyms.

Location of PL/SQL memory segment

Virtual address of shared memory segment that is loaded into each process that uses the TimesTen "direct" drivers.

Lock wait interval

Lock wait interval for connection.

Max rate data written to disk during checkpoint

Maximum rate data is written to disk during a checkpoint operation.

Maximum process heap memory PL/SQL can use for this connection

Specifies the maximum amount of process heap memory in megabytes that PL/SQL can use for the connection.

Method used to write and sync log data to transaction log files

Method used to write and sync log data to transaction log files. If 1, buffered writes are used to write data to transaction log files.

Number of tracks available for parallel replication

Database attribute is ReplicationParallelism.

Possible values are between 1 and 64, indicating the number of tracks to replicate in parallel. The default is 1 indicating single-threaded replication.

Number threads used to apply changes on active master data store

Number of threads used to apply changes on the active master database to the standby master database in an active standby pair replication scheme.

Optimization level used to compile PL/SQL library units

Optimization level used to compile PL/SQL library units.

Oracle Service Name of Oracle instance from which data is loaded

Oracle Service Name of the Oracle instance from which data is to be loaded into a TimesTen database.

PL/SQL memory segment size

Size in megabytes of the shared memory segment used by PL/SQL.

Parallel replication apply ordering

Database attribute is ReplicationApplyOrdering.

If 0 (the default), specifies commit ordering parallel replication.

If 1, specifies user-managed track based parallel replication.

Query timeout threshold

Time limit in seconds that the database can execute a SQL statement before timing out.

RAM residence policy

Ram residence policy (always, manual, inUse).

Replication agent running

1 if running; 0 if not running.

Replication policy

Replication policy (always, manual, norestart).

Row-level or data store-level locking

Specifies whether the connection uses row-level locking (value = 0) or data store-level locking (value =1).

SQL statement pass through to Oracle mode

Specifies if SQL statements are passed through to Oracle, or executed locally in TimesTen, or both.

Sets the maximum message wait time

Sets the maximum message wait time.

Size in MB of the permanent partition of the data store

Size in megabytes of the permanent partition of the database.

Size in MB of the temporary partition of the data store

Size in megabytes of the temporary partition of the database.

Specifies that disk space should be preallocated when created

Specifies that disk space for the database should be preallocated when creating the database.

Specifies that the data store is not saved to disk

Specifies that database is not saved to disk.

Terminate connect if recovery encounters defective log record

Determines whether the first connection to the database should proceed if TimesTen recovery encounters a defective log record. If 1, TimesTen continues after log is truncated.

The collating sequence to use for linguistic comparisons

Collating sequence to use for linguistic comparisons. Default is binary.

The default length semantics configuration

Default length semantics configuration. Default is byte.

The directory where transaction log files are stored

The directory where transaction log files are stored.

The number of log buffer strands

Number of log buffer strands.

The number of threads used to rebuild indexes during recovery

Number of threads used to rebuild indexes during recovery.

The size of the internal log buffer in MB

Size of the internal log buffer in megabytes.

The transaction log file size in MB

Transaction log file size in megabytes.

The type mode for the data store

Type mode for database. If 0, Oracle type mode. If 1, TimesTen type mode.

Threshold for warning when permanent partition low in memory

Threshold at which TimesTen returns a warning and throws an SNMP trap when the permanent partition of the database is low in memory.

Threshold for warning when temporary partition low in memory

Threshold at which TimesTen returns a warning and throws an SNMP trap when the temporary partition of the database is low in memory.

Time PL/SQL procedure can run before being terminated

Number of seconds a PL/SQL procedure runs before being automatically terminated.

Time of first connection to data store

Time of first connection to the database.

TimesTen or Oracle binding for dup occurrences of parameter

Determines whether applications use TimesTen or Oracle parameter binding for duplicate occurrences of a parameter in a SQL statement. If 0, Oracle-style binding.

What type of logging should be performed for the data store

Type of logging used for the database. Only logging to disk is supported (value = 1).

Whether PL/SQL compiler generates cross-reference information

Determines if PL/SQL compiler should generate cross-reference information.

Whether error returned if query times out before executing

Indicates whether TimesTen should write a warning to the support log and throw an SNMP trap when execution time of a SQL statement exceeds the specified value. If 0, TimesTen does not return a warning.

Whether real memory should be locked during data store load

Specifies whether connections to a shared database should lock real memory during database loading.

Whether to enable installation of TAF FAN callbacks

Specifies whether to enable or disable installation of Transparent Application Failover (TAF) and Fast Application Failover (FAB) callbacks when using Oracle Real Application Clusters (Oracle RAC) with TimesTen Cache.

Whether unneeded transaction log files deleted during checkpoint

If 1, transaction log files are deleted during a checkpoint operation.


Instance information

Table 6-4 shows information about your TimesTen instance.

Table 6-4 Instance Information

Name Description

Daemon port number

Daemon port number.

Instance name

TimesTen instance name.

Platform type

Platform type. For example, Linux/86_32.

TimesTen server PID

TimesTen server process ID.

TimesTen server port number

Server port number.

TimesTen server running

1 if running, 0 if not running.

TimesTen version number

Five-digit release number.


For more information on your TimesTen instance, see "ttStatus" in the Oracle TimesTen In-Memory Database Reference.

Performance data

Table 6-5 shows performance information.

Table 6-5 Performance Data

Metric Description

CACHE - Autorefresh cycles completed successfully on TimesTen

Number of autorefresh cycles completed successfully on TimesTen.

CACHE - Bytes loaded from Oracle DB due to dyn load miss-local

Total number of bytes loaded from the Oracle database for servicing dynamic load misses for dynamic local cache groups.

CACHE - Bytes loaded from Oracle DB due to dynamic load misses

Total number of bytes loaded from the Oracle database for servicing dynamic load misses.

CACHE - Bytes sent to Oracle DB for SWT cache groups operations

Number of bytes sent to the Oracle database during SWT cache group operations.

CACHE - Data loads from Oracle DB servicing dynamic load misses

Number of data loads from the Oracle database when servicing dynamic load misses for dynamic local cache groups.

CACHE - Data requests due to dynamic load on remote grid member

Number of requests for data received by this grid member from another grid member (as a result of a dynamic load on the remote grid member).

CACHE - Data requests received where data not present

Number of requests for data received by this grid member when the data requested was not found in this member.

CACHE - Data requests received where locked by transaction

Number of requests for data received by this grid member when the data requested was locked by a transaction on this member.

CACHE - Data requests received where the data requested is dirty

Number of requests for data received by this grid member when the data requested is dirty (and must first be propagated to the Oracle database).

CACHE - Delete batches sent to Oracle DB in SQL mode

Number of delete batches sent to the Oracle database in SQL mode (CacheAWTMethod = 0).

CACHE - Dynamic loads where not local but remote load ok

Dynamic loads that do not find data in the local grid member and successfully load the required data from another grid member.

CACHE - Full refreshes triggered during autorefresh operations

Number of full refreshes triggered during autorefresh operations.

CACHE - Global dynamic cachegroup cache hits

Global dynamic cache group hits: Dynamic loads that find the data in the local grid member without requiring the data to be loaded from the Oracle database or another grid member.

CACHE - Global dynamic cachegroup cache misses

Global dynamic cache group misses: Dynamic loads that do not find data initially in the local grid member (either need to go to the Oracle database or another grid member).

CACHE - Insert batches sent to Oracle DB in SQL mode

Number of insert batches sent to the Oracle database in SQL mode (CacheAWTMethod = 0).

CACHE - Local dynamic cachegroup cache hits

Local dynamic cache group hits: Number of dynamic loads that find the requested data in the database.

CACHE - Local dynamic cachegroup misses

Local dynamic cache group misses: Number of dynamic loads that do not find the requested data in the database and need to load the data from the Oracle database.

CACHE - Number of AWT transactions committed on Oracle DB

Number of AWT transactions committed on the Oracle database.

CACHE - Number of PL/SQL block batches sent to Oracle DB

Number of PL/SQL block batches sent to the Oracle database. (CacheAWTMethod = 1).

CACHE - Number of autorefresh cycles that failed due to errors

Number of autorefresh cycles that failed because of errors.

CACHE - Number of batches sent to Oracle DB in SQL mode

Number of batches sent to the Oracle database in SQL mode (CacheAWTMethod = 0).

CACHE - Number of bytes flushed to Oracle DB

Number of bytes flushed to the Oracle database.

CACHE - Number of bytes sent to Oracle DB in PL/SQL mode

Number of bytes sent to the Oracle database in PL/SQL mode (CacheAWTMethod = 1).

CACHE - Number of bytes sent to Oracle DB in SQL mode

Number of bytes sent to the Oracle database in SQL mode (CacheAWTMethod = 0).

CACHE - Number of calls made to Oracle DB for AWT

Number of calls made to the Oracle database for AWT.

CACHE - Number of flush cache group executes

Number of flush cache group executions.

CACHE - Number of rollbacks on Oracle DB because of errors

Number of rollbacks on Oracle database because of errors.

CACHE - Number of rows deleted on Oracle DB in PL/SQL mode

Number of rows deleted from Oracle database in PL/SQL mode (CacheAWTMethod = 1).

CACHE - Number of rows deleted on Oracle DB in SQL mode

Number of rows deleted from the Oracle database in SQL mode (CacheAWTMethod = 0).

CACHE - Number of rows flushed to Oracle DB

Number of rows flushed to the Oracle database.

CACHE - Number of rows in SWT cache groups deleted on Oracle DB

Number of rows in SWT cache groups deleted from Oracle database.

CACHE - Number of rows in SWT cache groups inserted on Oracle DB

Number of rows in SWT cache groups inserted into Oracle database.

CACHE - Number of rows in SWT cache groups updated on Oracle DB

Number of rows in SWT cache groups updated on Oracle database.

CACHE - Number of rows inserted on Oracle DB in PL/SQL mode

Number of rows inserted into Oracle database in PL/SQL mode (CacheAWTMethod = 1).

CACHE - Number of rows updated on Oracle DB in PL/SQL mode

Number of rows updated on Oracle database in PL/SQL mode (CacheAWTMethod = 1).

CACHE - Rows deleted in TimesTen by autorefresh from Oracle DB

Number of rows deleted from TimesTen during autorefresh from the Oracle database.

CACHE - Rows inserted in TimesTen by autorefresh from Oracle DB

Number of rows inserted into TimesTen during autorefresh from the Oracle database.

CACHE - Rows inserted on Oracle DB in SQL mode

Number of rows inserted into Oracle database in SQL mode (CacheAWTMethod = 0).

CACHE - Rows updated in TimesTen by autorefresh from Oracle DB

Number of rows updated in TimesTen during autorefresh from the Oracle database.

CACHE - Rows updated on Oracle DB in SQL mode

Number of rows updated on Oracle database in SQL mode (CacheAWTMethod = 0).

CACHE - Times AWT transactions re-tried in case of an error

Number of times AWT transactions are re-tried on Oracle database.

CACHE - Times dynamic load miss load from Oracle DB

Number of times a dynamic load miss had to load the requested data from the Oracle database.

CACHE - TimesTen transactions propagated to Oracle DB

Number of TimesTen transactions propagated to the Oracle database.

CACHE - Update batches sent to Oracle DB in SQL mode

Number of updated batches sent to the Oracle database in SQL mode (CacheAWTMethod = 0).

CKPT - Bytes written during last checkpoint

Number of bytes written during last checkpoint.

CKPT - End time of last checkpoint begun

End time of last checkpoint begun.

CKPT - Number of bytes of checkpoint files written

Number of bytes written for checkpointing.

CKPT - Number of checkpoint bytes written during DB recovery

Number of bytes written for checkpointing during database recovery.

CKPT - Number of checkpoint writes

Number of checkpoint writes.

CKPT - Number of checkpoints completed

Number of checkpoints completed.

CKPT - Number of fuzzy checkpoints completed

Number of fuzzy checkpoints completed.

CKPT - Start time of last checkpoint begun

Start time of last checkpoint begun.

CKPT - Status of last checkpoint begun

Status of last checkpoint begun. For instance, completed.

CKPT - Type of last checkpoint begun

Type of last checkpoint begun. For example, fuzzy.

CKPT - Whether last checkpoint begun had an error

Whether last checkpoint begun had an error.

CONNECTIONS - DB connects exceeding configured number of conns

Cumulative number of database connection thresholds exceeded.

CONNECTIONS - Number of client-server connections established

Cumulative number of client/server connections established.

CONNECTIONS - Number of database connects established

Cumulative number of database connections established.

CONNECTIONS - Number of database disconnects

Cumulative number of database disconnections.

CONNECTIONS - Number of direct linked DB conns established

Cumulative number of direct-linked database connections established.

CONNECTIONS - Number of first database connections established

Number of first database connections established.

CS - Number of ALTER statements executed by server

Number of ALTER statements executed by server.

CS - Number of CREATE statements executed by server

Number of CREATE statements executed by server.

CS - Number of DELETE statements executed by server

Number of DELETE statements executed by server.

CS - Number of DROP statements executed by server

Number of DROP statements executed by server.

CS - Number of INSERT statements executed by server

Number of INSERT statements executed by server.

CS - Number of MERGE statements executed by server

Number of MERGE statements executed by server.

CS - Number of SELECT statements executed by server

Number of SELECT statements executed by server.

CS - Number of UPDATE statements executed by server

Number of UPDATE statements executed by server.

CS - Number of client/server bytes received by server

Number of client/server bytes received by server.

CS - Number of client/server bytes transmitted by server

Number of client/server bytes transmitted by server.

CS - Number of client/server disconnects

Number of client/server disconnects.

CS - Number of client/server round trips

Number of client/server roundtrips.

CS - Number of table rows deleted by server

Number of table rows deleted by server.

CS - Number of table rows inserted by server

Number of table rows inserted by server.

CS - Number of table rows updated by server

Number of table rows updated by server.

CS - Number of transaction rollbacks by server

Number of transaction rollbacks by server.

CS - Number of transactions committed by server

Number of transactions committed by server.

DB - Inserts into hash indexes during DB recovery index rebuild

Number of rows inserted into hash indexes during index rebuild phase of database recovery.

DB - Inserts into range indexes during DB recovery index rebuild

Number of rows inserted into range indexes during index rebuild phase of database recovery

DB - Number of LRU aging commits done since db loaded

Number of LRU aging commits since the data store was loaded into memory.

DB - Number of LRU aging cycles completed since db loaded

Number of LRU aging cycles completed since the data store was loaded into memory.

DB - Number of deletes from range indexes

Number of rows deleted from range indexes.

DB - Number of full table scans

Number of full table scans.

DB - Number of hash indexes scanned

Number of hash indexes scanned.

DB - Number of hash indexes scanned during replication ops

Number of hash indexes scanned during replication operations (such as insert, update, and delete operations on tables).

DB - Number of indexes rebuilt

Number of indexes rebuilt.

DB - Number of inserts into range indexes

Number of rows inserted into range indexes.

DB - Number of merge joins done

Number of merge joins done.

DB - Number of nested loop joins done

Number of nested loop joins done.

DB - Number of range indexes scanned

Number of temporary indexes scanned.

DB - Number of rows deleted during LRU aging since db loaded

Number of rows deleted during LRU aging since the data store was loaded into memory.

DB - Number of rows deleted from hash indexes

Number of rows deleted from hash indexes.

DB - Number of rows fetched from hash indexes

Number of rows fetched from hash indexes.

DB - Number of rows fetched from temporary indexes

Number of rows fetched from temporary indexes.

DB - Number of rows inserted into hash indexes

Number of rows inserted into hash indexes.

DB - Number of sorts done

Number of sorts done.

DB - Number of table rows deleted

Number of table rows deleted.

DB - Number of table rows inserted

Number of table rows inserted.

DB - Number of table rows read

Number of table rows read.

DB - Number of table rows updated

Number of table rows updated.

DB - Number of temporary indexes created

Number of temporary indexes created.

DB - Number of temporary indexes scanned

Number of range indexes scanned.

DB - Number of time-based aging commits done since the db loaded

Number of time-based aging commits since the data store was loaded into memory.

DB - Number of tuples fetched from range indexes

Number of rows fetched from range indexes.

DB - Number of updates on range indexes

Number of rows updated on range indexes.

DB - Number rows deleted during time-based aging since db loaded

Number of rows deleted during time-based aging since the data store was loaded into memory.

DB - Number temp indexes scanned during replication operations

Number of range indexes scanned during replication operations (such as insert, update, and delete operations on tables).

DB - Number time-based aging cycles completed since db loaded

Number of time-based aging cycles completed since the data store was loaded into memory.

DB - Number times LRU aging high threshold rchd since db loaded

Number of times LRU aging high threshold has been reached since the data store was loaded into memory.

DB - Number times LRU aging low threshold rchd since db loaded

Number of times LRU aging low threshold has been reached since the data store was loaded into memory.

DB - Range indexes scanned during replication operations

Number of temporary indexes scanned during replication operations.

DB - Rows fetched from hash indexes during replication ops

Number of rows fetched from hash indexes during replication operations.

DB - Rows fetched from range indexes during replication ops

Number of rows fetched from range indexes during replication operations.

DB - Rows fetched from temp indexes during replication ops

Number of rows fetched from temporary indexes during replication operations.

DB - Rows not deleted using LRU aging because of lock contention

Number of rows that were not deleted using LRU aging because of lock contention since the data store was loaded into memory.

DB - Rows not deleted using time-based aging - lock contention

Number of rows that were not deleted using time-based aging because of lock contention since the data store was loaded into memory.

GRID - Number of detach operations

Number of detach operations.

GRID - Number of grid members that have attached so far

Number of attach operations.

LOCK - Number of deadlocks

Number of deadlocks.

LOCK - Number of lock requests denied due to timeouts

Number of lock requests denied due to timeouts.

LOCK - Number of locks acquired for DML activity

Number of locks acquired for DML activity.

LOCK - Number of locks acquired for table scans

Number of locks acquired for table scans.

LOCK - Number of locks granted immediately

Number of locks granted immediately.

LOCK - Number of locks granted that required waiting

Number of locks granted that required waiting.

LOG - Bytes read from log for commits

Number of bytes read from the log for commit processing.

LOG - Earliest log file currently

Earliest log file that currently exists in the database.

LOG - File system reads for commits

Number of file system reads from the log for commit processing.

LOG - Last log file number

Number of last log file.

LOG - Most recent log file present

Most recent log file present.

LOG - Number of bytes inserted into the log buffer

Number of bytes inserted into the log buffer.

LOG - Number of bytes of log read during DB recovery

Number of log bytes read during database recovery.

LOG - Number of file system reads

Number of file system reads.

LOG - Number of file system writes

Number of file system writes.

LOG - Number of log files generated so far

Number of log files generated so far.

LOG - Number of log records inserted into the log buffer

Number of log records inserted into the log buffer.

LOG - Number of times the log is synched to disk

Number of times the log has been synchronized to disk.

LOG - Total waits for inserts

Number of times a thread was delayed while trying to insert a log record into the log buffer because the log buffer was full. If this value is increasing, it generally indicates that the log buffer is too small.

MEMORY - Highest amount of permanent partition in use - MB

Highest amount of permanent data partition memory in use since the first connection to the database.

MEMORY - Highest amount of temporary partition in use - MB

Highest amount of temporary data partition memory in use since the first connection to the database.

MEMORY - MB of permanent space in use

Size of permanent partition currently in use.

MEMORY - MB of temporary space in use

Size of temporary partition currently in use.

MEMORY - Percent of permanent space in use

Percent of the permanent partition space currently being used.

MEMORY - Percent of temporary space in use

Percent of the temporary partition space currently being used.

PLSQL - Number of times PL/SQL object's handle found in memory

Number of times a PL/SQL object's handle was found in memory.

PLSQL - Number of times a PIN was requested for PL/SQL objects

Number of times a PIN was requested for PL/SQL objects.

PLSQL - Number of times lock requested for a PL/SQL object

Number of times a lock was requested for a PL/SQL object.

PLSQL - PINs of objs not 1st performed since obj handle created

Any PIN of an object that is not the first PIN performed since the object handle was created and which requires loading the object from the database.

PLSQL - Ratio of ttplsql_GetHits to ttplsql_Gets

Ratio of GetHits to Gets.

PLSQL - Ratio of ttplsql_PinHits to ttplsql_Pins

Ratio of PinHits to Pins.

PLSQL - Times all metadata pieces of library obj found in mem

Number of times all of the metadata pieces of the library object were found in memory.

PLSQL - Times objs marked invalid because dependent obj modified

Total number of times objects in the namespace were marked invalid because a dependent object was modified.

PLSQL - Total heap (MB) allocated to PL/SQL on this DB conn

Total amount of heap memory in megabytes allocated to PL/SQL for the database connection.

PLSQL - Total number of times a deferred cleanup occurred

Number of times a deferred cleanup occurred.

REP - Last log file number held by replication

Number of last log file held by replication.

REP - Number of xacts replicated from this database

Number of replicated transactions generated on the local database that are being replicated to at least one peer database.

STMT - Number of ALTER statements executed

Number of ALTER statements executed.

STMT - Number of CREATE statements executed

Number of CREATE statements executed.

STMT - Number of DELETE statements executed

Number of DELETE statements executed.

STMT - Number of DROP statements executed

Number of DROP statements executed.

STMT - Number of INSERT statements executed

Number of INSERT statements executed.

STMT - Number of MERGE statements executed

Number of MERGE statements executed.

STMT - Number of SELECT statements executed

Number of SELECT statements executed.

STMT - Number of UPDATE statements executed

Number of UPDATE statements executed.

STMT - Number of automatic statement reprepares

Number of automatic statement reprepares.

STMT - Number of cmd cache misses during statement prepare

Number of command cache misses during statement prepare.

STMT - Number of statement prepares

Number of statement prepares.

STMT - Number of statement reprepares (forced or automatic)

Number of statement reprepares including forced and automatic.

STMT - Total number of SQL statements executed

Number of SQL statements executed.

WORKLOAD - 10th most commonly executed SQL statement

Tenth most commonly executed SQL statement.

WORKLOAD - 2nd most commonly executed SQL statement

Second most commonly executed SQL statement.

WORKLOAD - 2nd most commonly prepared SQL statement

Second most commonly prepared SQL statement.

WORKLOAD - 2nd most commonly reprepared SQL statement

Second most commonly reprepared SQL statement.

WORKLOAD - 3rd most commonly executed SQL statement

Third most commonly executed SQL statement.

WORKLOAD - 3rd most commonly prepared SQL statement

Third most commonly prepared SQL statement.

WORKLOAD - 3rd most commonly reprepared SQL statement

Third most commonly reprepared SQL statement.

WORKLOAD - 4th most commonly executed SQL statement

Fourth most commonly executed SQL statement.

WORKLOAD - 4th most commonly prepared SQL statement

Fourth most commonly prepared SQL statement.

WORKLOAD - 4th most commonly reprepared SQL statement

Fourth most commonly reprepared SQL statement.

WORKLOAD - 5th most commonly executed SQL statement

Fifth most commonly executed SQL statement.

WORKLOAD - 5th most commonly prepared SQL statement

Fifth most commonly prepared SQL statement.

WORKLOAD - 5th most commonly reprepared SQL statement

Fifth most commonly reprepared SQL statement.

WORKLOAD - 6th most commonly executed SQL statement

Sixth most commonly executed SQL statement.

WORKLOAD - 7th most commonly executed SQL statement

Seventh most commonly executed SQL statement.

WORKLOAD - 8th most commonly executed SQL statement

Eighth most commonly executed SQL statement.

WORKLOAD - 9th most commonly executed SQL statement

Ninth most commonly executed SQL statement.

WORKLOAD - Cache hits

Number of hits inside cache.

WORKLOAD - Client/Server connections

The number of current active client/server connections on the TimesTen database.

WORKLOAD - Communication with Oracle DB for dynamic load

Number of executes from Oracle DB using dynamic load.

WORKLOAD - Direct linked connections

The number of current direct-linked connections on the database.

WORKLOAD - Fetches from Oracle DB using dynamic load

Number of fetches from Oracle DB using dynamic load.

WORKLOAD - Most commonly executed SQL statement

Most commonly executed SQL statement.

WORKLOAD - Most commonly prepared SQL statement

Most commonly prepared SQL statement.

WORKLOAD - Most commonly reprepared SQL statement

Most commonly reprepared SQL statement.

WORKLOAD - Number of commands prepared

Number of commands prepared (compiled).

WORKLOAD - Number of commands reprepared

Number of commands reprepared.

WORKLOAD - Number of cursor opens

Number of cursor opens.

WORKLOAD - Number of cursors closed

Number of cursor closed.

WORKLOAD - Passthrough count

Number of passthrough operations executed.

WORKLOAD - System connections

The sum of the current active subdaemon, replication agent, and cache connect agent connections.

WORKLOAD - Total number of connections

Sum of all current active connections on the TimesTen database.

XACT - Number of XLA initiated transaction commits

Number of XLA initiated transaction commits.

XACT - Number of durable replicated transaction commits

Number of durable replicated transaction commits.

XACT - Number of durable transaction commits

Number of durable transaction commits.

XACT - Number of nondurable replicated transaction commits

Number of nondurable replicated transaction commits.

XACT - Number of nondurable transaction commits

Number of nondurable transaction commits.

XACT - Number of replication initiated transaction commits

Number of replication initiated transaction commits.

XACT - Number of transaction rollbacks

Number of transaction rollbacks.

XACT - Number of transactions committed

Number of durable and non-durable transaction committed.


Performance rates

Performance rates are expressed as a rate (For example, X times per minute). These rates are considered instantaneous rates because the value is the rate in the past minute or the per-minute rate (if you have changed the most recent collection interval to a value other than one minute).

Table 6-6 shows each metric and provides a description for the metric.

Table 6-6 Performance Rates

Metric Description

CACHE - Rows per batch in PLSQL mode

Rows per batch in PL/SQL mode.

CACHE - Rows per batch in SQL mode

Rows per batch in SQL mode.

CACHE - Total AWT MB per sec

Megabytes per second sent to the Oracle database.

CACHE - Transactions committed on Oracle DB per sec

Transactions committed on the Oracle database per second.

CACHE - Transactions propagated to Oracle DB per sec

Transactions propagated to the Oracle database per second.

CS - Client/server bytes received by server per sec

Number of client/server bytes received by server per second.

CS - Client/server bytes transmitted by server per sec

Number of client/server bytes transmitted by server per second.

CS - Client/server round trips per sec

Number of client/server roundtrips per second.

CS - SELECT statements executed by server per sec

Number of SELECT statements executed by server per second.

CS - Table rows deleted by server per sec

Number of table rows deleted by server per second.

CS - Table rows inserted by server per sec

Number of table rows inserted by server per second.

CS - Table rows updated by server per sec

Number of table rows updated by server per second.

CS - Transaction rollbacks by server per sec

Number of transaction rollbacks by server per second.

CS - Transactions committed by server per sec

Number of transactions committed by server per second.

DB - Table rows deleted per minute

Table rows deleted per minute.

DB - Table rows inserted per minute

Table rows inserted per minute.

DB - Table rows read per minute

Table rows read per minute.

DB - Table rows updated per minute

Table rows updated per minute.

GRID - Cache Grid attaches per minute

Cache grid attaches per minute.

GRID - Cache Grid detaches per minute

Cache grid detaches per minute.

GRID - Cache Grid global hit percent

Cache grid global hit percent (percent is found in local grid member).

GRID - Cache Grid global hits per sec

Cache grid global hits per second.

GRID - Cache Grid global misses per sec

Cache grid global misses per second.

GRID - Cache Grid local hits per sec

Cache grid local hits per second.

GRID - Cache Grid local misses per sec

Cache grid local misses per second.

GRID - Cache Grid misses filled from Oracle DB per sec

Cache grid misses filled from the Oracle database per second.

LOCK - Deadlocks per minute

Number of deadlocks per minute.

LOCK - Immediate lock grants per minute

Number of non-blocking locks acquired per minute.

LOCK - Lock grants after wait per minute

Number of blocking locks acquired per minute.

LOCK - Lock timeouts per minute

Number of lock timeouts per minute.

LOCK - Percent locks granted immediately

Percent of locks granted immediately versus having to wait.

LOG - Log buffer MB inserted per sec

Number of megabytes inserted into the log buffer per second.

LOG - Log buffer waits per minute

Number of times per minute a thread had to wait because the log buffer was full.

LOG - Log bytes to disk per minute in MB

Number of megabytes of log that was written to disk per minute.

LOG - Log flushes to file system per minute

Number of times per minute the log buffer was written to the file system.

LOG - Log reads from file system per minute

Number of times per minute a log read could not be satisfied from the in memory buffer.

Prepares per minute to executes per minute ratio

Ratio of the prepares per minutes to executes per minute.

REP - Transactions replicated per minute

Number of transactions replicated to a peer per minute.

STMT - DELETE statements executed per sec

Number of DELETE statements executed per second.

STMT - INSERT statements executed per sec

Number of INSERT statements executed per second.

STMT - MERGE statements executed per sec

Number of MERGE statements executed per second.

STMT - SELECT statements executed per sec

Number of SELECT statements executed per second.

STMT - Total number of statements executed per sec

Total number of statements executed per second.

STMT - UPDATE statements executed per sec

Number of UPDATE statements executed per second.

WORKLOAD - Connects per minute

Number of connections to the database per minute.

WORKLOAD - Disconnects per minute

Number of disconnections to the database per minute.

WORKLOAD - Number of commands prepared per minute

Number of SQL commands prepared (compiled) per minute.

WORKLOAD - Number of commands reprepared per minute

Number of SQL commands reprepared (recompiled) per minute.

WORKLOAD - Number of queries per second

Number of queries per second.

XACT - Transaction rollbacks per sec

Number of transactions rolled back per second.

XACT - Transactions committed per second

Number of transactions committed per second.

XACT - Transactions durably committed per second

Number of durable transactions committed per minute.


Replication peers

Table 6-7 shows replication peers metrics and provides a description of the metric.

Table 6-7 Replication Peers

Metric Description

Replication Protocol

Protocol used by replication to communicate between peers.

Replication State

Current replication state of the replication peer in relation to the queried database.

Replication host name

Name of the machine that hosts replication.

Replication peer name

If replication type is DNS, name of the database to be queried. If replication type is PEERS, name of the database that is a replication peer to this database.

Replication port number

TCP/IP port used by the replication agent to listen for connections from the transmitter threads of remote replication agents. The default is 0 indicating that this port has been assigned automatically to the replication agent, rather than being specified as part of a replication scheme.

Type

Type.


Replication status

Table 6-8 shows replication status information.

Table 6-8 Replication Status

Name Description

Replication peer name

Replication peer name.

Replication thread type

Replication thread type. Valid values are Transmitter or Receiver.

Start or restart count

Start or restart count.

Transactions sent or received

Transactions sent or received.


Replication subscribers

Table 6-9 shows replication subscriber information.

Table 6-9 Replication Subscribers

Name Description

Average latency time (in seconds)

The average latency time in seconds between when the master sends a message and when it receives the final acknowledgement from the subscriber.

Last message received

Time in seconds since this subscriber received the last message from the master.

Last message sent

Time in seconds since the master sent the last message to the subscriber. This includes the "heartbeat" messages sent between the databases.

Replication Protocol

Protocol used by replication to communicate between master and subscribers.

Replication State

Current replication state of the subscriber peer in relation to the queried database.

Replication host name

Name of the machine that hosts the subscriber.

Replication peer name

Name of the subscriber database.

Replication port number

TCP/IP port used by the subscriber agent to receive updates from the master. A value of 0 indicates that replication has automatically assigned the port.

Replication track

Replication track.

Txn log files held by the master database for a subscriber

Number of transaction log files the master database is retaining for a subscriber.


Response

Table 6-10 shows response information.

Table 6-10 Response

Name Description

Response time (sec)

The time taken for the plug-in to query the TimesTen SYS.MONITOR table.

Status

Valid values are Up or Down.


SQL command cache

Table 6-11 describes information in the SQL command cache.

Table 6-11 SQL Command Cache

Name Description

Executions which took place on this command

A counter for the number of executions that took place on this command since it was brought into the command cache.

Indicates if command can be garbage collected

Indicates whether this command can be garbage collected by the subdaemon. If 0, it is non-freeable. If 1, it is freeable.

Reprepares or invalidations of this command

A counter for the number of reprepares or invalidations of this command.

SQL for the current command

The full SQL text for the current command.

Space (bytes) allocated for this command in the command cache

The total space in bytes allocated for this command in the command cache.

Unique ID of a private connection

Unique ID of a private connection.

User prepares which result in a hit on the command cache

A counter for the number of user prepares that result in a hit in the command cache.

User who created this command

The identifier of the user who created this command.


Transaction log holds

Table 6-12 shows transaction log holds information.

Table 6-12 Transaction Log Holds

Name Description

Object for which the hold was created

The type specific object for which the hold was created.

Transaction log file number of the hold

The transaction log file number of the hold.

Transaction log file offset of the hold

The transaction log file offset of the hold.

Type of hold

The type of hold.