Skip Headers
Oracle® Enterprise Manager System Monitoring Plug-in for Oracle TimesTen In-Memory Database User's Guide
Release 12.1.0.2.0

E28645-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

3 Working with the TimesTen Home Page

This chapter describes the TimesTen home page. The home page conveys high level configuration and performance information about your TimesTen database.

Topics include:

Viewing the TimesTen home page

To view the home page, make sure you are on the TimesTen target page. For information on navigating to the TimesTen target page, see "Navigating to the TimesTen target page".

From the TimesTen IMDB menu, select Home.

The TimesTen home page displays.

Analyzing information on the TimesTen home page

The TimesTen home page consists of five regions each of which has been customized specifically for TimesTen targets.

The five home page regions described in detail include:

Summary

Figure 3-1 Summary region

Description of Figure 3-1 follows
Description of "Figure 3-1 Summary region"

This region shows information about your TimesTen target:

  • Datastore name

    This value is taken from the last part of the path to the datastore. For example, if the path to the datastore is /var/tt/sampledb_1122, the datastore name is sampledb_1122.

  • Instance name

    The name of your current TimesTen instance.

  • TimesTen version

    The version of your current TimesTen instance.

  • Hostname

    The name of the host where TimesTen is running.

  • Oracle Net Service Name

    The service name of the Oracle database used for cache. If you have not configured cache, then this value is N/A.

Status

This region shows status information including:

  • TimesTen Server

    This value can be either Up or Down. The TimesTen Server is the listener process that enables client/server connections to the database.

  • Cache Agent

    This value can be either Up, Down, or N/A. If you have not configured a cache environment, then this value is N/A. The Cache Agent is used for read or write caching of data in an Oracle 10g or 11g database.

  • Replication Agent

    This value can be either Up, Down, or N/A. If you have not configured a replication scheme, then this value is N/A. The Replication Agent is used to either replicate data between TimesTen databases or to asynchronously write data to an Oracle 10g or 11g database.

  • Loaded Since

    The date when the database was loaded into memory.

Configuration

Figure 3-3 Configuration region

Description of Figure 3-3 follows
Description of "Figure 3-3 Configuration region"

This region shows configuration information specific to your database. These attributes are first connection attributes and the values are set at first connect. For more information on first connection attributes, see "Connection Attributes" in the Oracle TimesTen In-Memory Database Reference.

  • Allocated PERM Space

  • Allocated TEMP Space

  • Internal log buffer size

  • PL/SQL memory segment size

Performance Overview

The Performance Overview region consists of four subregions. The first three subregions include information represented in graphical format. All graphs are represented against time.

Current connections

Figure 3-4 Current connections region

Description of Figure 3-4 follows
Description of "Figure 3-4 Current connections region"

This region uses a line graph to show the number of direct linked connections and client/server connections. These line graphs change according to time in order to show not only the current value but also the values collected in recent metric collections.

The X-Axis represents time. The Y-Axis represents the number of current direct linked connections and the number of client/server connections. These connections do not include subdaemon connections or connections created by the TimesTen plug-in to collect configuration and performance data.

Database usage (%)

Figure 3-5 Database usage region

Description of Figure 3-5 follows
Description of "Figure 3-5 Database usage region"

This region uses a line graphs to show permanent and temporary space currently in use. The values are expressed as a percentage of what was configured at database first connect. For information on the configured values, see the Summary, Status, and Configuration regions.

The X-Axis represents time. The Y-Axis represents the percent of permanent space in use and the percent of temporary space in use.

High database usage may indicate the need to grow the database by allocating more permanent or temporary space.

Free disk available (%)

Figure 3-6 Free disk available region

Description of Figure 3-6 follows
Description of "Figure 3-6 Free disk available region"

This region uses a graph to show the free space in the file systems where the checkpoint and transaction log files are currently located.

The X-Axis represents time. The Y-Axis represents the free space in the checkpoint file system and the free space in the transaction log file system. If you configured the checkpoint and transaction log files in the same file system and path, the two lines will be on top of each other and you will see one line.

A very low percentage of free disk available may indicate a need to install a larger disk.

Executed statements - SQL command cache

Figure 3-7 Executed statements - SQL command cache region

Description of Figure 3-7 follows
Description of "Figure 3-7 Executed statements - SQL command cache region"

This regions shows the Top SQL statements in the SQL command cache expressed in table format. This information is useful in analyzing your queries. It may be useful to sort by the number of executions to see the SQL statements that are most executed. It may also be useful to exclude system SQL commands by clicking in the box to the left of Exclude System.

As you review the top executions, look at the values in the Prepares column. If the SQL query is not prepared, then you should prepare the query. For optimal performance, a SQL statement should be prepared once and executed many times. If the number of prepares for a SQL statement is large then check to see if your application can be enhanced to minimize the number of prepares per SQL statement.In addition, you can click on the text in the Query Text column. When you do this, a Full SQL text dialog opens showing the SQL query. You can copy and paste this SQL query into the worksheet in SQL Developer and review the results from Explain Plan. You can also paste the SQL query into ttIsql and look at the showplan for the query. This may give you a better understanding of how and why your queries are performing as they are.

You can also click on the column header to sort the table based on the column. A description of each column follows:

  • Command ID

    A unique identifier for the SQL command. This number is generated by the TimesTen database.

  • Executions

    A counter for the number of executions that took place on this command since it was brought into the command cache.

  • Prepares

    A counter for the number of prepares for a SQL statement.

  • Reprepares

    A counter of the number of reprepares.

  • Owner

    The identifier of the user who created the command.

  • Query text

    The SQL text.

Issues

This region displays alerts that have exceeded either warning or error thresholds.