Contents

Title and Copyright Information

Preface

• Audience
• Related documents
• Conventions
• Documentation Accessibility

1 Installing the System Monitoring Plug-in for TimesTen

• Installation prerequisites
  • Additional requirements
• Installing the System Monitoring Plug-in for TimesTen
  • Download the plug-in
  • Deploy the plug-in on OMS
  • Deploy the plug-In on the Management Agent
  • Configure a TimesTen target
• Verifying and validating the plug-in
• Setting preferred credentials for a target
• Changing the monitoring configuration of a target
• Uninstalling the System Monitoring Plug-in for TimesTen
  • Remove the TimesTen target
  • Undeploy the plug-in from the Management Agent
  • Undeploy the plug-in from OMS
  • Delete the plug-in

2 Working with the TimesTen Target Page

• Navigating to the TimesTen target page
• Overview of the TimesTen target page

3 Working with the TimesTen Home Page

• Viewing the TimesTen home page
• Analyzing information on the TimesTen home page
• Summary
• Status
• Configuration
• Performance Overview
  • Current connections
  • Database usage (%)
  • Free disk available (%)
  • Executed statements - SQL command cache
• Issues

4 Working with the Performance Page

• Viewing the performance page
• Analyzing information on the TimesTen performance page
• Connections
  • Connect and disconnect rates
  • Aggregates
• Statements
  • Write rates
  • Read rate
  • Ratio of prepare to execute rates
  • Summary
  • Detail
• Workload
  • Write workload
  • Read workload
  • Prepares and reprepares
  • Aggregates
• Commits and rollbacks
• Locks
  • Lock performance
    • Locks and deadlocks
    • Lock grants
    • Percentage of acquired locks without wait
  • Transaction monitor
    • Refresh mode
    • Outstanding locks
    • Lock details
    • Awaiting locks
• Transaction Logs
  • Log holds
    • Summary
    • Log holds
  • Log performance
    • Aggregates
    • Log reads and log flushes
    • Log buffer wait
• Checkpoints
  • Checkpoint history
  • Aggregates

5 Working with the Cache Synchronization Metrics

• Viewing the cache synchronization metrics
• Analyzing cache synchronization metrics
• Cache autorefresh
• Cache AWT
• Cache SWT
• Cache flush
• AWT transactions propagated to Oracle DB
• AWT transactions committed on Oracle DB
• Transactions committed on TimesTen
• AWT batch performance
• AWT volume (mb) per sec

6 Viewing Metrics

• Navigating to the metrics page
• Viewing metrics
  • Checkpoint history
  • Checkpoint and transaction log file system usage
  • Database Information
  • Instance information
  • Performance data
  • Performance rates
  • Replication peers
  • Replication status
  • Replication subscribers
  • Response
  • SQL command cache
  • Transaction log holds

7 Working with the Replication Monitor

• Viewing the replication monitor
• Analyzing information on the TimesTen replication monitor
• Summary
• Status
• Aggregates
• Replication peers
• Replication log holds
• Transmitter threads status
• Receiver threads status
• Performance

8 Viewing Reports

• Viewing reports
• Types of reports

Index