Skip Headers
Oracle® In-Memory Database Cache Introduction
Release 11.2.1

Part Number E14261-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

9 TimesTen and IMDB Cache Administration

This chapter includes the following topics:

Installing TimesTen and IMDB Cache

TimesTen and IMDB Cache software is easy to install. On UNIX systems, TimesTen is installed by a simple set-up script. On Windows, TimesTen is installed by running InstallShield®.

Access Control

TimesTen and IMDB Cache are installed with Access Control to allow only users with specific privileges to access particular TimesTen features.

TimesTen Access Control uses standard SQL statements to establish TimesTen user accounts with specific privilege levels. TimesTen offers object-level access control as well as database-level access control.

Command line administration

Most TimesTen and IMDB Cache administration tasks are performed with command line utilities. The following table summarizes common utilities:

Name Description
ttAdmin A general utility for managing TimesTen databases and IMDB Caches. Used to specify policies for automatically or manually loading and unloading databases from RAM, as well as to starting and stopping TimesTen cache agents and replication agents.
ttBackup and ttRestore Used to create a backup copy of a database and restore it at a later time.
ttBulkCp Used to transfer data between TimesTen tables and ASCII files.
ttIsql Used to run SQL interactively from the command line. Also provides a number of administrative commands to reconfigure and monitor databases.
ttMigrate Used to save tables and cache group definitions to a binary data file. Also used to restore tables and cache group definitions from the binary file.
ttRepAdmin Used to monitor replication status.
ttSize Used to estimate the amount of space to allocate for a table in the database.
ttStatus Used to display information that describes the current state of TimesTen or IMDB Cache.
ttTraceMon Used to enable and disable the TimesTen and IMDB Cache internal tracing facilities.
ttXactAdmin Used to list ownership, status, log and lock information for each outstanding transaction. The ttXactAdmin utility also allows users to commit, abort or forget an XA transaction branch.

SQL administration

TimesTen provides SQL statements for administrative activities such as creating and managing tables, replication schemes, cache groups, materialized views, and indexes.

The metadata for each TimesTen database is stored in a group of system tables. Applications can use SQL SELECT queries on these tables to monitor the current state of a database.

Administrators can use the ttIsql utility for SQL interaction with a database. For example, there are several built-in ttIsql commands that display information on database structures.

SQL Developer

Oracle SQL Developer is a graphical tool for database development tasks.

Use SQL Developer to create, edit and delete TimesTen database objects and enter SQL statements directly into the TimesTen database or IMDB Cache. You can also use it to browse objects in multiple databases. IMDB Cache users can view tables in the cache database and the Oracle database at the same time.

SQL Developer is available on Windows and Linux. It communicates to TimesTen and the IMDB Cache by using the TimesTen JDBC driver, so it must be installed on a machine where either a TimesTen client or a TimesTen server installation is present. SQL Developer supports TimesTen and later.

Oracle Enterprise Manager

The Oracle TimesTen In-Memory Database Plug-In for Oracle Enterprise Manager is deployed as part of an Enterprise Manager Agent, running on the server on which the TimesTen or IMDB Cache database resides. The TimesTen Plugin provides users the ability to monitor system information and view database configuration and performance statistics for key areas including checkpoints, connections, locks, memory, replication, transactions and workloads.Users can monitor the information with the browser interface or generate reports using the Enterprise Manager report wizard.

ODBC Administrator

The ODBC Administrator is a utility program used on Windows to create, configure and delete data source definitions. You can use it to define a data source and set connection attributes.

Upgrading TimesTen and the IMDB Cache

TimesTen and the IMDB Cache provide the facilities to perform three types of upgrades:

In-place upgrades

In-place upgrades are typically used to move to a new patch release of TimesTen or IMDB Cache.

In-place upgrades can be done without destroying the existing databases. However, all applications must first disconnect from the databases, and the databases must be unloaded from shared memory. After uninstalling the old release of TimesTen or IMDB Cache and installing the new release, applications can reconnect to the databases and resume operation.

Offline upgrades

Offline upgrades are performed by using the ttMigrate utility to export the database into an external file and to restore the database with the desired changes.

Use offline upgrades to perform the following tasks:

  • Move to a new major TimesTen or IMDB Cache release

  • Move to a different directory or machine

  • Reduce database size

During an offline upgrade, the database is not available to applications. Offline upgrades usually require enough disk space for an extra copy of the upgraded database.

Online upgrades

TimesTen replication enables online upgrades, which can be performed online by the ttMigrate and ttRepAdmin utilities while the database and its applications remain operational and available to users. Online upgrades are useful for applications where continuous availability of the database is critical.

Use online upgrades to perform the following tasks:

  • Move to a new major release of TimesTen or IMDB Cache and retain continuous availability to the database

  • Increase or reduce the database size

  • Move the database to a new location or machine

Updates made to the database during the upgrade are transmitted to the upgraded database at the end of the upgrade process. Because an online upgrade requires that the database be replicated to another database, it can require more memory and disk space than offline upgrades.

For more information

For more information about installing and upgrading TimesTen, see Oracle TimesTen In-Memory Database Installation Guide.

For more information about Access Control, see Oracle TimesTen In-Memory Database Operations Guide.

For more information about general administration of TimesTen, see "Creating TimesTen Data Stores" and "Working with Data in a TimesTen Data Store" in Oracle TimesTen In-Memory Database Operations Guide. These chapters include the use of the ODBC Administrator.

For more information about administering TimesTen replication, see Oracle TimesTen In-Memory Database TimesTen to TimesTen Replication Guide.

For a complete list of SQL statements, see Oracle TimesTen In-Memory Database SQL Reference.

For a complete list of TimesTen command-line utilities, see Oracle TimesTen In-Memory Database Reference.