1/21
Contents
Title and Copyright Information
Preface
Audience
Related documents
Conventions
Documentation Accessibility
What's New
New features in release 12.1.0.3.0
1
Installing the Enterprise Manager Plug-in for TimesTen
Installation prerequisites
Additional requirements
Installing the Enterprise Manager Plug-in for TimesTen
Download the plug-in
Deploy the plug-in on Oracle Management Service
Deploy the plug-in on the Management Agent
Configure a TimesTen target
Initial automatic discovery configuration
Automatic discovery configuration for a TimesTen instance target
Automatic discovery configuration for a TimesTen database target
Manual configuration for a TimesTen instance target
Manual configuration for a TimesTen database target
Verifying and validating the plug-in
Setting preferred credentials for a target
Changing the monitoring configuration of a TimesTen database target
Upgrading the Enterprise Manager Plug-in for TimesTen
Limited functionality when only upgrading Management Server
Uninstalling the Enterprise Manager 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 instance target page
Overview of the TimesTen database target page
Setting the display time period and auto refresh rate of data on a target page
View data
Auto refresh
Viewing the log of control operations
3
Working with Access Control
Overview of access control
Creating a group
Defining roles
Creating users
Granting preferred credentials to users
4
Working with the TimesTen Instance Home Page
Viewing the TimesTen instance home page
Analyzing information on the TimesTen instance home page
Instance summary
Daemon status
Server status
Hosted databases
5
Working with the TimesTen Database Home Page
Viewing the TimesTen home page
Analyzing information on the TimesTen home page
Status and Summary
Summary
Status
Configuration
Performance Overview and Issues
Performance Overview
Database Usage (%)
Database Connections
Free Space (%)
Issues
SQL Execution Time and Monitor
SQL Monitor
SQL Execution Time Histogram
6
Working with the Performance Summary Page
Viewing the performance summary page
Analyzing information on the TimesTen performance summary page
Connections
Connects and disconnects
Statements
Write rates
Read rates
Ratio of prepares to executes
Break up of executed statement types
Summary
Detail
Workload
Write workload
Read workload
Prepares and reprepares
Commits and rollbacks
Locks
Locks and deadlocks
Lock grants
Percentage of acquired locks without wait
Transaction Logs
Log holds
Log performance
Log reads and log flushes
Log buffer wait
Checkpoints
7
Working with the Transaction Monitor
Viewing the transaction monitor page
Analyzing information on the transaction monitor page
Outstanding locks
Transaction information
Lock detail for transaction
Awaiting locks
8
Working with the Client/Server Page
Viewing the client/server page
Analyzing information on the TimesTen client/server page
Server Workload
Write rates
Read rates
Commits and rollbacks
Statements
Write rates
Read rates
Network usage
Network round trips
Bytes sent and received
9
Working with the Instance Control Menu
Viewing the instance control menu
Start/stop services
Service
Database
Create blackout
End blackout
10
Working with the Database Control Menu
Viewing the database control menu
Start/stop agents
Ram load/unload and policy settings
Load/unload RAM
RAM policy configuration
Current configuration
Change RAM policy
Create blackout
End blackout
11
Working with the Backup and Restore Page
Viewing the backup and restore page
Analyzing information on the TimesTen backup and restore page
Backup schedule
Create a backup schedule
Incremental
Full
Activate a backup schedule
Deactivate a backup schedule
Request an immediate backup
Delete a backup schedule
Backup history and restore database
Restore the TimesTen database with an available backup
Delete a TimesTen database backup file
Restore history
Review a restore history entry
Delete a restore history entry
12
Working with the Cache Synchronization Metrics Page
Viewing the cache synchronization metrics page
Analyzing the cache synchronization metrics page
Cache AWT
Cache AWT
AWT transactions propagated to the Oracle database
AWT transactions committed on Oracle database
AWT batch performance
AWT volume (MB/sec)
Cache parallel AWT
Performance
AWT lag
AWT bytes sent
AWT batch performance
AWT transactions
Tracks
Parallel AWT tracks
Transactions processed on Oracle database
Cache autorefresh
Cache autorefresh
Readonly cache
Updates pending refresh
13
Working with the Replication Monitor
Viewing the replication monitor
Analyzing information on the TimesTen replication monitor
Summary
Status
State
Replication peers
Replication log holds
Transmitter thread status
Replication transmitters
Transactions sent in the last hour
Receiver thread status
Replication receivers
Transactions received in the last hour
Tracks
14
Viewing Metrics
Navigating to the TimesTen database metrics page
Navigating to the TimesTen instance metrics page
Viewing TimesTen database metrics
Checkpoint history
Checkpoint and transaction log file system usage
Database information
Instance information
Parallel AWT Rates
Parallel AWT Tracks
Performance data
Performance rates
Readonly cache
Replication peers
Replication status
Replication subscribers
Replication tracks
Replication state
Response
SQL command cache
SQL execution time histogram
Transaction log holds
Viewing TimesTen instance metrics
Hosted databases
Response
15
Viewing Target Topology
Viewing the topology page
Changing the view of the topology page
Adding monitoring metrics
16
Viewing Reports
Viewing reports
Types of reports
Index
Scripting on this page enhances content navigation, but does not change the content in any way.