16 Viewing Reports

Reports are generated from the metric information that has been collected and stored in the Oracle Enterprise Manager repository.

Topics include:

Viewing reports

Ensure that you are on the TimesTen database target page. For more information on navigating to the TimesTen database target page, see "Navigating to the TimesTen target page".

Note:

TimesTen specific reports are only available for TimesTen database targets.

  1. From the TimesTen Database Home menu, select Information Publisher Reports.

    The Information Publisher Reports page displays. Locate the Title column in the Information Publisher Reports table.

  2. In the Title column, click the name of the TimesTen report.

    The Specify Target for Report page displays.

  3. Click Continue.

    The report displays. If you want to print the report, select Printable Page.

Types of reports

There are nine report categories containing 10 groups of reports.

The categories, groups, and subgroups are:

  • TimesTen Cache Grid Reports

    • TimesTen Cache AWT Activity Reports

      • AWT Commits

      • AWT Rows per Batch

      • AWT Throughput

    • TimesTen Cache Grid Activity Reports

      • Cache Grid Global Hit Percent

      • Cache Grid Attaches and Detaches

      • Cache Grid Hits and Misses

  • TimesTen Connections

    • TimesTen database Connections Reports

      • Current Connections

      • Connection Rate

  • TimesTen Lock Reports

    • TimesTen database Lock Activity Reports

      • Locks Granted Immediately vs Wait

      • Locks Timeouts and Deadlocks

  • TimesTen Log Monitoring

    • TimesTen database Transaction Log Reports

      • Log Inserts Activity

      • Log Waits Activity

      • Completed Checkpoints

      • Checkpoint Bytes Written Activity

      • Recovery Activity

  • TimesTen Memory Monitoring

    • TimesTen database Memory Reports

      • Permanent Memory Activity

      • Temporary Memory Activity

      • PL/SQL Memory Activity

  • TimesTen PLSQL Reports

    • TimesTen database PLSQL Reports

      • Pin Hit Ratio

      • PL/SQL Invalidations and Reloads

  • TimesTen SQL Operations

    • TimesTen database SQL Operation Reports

      • SQL Operations

  • TimesTen Tables

    • TimesTen database Table Activity Reports

      • Rows Processed

  • TimesTen database Monitoring

    • TimesTen database Activity Reports

      • Log Activity

      • Transactions Activity

      • Space Usage (% full)

      • Log Buffer Bytes