Table of Contents
- Title and Copyright Information
- About This Content
- What's New
-
1
Connecting to a TimesTen Database
- Connecting to TimesTen with ODBC and JDBC Drivers
- Specifying Data Source Names to Identify TimesTen Databases
- Creating a DSN on Linux and UNIX for TimesTen Classic
- Defining Client and Server DSNs
- Resolution Path for a DSN
- DSN Examples for TimesTen Classic
- odbc.ini File Entry Descriptions
- Providing User Credentials When Connecting
- Connecting to a Database Using a Connection String
-
2
Managing TimesTen Databases
- Opening and Closing the Database for User Connections
- Specifying the Type of Memory for Shared Memory Segment
- Loading and Unloading the Database from Memory
- Detaching, Attaching, and Freeing the Shared Memory Segment
- Specifying a RAM Policy
- Disconnecting from a Database
- Specifying the Memory Region Sizes of a Database
- Storage Provisioning for TimesTen
- Bulk Copy Data Using the ttBulkCp Utility
- Thread Programming with TimesTen
-
Defragmenting TimesTen Databases
- Offline Defragmentation of a TimesTen Scaleout Database
- Offline Defragmentation of a TimesTen Classic Database
- Online Defragmentation of TimesTen Classic Databases in an Active Standby Pair Replication Scheme
- Online Defragmentation of TimesTen Classic Databases in a Non Active Standby Pair Replication Scheme
-
3
Working with the TimesTen Client and Server
- Overview of the TimesTen Client/Server
-
Configuring TimesTen Client and Server
- Overview of TimesTen Client/Server Configuration
- Installing and Configuring for Client/Server of the Same TimesTen Release
- Installing and Configuring Cross-Release TimesTen Client/Server
- Defining Server DSNs for TimesTen Server on a Linux or UNIX System
- Defining a Logical Server Name
- Defining Client DSNs on a TimesTen Client System
- Sizing the Client Result Set Buffer
- Using Automatic Client Failover
- Configuring TCP Keep-Alive Parameters
- Running the TimesTen Server
- Accessing a Remote Database on Linux and UNIX
-
4
Working with the TimesTen Daemon
- Starting and Stopping the Daemon
- Shutting Down a TimesTen Application
- Managing TimesTen Daemon Attributes
- Managing TimesTen Client/Server Attributes
- Error, Warning, and Informational Messages
-
5
Globalization Support
- Overview of Globalization Support Features
- Choosing a Database Character Set
- Character Set Length Semantics Affect Data Storage
- Setting the Connection Character Set
- Linguistic Sort Rules Support Linguistic Conventions
- SQL String and Character Functions
- Setting Globalization Support Attributes
- Globalization Support During Migration
-
6
Using the ttIsql Utility
- Using ttIsql in Batch Mode or Interactive Mode
- Customizing Startup Command Line Options for ttIsql Sessions
- Customizing the ttIsql Command Prompt
- Using the ttIsql Online Help
- Using the ttIsql 'editline' Feature for Linux and UNIX Only
- Using the ttIsql Command History
- Using the ttIsql edit Command
- Displaying Characters in ttIsql
- Displaying Database Structures Using ttIsql
- Using ttIsql to List Database Objects by Object Type
- Using ttIsql to View and Set Connection Attributes
- Using ttIsql to Manage Transactions
- Using ttIsql with Prepared and Parameterized SQL Statements
- Using, Declaring, and Setting Variables in ttIsql
- Creating and Running PL/SQL Blocks Within ttIsql
- Passing Data From PL/SQL Using OUT Parameters Within ttIsql
- Using the IF-THEN-ELSE Command Construct Within ttIsql
- Loading Data from an Oracle Database into a TimesTen Table Without Cache
- Using ttIsql to View and Change Query Optimizer Plans
- Using ttIsql to Manage ODBC Functions
- Specifying Error Recovery Within ttIsql
-
7
Transaction Management
- Transaction Overview
- Transaction Implicit Commit Behavior
- Ensuring ACID Semantics
- Concurrency Control Through Isolation and Locking
- Checkpoint Operations
- Transaction Logging
- Durability Options
- Transaction Reclaim Operations
- Recovery with Checkpoint and Transaction Log Files
-
8
Working with Data in a TimesTen Database
- Database Objects, Users, and Owners
- Understanding Tables
- Understanding Views
- Understanding Materialized Views
-
Understanding Indexes
- Overview of Index Types
- Creating an Index
- Altering an Index
- Dropping an Index
- Estimating the Size of an Index
- Using the Index Advisor to Recommend Indexes
- Understanding Rows
- Understanding Synonyms
- Understanding System Views
- 9 The TimesTen Query Optimizer
-
10
TimesTen Database Performance Tuning
-
System and Database Tuning
- Provide Enough Memory
- Avoid Paging of the Memory Used by the Database
- Size Your Database Correctly
- Calculate Shared Memory Size for PL/SQL Runtime
- Set Appropriate Limit on the Number of Open Files
- Configure Log Buffer and Log File Size Parameters
- Avoid Connection Overhead for TimesTen Classic Databases
- Load the Database Into RAM When Duplicating
- Prevent Reloading of the Database After Automatic Recovery Fails
- Reduce Contention
- Consider Special Options for Maintenance
- Check Your Driver
- Enable Tracing Only as Needed
- Use Metrics to Evaluate Performance
- Migrate Data with Character Set Conversions
- Use TimesTen Native Integer Data Types If Appropriate
- Configure the Checkpoint Files and Transaction Log Files to be on a Different Physical Device
-
Client/Server Tuning
- Diagnose Client/Server Performance
- Work Locally When Possible
- Choose Timeout Connection Attributes for Your Client
- Choose a Lock Wait Timeout interval
- Choose the Best Method of Locking
- Enable Prefetch Close for Read-Only Transactions
- Use a Connection Handle When Calling SQLTransact
- Enable Multi-Threaded Mode to Handle Concurrent Connections
-
SQL Tuning
- Tune Statements and Use Indexes
- Collect and Evaluate Sampling of Runtimes for SQL Statements
- Creating Tables Without Indexes for Performance When Loading Data
- Select the Appropriate Type of Index
- Size Hash Indexes Appropriately
- Use Foreign Key Constraint Appropriately
- Compute Exact or Estimated Statistics
- Update Table Statistics for Large Tables in Parallel
- Create Script to Regenerate Current Table Statistics
- Control the Invalidation of Commands in the SQL Command Cache
- Avoid ALTER TABLE
- Avoid Nested Queries
- Prepare Statements in Advance
- Avoid Unnecessary Prepare Operations
- Store Data Efficiently with Column-Based Compression of Tables
- Control Read Optimization During Concurrent Write Operations
- Choose SQL and PL/SQL Timeout Values
- Materialized View Tuning
- Transaction Tuning
- Recovery Tuning
- Scaling for Multiple CPUs
- XLA Tuning
- Cache and Replication Tuning
-
System and Database Tuning