14 Viewing Metrics

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

Topics include:

Navigating to the TimesTen database metrics page

Ensure that you are on the TimesTen database target page. For more information on navigating to the TimesTen database target page, see "Navigating to the TimesTen target page".

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

    Figure 14-1 TimesTen database All Metrics

    Description of Figure 14-1 follows
    Description of "Figure 14-1 TimesTen database 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. For more information on TimesTen database metrics, see "Viewing TimesTen database metrics".

Navigating to the TimesTen instance metrics page

Ensure that you are on the TimesTen instance target page. For more information on navigating to the TimesTen instance target page, see "Navigating to the TimesTen target page".

  1. From the or TimesTen Instance Home menu, select Monitoring, then select All Metrics.

    Figure 14-2 TimesTen Instance All Metrics

    Description of Figure 14-2 follows
    Description of "Figure 14-2 TimesTen Instance 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. For more information on TimesTen instance metrics, see "Viewing TimesTen instance metrics".

Viewing TimesTen database metrics

There are twelve groups of TimesTen database metrics:

Figure 14-3 Groups of metrics

Description of Figure 14-3 follows
Description of "Figure 14-3 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 14-1 lists each metric and describes the metrics.

Table 14-1 Checkpoint History

Metric Description

Blocks currently in use out of total blocks

The number of blocks that are currently in use.

Bytes occupied by all blocks

The number of bytes occupied by all blocks.

Bytes occupied by blocks in use

The number of bytes occupied by the blocks that are in use.

Bytes occupied by dirty blocks

The number of bytes occupied by dirty blocks.

Bytes written in MB

Bytes written in megabytes.

Bytes written per sec

Bytes written per second.

Checkpoint sequence number

Checkpoint sequence number.

Dirty blocks written by this checkpoint

The number of dirty blocks written by this checkpoint.

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.

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 source of the checkpoint request

The source of the checkpoint request.

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.

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 database error number for the failure

TimesTen error number that indicates the reason for the failure.

Total bytes written by this checkpoint

The total number of bytes written by this checkpoint.


Checkpoint and transaction log file system usage

Table 14-2 lists each metric and describes the metrics.

Table 14-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

Transaction log file system.

Transaction log file system mount point

Transaction log file system mount point.

Transaction log file system size (MB)

Transaction log file system size in megabytes.

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 14-3 shows information about your database.

Table 14-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.

Binding style for duplicate SQL parameters

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

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.

Delete unneeded transaction log files during checkpoint

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

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 on Oracle database 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 database

Identifies the character set used by the database.

Identifies the physical database

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 PL/SQL shared memory segment that is loaded into each process that uses the TimesTen "direct" drivers.

Lock wait interval

Lock wait interval for connection.

Log buffer strands

Number of log buffer strands.

Max rate data written to disk during checkpoint

Maximum rate data that TimesTen writes 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, TimesTen uses buffered writes to write data to transaction log files.

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 database instance from which data is to be loaded into a TimesTen database.

PL/SQL memory segment size

Size in megabytes of the PL/SQL 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 database-level locking

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

SQL statement pass through to Oracle database 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 region of the database

Size in megabytes of the permanent region of the database.

Size in MB of the temporary region of the database

Size in megabytes of the temporary region 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 database 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 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 database

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

Thread count to apply changes on active master database

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

Thread count to rebuild indexes during recovery

Number of threads used to rebuild indexes during recovery.

Threshold for warning when permanent region low in memory

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

Threshold for warning when temporary region low in memory

Threshold at which TimesTen returns a warning and throws an SNMP trap when the temporary region 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 database

Time of first connection to the database.

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.

What type of logging should be performed for the database

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 database 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.


Instance information

Table 14-4 shows information about your TimesTen instance.

Table 14-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 process identifier

TimesTen server process identifier.

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.

Parallel AWT Rates

Table 14-5 shows information about your Parallel AWT Rates.

Table 14-5 Parallel AWT Rates

Name Description

Bytes sent in PL/SQL mode MB per sec

The number of megabytes sent in PL/SQL mode to the Oracle database per second.

