3 Working with the TimesTen Home Page

Current connections

Figure 3-4 Current connections region

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 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 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 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.