Table of Contents
- Title and Copyright Information
- Preface
- What's New
-
1
The TimesTen Prometheus Exporter
- About Prometheus
- About the TimesTen exporter
- About configuring the TimesTen exporter and Prometheus with client certificate authentication
- Configuring the TimesTen exporter and Prometheus with client certificate authentication
- About configuring the TimesTen exporter and Prometheus with no authentication
- Configuring the TimesTen exporter and Prometheus with no authentication
-
The metrics supported by the TimesTen exporter
- Metrics timesten_aging_lru_commit_total to timesten_cg_autorefresh_row_update_total
- Metrics timesten_cg_awt_oracle_call_total to timesten_cg_flushed_row_total
- Metrics timesten_cg_parawt_auto_apply_applctn_seqnum to timesten_cg_parawt_auto_apply_partitions
- Metrics timesten_cg_parawt_auto_apply_plsqlmode_batches to timesten_cg_parawt_auto_apply_validbatch_waits
- Metrics timesten_cg_parawt_auto_rx_batches to timesten_cg_parawt_auto_sorter_txns_waits
- Metrics timesten_cg_parawt_auto_tx_applier_waits to timesten_ckpt_write_total
- Metrics timesten_collections_timedout to timesten_cs_server_transmitted_byte_total
- Metrics timesten_cursor_close_total to timesten_index_range_rebuild_insert_total
- Metrics timesten_index_range_row_fetch_repl_total to timesten_lock_timeout_total
- Metrics timesten_log_buffer_insert_byte to timesten_remote_update_executes_total
- Metrics timesten_repl_log_out_busy_total to timesten_repl_transmitter_catch_lag_total
- Metrics timesten_repl_transmitter_drift_request_total to timesten_table_row_insert_total
- Metrics timesten_table_row_read_total to timesten_txn_voted_no_total
-
2
Tools for Troubleshooting TimesTen
- Using the ttCapture utility
- Using the ttIsql utility
- Using the ttStatus utility
- Using the logs generated by the TimesTen daemon
- Using the ttTraceMon utility
- Using the ttXactAdmin utility
- About using SNMP traps for diagnostics
- Using ODBC tracing
- Monitoring the TimesTen system tables
- Using the query optimizer
-
3
Troubleshooting TimesTen Applications and Databases
- Unable to start or stop TimesTen daemon
- No response from TimesTen daemon or subdaemon
- Unable to create shared segment
-
Application unable to connect to database in direct mode
- Upgrading your database
- Privileges to connect to database
- Check file system permissions to access database
- Check that the TimesTen daemon is running
- Check DSN definition
- Manage semaphores and shared memory segments
- Check available swap space (virtual memory)
- Increase the number of available file descriptors
-
Troubleshooting Client/Server problems
- Cannot connect to the TimesTen Server
- TimesTen Server failed
- Cannot find Server DSN
- TimesTen Server failed to load DRIVER
- Application times out when accessing TimesTen Server
- TimesTen Client loses connection with TimesTen Server
- Failed to attach to shared memory segment for IPC
- Thread stack overflow when using multiple client connections
- Out of space when DSN specifies new database
- Application connects or disconnects are slow
- Application is disconnected unexpectedly
- Application is slow
- Application unresponsive, appears hung
- Application unable to find previously created objects
- Troubleshooting OCI and Pro*C/C++ applications
-
Running out of a resource
- Operating system tools and shared memory
- Check the amount of memory allocated to the database
- Update query optimizer statistics
- Check memory used by queries
- Out of memory after fatal crash of the database
- Check transaction log file use of file system space
- Check if tracing is enabled
- Check the semaphore limit
- Duplicate results from a SELECT statement
- Cannot attach PL/SQL shared memory
-
4
Monitoring and Troubleshooting TimesTen Cache
- Monitoring cache groups with autorefresh
- Unable to create a cache group
- Unable to start or stop the cache agent
- Unable to resolve Oracle Service Name
- Unable to resolve connect identifier
- Incompatible Oracle Database Server and Client versions
-
Unable to validate the Oracle database user name and password
- Check library path environment variable
- Check status of TNS listener and Oracle Database Server
- Check the Oracle database privileges
- Check database source name definition
- Reboot TimesTen machine
- Set the cache administration user name and password
- Check user and system environment in TimesTen Classic
- Verify the loaded dynamic libraries for TimesTen Classic
- OCI initialization failed
- Unsupported data type mapping
- Null constraint does not match Oracle Database
- DDL on cached Oracle database tables may cause failure
- Changes not visible after updating object in cache group
- Loading or refreshing fails
- Optimize performance for TimesTen Cache
- Check large batch jobs on Oracle database tables
- Autorefresh not refreshing cache at the specified interval
- Incremental autorefresh not progressing
- Incremental autorefresh becomes full autorefresh
-
Poor autorefresh performance
- Unresponsive or dead TimesTen database degrades autorefresh performance
- Refresh of cache group with autorefresh has excessive waiting on resources
- Abnormally large change log and base tables degrade autorefresh performance
- Fragmented autorefresh change log table space
- Performance degrades when autorefresh interval is small
- Declaring NOVALIDATE on constraints causes cache group failure
- AWR report showing lock contention with DBMS_LOCK
-
5
Troubleshooting Replication
- Unable to create a replication scheme
- Unable to alter a replication scheme
- Unable to start or stop replication agent
- Replication does not work
- Replication unresponsive, appears hung
- Poor replication or XLA performance
- Problems using ttRepAdmin
- Problems with conflict checking
- Problems with parallel replication
- 6 Troubleshooting AWT Cache Groups
- Index