Bytes sent in SQL mode MB per sec

The number of megabytes sent in SQL mode to the Oracle database per second.

Oracle database Rollbacks Timeout per sec

The timeout per second for rollbacks on the Oracle database.

Total AWT MB per sec

The number of megabytes sent for AWT to the Oracle database per second.

Total number of Oracle database commits per sec

The total number of Oracle database commits per second.

Total number of batches sent fully per sec

The total number of batches sent fully per second.

Total number of batches sent partially per sec

The total number of batches sent partially per second.

Total number of transactions per sec

The total number of transactions sent to the Oracle database per second.

Transaction master restart per sec

The number of transaction master restarts per second.

Transactions Generated on TimesTen database per sec

The number of transactions generated on the TimesTen database per second.

Transactions propagated to Oracle database per sec

The number of transactions propagated to the Oracle database per second.


Parallel AWT Tracks

Table 14-6 shows information about your Parallel AWT Tracks.

Table 14-6 Parallel AWT Tracks

Name Description

Batches Begin Waited

The number of AWT batches that had to wait on a begin dependency before being transmitted between the TimesTen database and the Oracle database.

Batches Begin Waits Count

The number of times the AWT batch had to check on a begin dependency to be satisfied before being transmitted between the TimesTen database and the Oracle database.

Commit Waited Count

The number of times the AWT batch had to check on a commit dependency to be satisfied before the AWT batch is committed on the Oracle database.

Full Batches

The number of full AWT batches transmitted between the TimesTen database and the Oracle database.

Oracle database Rollbacks

The number of rollbacks performed on the Oracle database.

PL/SQL Mode Batches

The number of AWT batches transmitted between the TimesTen database and the Oracle database in PL/SQL mode.

Partial Batches

The number of partial AWT batches transmitted between the TimesTen database and the Oracle database.

SQL Mode Batches

The number of AWT batches transmitted between the TimesTen database and the Oracle database in SQL mode.

Subscriber

The name of the subscriber database.

Track

The track number.

Transaction processed

The total number of transactions processed.

Transactions processed per sec

The number of transactions processed per second.


Performance data

Table 14-7 shows performance information.

Table 14-7 Performance Data

Metric Description

Cache - AWT transactions committed on Oracle database

Number of AWT transactions committed on the Oracle database.

Cache - AWT transactions re-tries in case of an error

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

Cache - Autorefresh cycles completed successfully

Number of autorefresh cycles completed successfully on TimesTen.

Cache - Autorefresh cycles that failed due to errors

Number of autorefresh cycles that failed because of errors.

Cache - Batches sent to Oracle database in SQL mode

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

Cache - Bytes flushed to Oracle database

Number of bytes flushed to the Oracle database.

Cache - Bytes loaded due to dynamic 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 due to dynamic load misses

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

Cache - Bytes sent to Oracle database for SWT operations

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

Cache - Bytes sent to Oracle database in PL/SQL mode

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

Cache - Bytes sent to Oracle database in SQL mode

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

Cache - Calls made to Oracle database for AWT

Number of calls made to the Oracle database for AWT.

Cache - Data loads from Oracle database for 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 cache grid member

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

Cache - Data requests received for dirty data

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

Cache - Data requests received where data not present

Number of requests for data received by this cache 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 cache grid member when the data requested was locked by a transaction on this member.

Cache - Delete batches sent to Oracle database in SQL mode

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

Cache - Dynamic load misses from the Oracle database

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

Cache - Flush cache group executes

Number of flush cache group executions.

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 cache grid member without requiring the data to be loaded from the Oracle database or another cache grid member.

Cache - Global dynamic cachegroup cache misses

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

Cache - Insert batches sent to Oracle database 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 - PL/SQL block batches sent to Oracle database

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

Cache - Remote dynamic loads

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

Cache - Rollbacks on Oracle database because of errors

Number of rollbacks on Oracle database because of errors.

Cache - Rows deleted in the TimesTen database by autorefresh

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

Cache - Rows deleted on Oracle database in PL/SQL

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

