This chapter includes the following topics:
TimesTen and TimesTen 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®.
TimesTen and TimesTen 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.
Most TimesTen and TimesTen Cache administration tasks are performed with command line utilities. The following table summarizes common utilities:
||A general utility for managing TimesTen databases and TimesTen 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.|
||Used to create a backup copy of a database and restore it at a later time.|
||Used to transfer data between TimesTen tables and ASCII files.|
||Used to run SQL interactively from the command line. Also provides a number of administrative commands to reconfigure and monitor databases.|
||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.|
||Used to monitor replication status.|
||Used to estimate the amount of space to allocate for a table in the database.|
||Used to display information that describes the current state of TimesTen or TimesTen Cache.|
||Used to enable and disable the TimesTen and TimesTen Cache internal tracing facilities.|
||Used to list ownership, status, log and lock information for each outstanding transaction. The
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.
Oracle SQL Developer is a graphical tool for database development tasks. Use SQL Developer to:
Browse, create, and edit database objects and PL/SQL programsAutomate cache group operations
Manipulate and export data
Execute SQL and PL/SQL statements and scripts
View and create reports
SQL Developer is a Java application that supports direct-linked and client/server connections to the TimesTen databases. Support for connecting to multiple databases enables SQL Developer users to work with data in the TimesTen and the Oracle databases concurrently.
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.
TimesTen and the TimesTen Cache provide the facilities to perform three types of upgrades:
In-place upgrades are typically used to move to a new patch release of TimesTen or TimesTen 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 TimesTen Cache and installing the new release, applications can reconnect to the databases and resume operation.
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 TimesTen 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.
TimesTen replication enables online upgrades, which can be performed online by the
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 TimesTen 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 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 SQL Developer, see Oracle SQL Developer Oracle TimesTen In-Memory Database Support User's Guide.
For more information about general administration of TimesTen, see "Managing TimesTen Databases" and "Working with Data in a TimesTen Database" in the Oracle TimesTen In-Memory Database Operations Guide. These chapters include the use of the ODBC Administrator.
For more information about administering TimesTen replication, see the Oracle TimesTen In-Memory Database Replication Guide.
For a complete list of SQL statements, see the Oracle TimesTen In-Memory Database SQL Reference.
For a complete list of TimesTen command-line utilities, see the Oracle TimesTen In-Memory Database Reference.