13 Working with TimesTen Performance Metrics
TimesTen collects performance metrics from TimesTen system tables, system views, and built-in procedures. SQL Developer allows you to capture snapshots and generate reports that compare two snapshots. A snapshot is a collection of performance metrics.
Note:
SQL Developer uses functions from the TT_STATS
PL/SQL package to capture snapshots and generate reports that compare two snapshots. For more information about the TT_STATS
PL/SQL package, see "TT_STATS" in the Oracle TimesTen In-Memory Database PL/SQL Packages
Reference.
Before attempting to use the TimesTen Performance Metrics:
-
Ensure that you are using Oracle TimesTen In-Memory Database Release 11.2.2.5 (or higher).
-
Ensure that the TimesTen connection user has execution privileges on the
TT_STATS
PL/SQL package. Any other user, including anADMIN
user, must be grantedEXECUTE
privilege for theTT_STATS
package by the instance administrator or by anADMIN
user, such as in the following example:GRANT EXECUTE ON SYS.TT_STATS TO scott;
This chapter provides information about working with TimesTen performance metrics.
Topics include:
Creating snapshots
A snapshot is a collection of performance metrics from a database. You can create a report comparing two snapshots to analyze the performance of your database.
To create a new snapshot of a database, ensure that you are on the main SQL Developer page and that you have expanded the TimesTen connection in the connections navigator.
Dropping snapshots
Consider dropping unneeded snapshots to free up permanent space. If you need to save more snapshots of your database, consider editing the TimesTen performance metrics configuration. See Editing the TimesTen performance metrics configuration.
To drop a new snapshot from a database, ensure that you are on the main SQL Developer page.
Editing the TimesTen performance metrics configuration
TimesTen performance metrics configuration allows you to modify the maximum snapshot count and the maximum snapshot retention size. These configuration settings are useful in preventing your database from running out of permanent space and in allowing you to save more snapshots.
Once the maximum snapshot count or the maximum snapshot retention size is reached, TimesTen removes the oldest snapshots to free up permanent space. By default, the maximum snapshot count is 256 and the maximum snapshot retention size is 256 MB.
To edit the TimesTen performance metrics configuration for a database, ensure that you are on the main SQL Developer page.
Creating a TimesTen performance metrics report
TimesTen performance metrics reports use the data from two specified snapshots of TimesTen metrics to produce a report in HTML format. TimesTen metrics reports include information for each metric. For more information about the various metrics displayed in the report, see "ttStats" in the Oracle TimesTen In-Memory Database Reference.
To generate a new report for a database, ensure that you are on the main SQL Developer page.