Cache - Rows deleted on Oracle database in SQL

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

Cache - Rows flushed to Oracle database

Number of rows flushed to the Oracle database.

Cache - Rows in SWT cache groups deleted on Oracle database

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

Cache - Rows in SWT cache groups inserted on Oracle database

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

Cache - Rows in SWT cache groups updated on Oracle database

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

Cache - Rows inserted in the TimesTen database by autorefresh

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

Cache - Rows inserted on Oracle database in PL/SQL mode

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

Cache - Rows inserted on Oracle database in SQL mode

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

Cache - Rows updated in the TimesTen database by autorefresh

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

Cache - Rows updated on Oracle database in PL/SQL mode

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

Cache - Rows updated on Oracle database in SQL mode

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

Cache - Transactions propagated from TimesTen to Oracle database

Number of TimesTen transactions propagated to the Oracle database.

Cache - Update batches sent to Oracle database in SQL mode

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

Cache grid - Cache grid members that have attached so far

Number of attach operations.

Cache grid - Detach operations

Number of detach operations.

Checkpoint - Bytes written during last checkpoint

Number of bytes written during last checkpoint.

Checkpoint - Checkpoint bytes written during database recovery

Number of bytes written for checkpointing during database recovery.

Checkpoint - Checkpoint volume in bytes

Number of bytes written for checkpointing.

Checkpoint - Checkpoint writes

Number of checkpoint writes.

Checkpoint - Checkpoints completed

Number of checkpoints completed.

Checkpoint - End time of last checkpoint begun

End time of last checkpoint begun.

Checkpoint - Fuzzy checkpoints completed

Number of fuzzy checkpoints completed.

Checkpoint - Start time of last checkpoint begun

Start time of last checkpoint begun.

Checkpoint - Status of last checkpoint begun

Status of last checkpoint begun. For instance, completed.

Checkpoint - Type of last checkpoint begun

Type of last checkpoint begun. For example, fuzzy.

Checkpoint - Whether last checkpoint begun had an error

Whether last checkpoint begun had an error.

Client/Server - ALTER statements executed by server

Number of ALTER statements executed by server.

Client/Server - CREATE statements executed by server

Number of CREATE statements executed by server.

Client/Server - Bytes received by server

Number of client/server bytes received by server.

Client/Server - Bytes transmitted by server

Number of client/server bytes transmitted by server.

Client/Server - Disconnects

Number of client/server disconnects.

Client/Server - Round trips

Number of client/server round-trips.

Client/Server - DELETE statements executed by server

Number of DELETE statements executed by server.

Client/Server - DROP statements executed by server

Number of DROP statements executed by server.

Client/Server - INSERT statements executed by server

Number of INSERT statements executed by server.

Client/Server - MERGE statements executed by server

Number of MERGE statements executed by server.

Client/Server - SELECT statements executed by server

Number of SELECT statements executed by server.

Client/Server - Table rows deleted by server

Number of table rows deleted by server.

Client/Server - Table rows inserted by server

Number of table rows inserted by server.

Client/Server - Table rows updated by server

Number of table rows updated by server.

Client/Server - Transaction rollbacks by server

Number of transaction rollbacks by server.

Client/Server - Transactions committed by server

Number of transactions committed by server.

Client/Server - UPDATE statements executed by server

Number of UPDATE statements executed by server.

Connections - Client-server connections established

Cumulative number of client/server connections established.

Connections - Database connects established

Cumulative number of database connections established.

Connections - Database connects exceeding configured maximum

Cumulative number of database connection thresholds exceeded.

Connections - Database disconnects

Cumulative number of database disconnections.

Connections - Direct linked database connections established

Cumulative number of direct-linked database connections established.

Connections - First database connections established

Number of first database connections established.

DB - Deletes from range indexes

Number of rows deleted from range indexes.

DB - Full table scans

Number of full table scans.

DB - Hash index inserts during database recovery index rebuild

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

DB - Hash indexes scanned

Number of hash indexes scanned.

DB - Hash indexes scanned during replication

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

DB - Indexes rebuilt

Number of indexes rebuilt.

DB - Inserts into range indexes

Number of rows inserted into range indexes.

DB - LRU aging commits done since database loaded

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

DB - LRU aging cycles completed since database loaded

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

DB - LRU aging high threshold crossings since database loaded

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

DB - Merge joins done

Number of merge joins done.

DB - Nested loop joins done

Number of nested loop joins done.

DB - Range index inserts during database recovery index rebuild

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

DB - Range indexes scanned

Number of temporary indexes scanned.

DB - Range indexes scanned during replication

Number of temporary indexes scanned during replication operations.

DB - Rows deleted during LRU aging since database loaded

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

DB - Rows deleted during time-based aging since database loaded

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

DB - Rows deleted from hash indexes

Number of rows deleted from hash indexes.

DB - Rows fetched from hash indexes

Number of rows fetched from hash indexes.

DB - Rows fetched from hash indexes during replication

Number of rows fetched from hash indexes during replication operations.

DB - Rows fetched from range indexes during replication

Number of rows fetched from range indexes during replication operations.

DB - Rows fetched from temp indexes during replication

Number of rows fetched from temporary indexes during replication operations.

DB - Rows fetched from temporary indexes

Number of rows fetched from temporary indexes.

DB - Rows inserted into hash indexes

Number of rows inserted into hash indexes.

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 database 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 database was loaded into memory.

DB - Sorts done

Number of sorts done.

DB - Table rows deleted

Number of table rows deleted.

DB - Table rows inserted

Number of table rows inserted.

DB - Table rows read

Number of table rows read.

DB - Table rows updated

Number of table rows updated.

DB - Temporary indexes created

Number of temporary indexes created.

DB - Temporary indexes scanned

Number of range indexes scanned.

DB - Temporary indexes scanned during replication

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

DB - Time-based aging commits done since the database loaded

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

DB - Time-based aging cycles completed since database loaded

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

DB - Times LRU aging low threshold reached since database loaded

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

DB - Tuples fetched from range indexes

Number of rows fetched from range indexes.

DB - Updates on range indexes

Number of rows updated on range indexes.

Lock - Deadlocks

Number of deadlocks.

Lock - Locks acquired for DML activity

Number of locks acquired for DML activity.

Lock - Locks acquired for table scans

Number of locks acquired for table scans.

Lock - Locks granted immediately

Number of locks granted immediately.

Lock - Locks granted that required waiting

Number of locks granted that required waiting.

Lock - Requests denied due to timeouts

Number of lock requests denied due to timeouts.

Log - Bytes inserted into the log buffer

Number of bytes inserted into the log buffer.

Log - Bytes of log read during DB recovery

Number of log bytes read during database recovery.

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

Number of file system reads.

Log - File system reads for commits

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

Log - File system writes

Number of file system writes.

Log - Last log file number

Number of last log file.

Log - Log files generated so far

Number of log files generated so far.

Log - Log records inserted into the log buffer

Number of log records inserted into the log buffer.

Log - Most recent log file present

Most recent log file present.

Log - 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 region in use - MB

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

Memory - Highest amount of temporary region in use - MB

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

Memory - MB of permanent space in use

Size of permanent region currently in use.

Memory - MB of temporary space in use

Size of temporary region currently in use.

Memory - Percent of permanent space in use

Percent of the permanent region space currently being used.

Memory - Percent of temporary space in use

Percent of the temporary region space currently being used.

PL/SQL - Cache hit ratio for object handles

The cache hit ratio for PL/SQL object handles.

PL/SQL - Cache hit ratio for pin requests

The cache hit ratio for PIN requests.

PL/SQL - Lock requests for a PL/SQL object

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

PL/SQL - Object invalidations due to dependent object changes

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

PL/SQL - PINs of objs not 1st performed since creation

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.

PL/SQL - Times PL/SQL object's handle found in memory

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

PL/SQL - Times a PIN was requested for PL/SQL objects

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

PL/SQL - Times all metadata of library object found in memory

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

PL/SQL - Total heap (MB) for PL/SQL on this database connection

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

PL/SQL - Total times a deferred cleanup occurred

Number of times a deferred cleanup occurred.

Replication - Last log file number held by replication

Number of last log file held by replication.

Replication - Transactions replicated from this database

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

Statement - ALTER statements executed

Number of ALTER statements executed.

Statement - Automatic statement reprepares

Number of automatic statement reprepares.

Statement - CREATE statements executed

Number of CREATE statements executed.

Statement - Command cache misses during statement prepare

Number of command cache misses during statement prepare.

Statement - DELETE statements executed

Number of DELETE statements executed.

Statement - DROP statements executed

Number of DROP statements executed.

Statement - INSERT statements executed

Number of INSERT statements executed.

Statement - MERGE statements executed

Number of MERGE statements executed.

Statement - SELECT statements executed

Number of SELECT statements executed.

Statement - Statement prepares

Number of statement prepares.

Statement - Statement reprepares (forced or automatic)

Number of statement reprepares including forced and automatic.

Statement - Total SQL statements executed

Number of SQL statements executed.

Statement - UPDATE statements executed

Number of UPDATE statements executed.

Transaction - Durable replicated transaction commits

Number of durable replicated transaction commits.

Transaction - Durable transaction commits

Number of durable transaction commits.

Transaction - Nondurable replicated transaction commits

Number of nondurable replicated transaction commits.

Transaction - Nondurable transaction commits

Number of nondurable transaction commits.

Transaction - Replication initiated transaction commits

Number of replication initiated transaction commits.

Transaction - Transaction rollbacks

Number of transaction rollbacks.

Transaction - Transactions committed

Number of durable and non-durable transaction committed.

Transaction - XLA initiated transaction commits

Number of XLA initiated transaction commits.

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 - Commands prepared

Number of commands prepared (compiled).

Workload - Commands reprepared

Number of commands reprepared.

Workload - Communication with Oracle database for dynamic load

Number of executes from the Oracle database using dynamic load.

Workload - Cursor opens

Number of cursor opens.

Workload - Cursors closed

Number of cursor closed.

Workload - Direct linked connections

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

Workload - Fetches from Oracle database using dynamic load

Number of fetches from the Oracle database 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 - 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.


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 last minute or the per-minute rate (if you have changed the most recent collection interval to a value other than one minute).

Table 14-8 shows each metric and describes the metrics.

Table 14-8 Performance Rates

Metric Description

Cache - Rows per batch in PL/SQL mode

The number of rows sent per batch in PL/SQL mode to the Oracle database.

Cache - Rows per batch in SQL mode

The number of rows sent per batch in SQL mode to the Oracle database.

Cache - Total AWT MB per sec

The number of megabytes of AWT transactions sent per second to the Oracle database.

Cache - Transactions committed on Oracle database per sec

The number of transactions committed per second on the Oracle database.

Cache - Transactions propagated to Oracle database per sec

The number of transactions propagated per second to the Oracle database.

Cache grid - Cache grid attaches per minute

The number of cache grid attaches per minute.

Cache grid - Cache grid detaches per minute

The number of cache grid detaches per minute.

Cache grid - Cache grid global hit percent

The number of cache grid global hit percent (percent is found in local grid member).

Cache grid - Cache grid global hits per sec

The number of cache grid global hits per second.

Cache grid - Cache grid global misses per sec

The number of cache grid global misses per second.

Cache grid - Cache grid local hits per sec

The number of cache grid local hits per second.

Cache grid - Cache grid local misses per sec

The number of cache grid local misses per second.

Cache grid - Cache grid misses filled from Oracle database per sec

The number of cache grid misses filled from the Oracle database per second.

Client/Server - ALTER statements executed by server per sec

The number of ALTER statements executed per second by the TimesTen server.

Client/Server - Bytes received by server per sec

The number of client/server bytes received per second by the TimesTen server.

Client/Server - Bytes transmitted by server per sec

The number of client/server bytes transmitted per second by the TimesTen server.

Client/Server - CREATE statements executed by server per sec

The number of CREATE statements executed per second by the TimesTen server.

Client/Server - DELETE statements executed by server per sec

The number of DELETE statements executed per second by the TimesTen server.

Client/Server - DROP statements executed by server per sec

The number of DROP statements executed per second by the TimesTen server.

Client/Server - INSERT statements executed by server per sec

The number of INSERT statements executed per second by the TimesTen server.

Client/Server - MERGE statements executed by server per sec

The number of MERGE statements executed per second by the TimesTen server.

Client/Server - Round trips per sec

The number of client/server round-trips per second.

Client/Server - SELECT statements executed by server per sec

The number of SELECT statements executed per second by the TimesTen server.

Client/Server - Table rows deleted by server per sec

The number of table rows deleted per second by the TimesTen server.

Client/Server - Table rows inserted by server per sec

The number of table rows inserted per second by the TimesTen server.

Client/Server - Table rows updated by server per sec

The number of table rows updated per second by the TimesTen server.

Client/Server - Transaction rollbacks by server per sec

The number of transaction rollbacks per second by the TimesTen server.

Client/Server - Transactions committed by server per sec

The number of transactions committed per second by the TimesTen server.

Client/Server - UPDATE statements executed by server per sec

The number of UPDATE statements executed per second by the TimesTen server.

DB - Table rows deleted per minute

The number of table rows deleted per minute in the TimesTen database.

DB - Table rows inserted per minute

The number of table rows inserted per minute in the TimesTen database.

DB - Table rows read per minute

The number of table rows read per minute in the TimesTen database.

DB - Table rows updated per minute

The number of table rows updated per minute in the TimesTen database.

Lock - Deadlocks per minute

The number of deadlocks per minute.

Lock - Immediate lock grants per minute

The number of nonblocking locks acquired per minute.

Lock - Lock grants after wait per minute

The number of blocking locks acquired per minute.

Lock - Lock timeouts per minute

The number of lock timeouts per minute.

Lock - Percent locks granted immediately

The percent of locks granted immediately versus having to wait.

Log - Log buffer MB inserted per sec

The number of megabytes inserted into the log buffer per second.

Log - Log buffer waits per minute

The 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

The 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

The 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

The ratio of the prepares per minutes to executes per minute.

Replication - Transactions replicated per minute

The number of transactions replicated to a peer per minute.

Statement - DELETE statements executed per sec

The number of DELETE statements executed per second.

Statement - INSERT statements executed per sec

The number of INSERT statements executed per second.

Statement - MERGE statements executed per sec

The number of MERGE statements executed per second.

Statement - SELECT statements executed per sec

The number of SELECT statements executed per second.

Statement - Total statements executed per sec

The total number of statements executed per second.

Statement - UPDATE statements executed per sec

The number of UPDATE statements executed per second.

Transaction - Transaction rollbacks per sec

The number of transactions rolled back per second.

Transaction - Transactions committed per sec

The number of transactions committed per second.

Transaction - Transactions durably committed per sec

The number of durable transactions committed per minute.

Workload - Commands prepared per minute

The number of SQL commands prepared (compiled) per minute.

Workload - Commands reprepared per minute

The number of SQL commands reprepared (recompiled) per minute.

Workload - Connects per minute

The number of connections to the database per minute.

Workload - Disconnects per minute

The number of disconnects from the database per minute.

Workload - Queries per sec

The number of queries per second.


Readonly cache

Table 14-10 shows readonly cache metrics and describes the metrics.

Table 14-9 Readonly Cache

Metric Description

Auto refresh status

The status of the autorefresh operation.

Cache group ID

The identifier of the cache group.

Cache group name

The name cache group.

Cache group owner

The owner of the cache group.

Object Identifiers

The object identifier of the table on the Oracle database.

Refresh Interval

The refresh interval for the cache group.

Refresh Time Spent(ms)

The total time spent performing refresh operations.

Rows autorefreshed

The number of rows that have been autorefreshed.

Start Time

The timestamp of when the last autorefresh was performed.

Updates pending refresh

The number of updates that are pending refresh.


Replication peers

Table 14-10 shows replication peers metrics and describes the metrics.

Table 14-10 Replication Peers

Metric Description

Replication peer host name

Name of the system 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.

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.

Type

The replication type.


Replication status

Table 14-11 shows replication status information.

Table 14-11 Replication Status

Name Description

Replication peer name

The replication peer name.

Replication thread type

The replication thread type. Valid values are Transmitter or Receiver.

Start or restart count

Start or restart count.

Transactions sent or received

The total number of transactions sent or received.

Transactions sent or received per sec

The number of transactions sent or received per second.


Replication subscribers

Table 14-12 shows replication subscriber information.

Table 14-12 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 acknowledgment 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 host name

Name of the system 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 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 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.


Replication tracks

Table 14-15 shows replication tracks information.

Table 14-13 Replication Tracks

Name Description

Receiver batch commit counts

The total number of batch commits on the receiver.

Receiver batch commit time

The total time of batch commits on the receiver.

Receiver txn commit counts

The total number of commits on the receiver.

Receiver txn commit waits

The total number of commits waits on the receiver.

Subscriber

The subscriber database.

Track

The track number.

Transmitter log waits

The log waits from the transmitter.


Replication state

Table 14-11 shows replication state information.

Table 14-14 Replication State

Name Description

Cache Grid State

The current state of the cache grid if the active standby pair is configured for cache grid. If cache grid is not configured the status is No Cache Grid.

State

The current replication state of the database in an active standby pair.


Response

Table 14-15 shows response information.

Table 14-15 Response

Name Description

Status

Valid values are Up or Down.


SQL command cache

Table 14-16 describes information in the SQL command cache.

Table 14-16 SQL Command Cache

Name Description

Command ID

The SQL command identifier.

Executions which took place on this command

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

Fetch executions done internally for this statement

The number of fetch executions that were done internally for this statement.

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.

Last measured execution time of the command

The last measured execution time for this SQL command.

Maximum execute time in seconds of this statement

The maximum execution time in seconds for this SQL command.

Minimum execute time in seconds

The minimum execution time in seconds for this SQL command.

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.

Time when the statement started

The time of when the last execution of the SQL statement started.

Unique ID of a private connection

Unique identifier 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.


SQL execution time histogram

Table 14-18 shows SQL execution time histogram information.

Table 14-17 SQL Execution Time Histogram

Name Description

Accumulated wall clock execution time(sec) when sampling

The accumulated wall clock execution time when sampling in seconds.

Execution Time(sec) upper bound for the bucket

The execution time upper bound limit for this bucket in seconds.

Execution time samples since database start or statistics reset

The number of execution time samples that have been taking since the database has started or since statistics were reset.

SQL command count in this bucket

The SQL command count in this bucket.


Transaction log holds

Table 14-18 shows transaction log holds information.

Table 14-18 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.


Viewing TimesTen instance metrics

There are two groups of TimesTen instance metrics:

Figure 14-4 TimesTen Instance All Metrics

Description of Figure 14-4 follows
Description of "Figure 14-4 TimesTen Instance All 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.

Hosted databases

Table 14-18 shows hosted databases information.

Table 14-19 Hosted Databases

Name Description

Cache agent

This value can be either Up, Down, or N/A. If you have not configured a cache group, then this value is N/A.

Client server connections

The number of client/server connections to the database.

Database path name

The value is taken from the last part of the path to the database. For example, if the path to the database is /var/tt/sampledb_1122, the database name is sampledb_1122.

PL/SQL

This value can be either Enables or Disabled. Once PL/SQL support is enabled in a database, you cannot disable it later.

Ram status

This value can be either Loaded or Not loaded. The RAM status is Loaded if the database is loaded into memory.

Replication agent

This value can be either Up, Down, or N/A. If you have not configured a replication scheme, then this value is N/A.

Total connections

The total number of direct linked and client/server connections to the database.


Response

Table 14-18 shows response information.

Table 14-20 Response

Name Description

Status

Valid values are Up or Down.