|Oracle® SQL Developer Oracle TimesTen In-Memory Database Support User's Guide
|PDF · Mobi · ePub|
This chapter provides information about generating both TimesTen supplied reports and user-defined reports.
To generate or create reports, click the Reports tab on the uppermost left corner of the SQL Developer navigator. If this tab is not visible, select View and then Reports. For more information about how SQL Developer generates and creates reports, see the Oracle SQL Developer User's Guide.
You can either choose to create your own user-defined reports or you can choose to generate TimesTen supplied reports.
To create your own user-defined reports, click the + sign to the left of the User Defined Reports node.
To view the list of TimesTen supplied reports, click the + sign to the left of the TimesTen Reports node.
TimesTen reports are grouped into the categories:
There are two reports you can generate:
Choose TimesTen configuration to generate a report on the attribute settings for your current database connection. For detailed information on these attributes, see the built-in procedure "ttConfiguration" in the Oracle TimesTen In-Memory Database Reference.
Choose Version Banner to generate a report on your database release. For more information, see the built-in procedure "ttVersion" in the Oracle TimesTen In-Memory Database Reference.
The All Objects reports list information about database objects accessible to the user connected to the TimesTen database. There are three types of reports:
Object Count by Type
Choose All Objects to generate a report for each database object accessible to the user. This report includes information on the owner of the object, the name of the object, the type of the object (for example, table, view), the date the object was created, and the date when the last DDL operation was performed on it. The date of the last DDL operation is useful in determining changes to the definition of the object.
Choose Object Count by Type to generate a report on the count of all database objects by owner and type.
Choose Public Synonyms to generate a report on the names of public synonyms and underlying object type for the public synonyms.
Cache Groups reports include information about the cache groups owned by the user associated with the specified connection. The reports include:
Cache Group Details
User Cache Group Count by Type
Choose Cache Group Details to view reports for the cache groups:
Asynchronous Writethrough Cache Groups
Readonly Cache Groups
Synchronous Writethrough Cache Groups
User Managed Cache Groups
Choose User Cache Group Count by Type to view a report that shows the type of cache group and the count for each type of cache group.
Database Administration reports include information on:
Choose All Tables to generate reports on the names of tables, columns, constraints, and indexes accessible to the user connected to the TimesTen database.
Choose Users to generate a report on all internal and external database users.
Performance reports include information on:
Choose Statistics Configuration to generate a report on the current statistics configuration of the TimesTen database.
Choose Statistics Report to generate an HTML report comparing the two most recent statistics snapshots with the same capture level.
Choose Statistics Snapshots to generate a report of all the currently available statistics snapshots. This report includes information on the ID of the snapshot, timestamp of when the snapshot was taken, and the capture level of the snapshot.
For more information on the performance metrics, see Chapter 11, "Working with TimesTen Performance Metrics".
There are three reports you can generate:
Program Unit Arguments
Search Source Code
Unit Line Counts
These reports are generated for PL/SQL procedures, functions, and packages.
Security reports list information about system and object privileges granted to the user connected to the TimesTen database. Security reports also list information about the privileges granted to the
Security reports are grouped into two categories:
Grants and Privileges
Choose Grants and Privileges reports to view information about the system and object privileges granted to the user connected to the TimesTen database. Choose Public Grants to view information about the privileges granted to the
PUBLIC role. Public Grants reports include information on:
Counts by Grantor
Table reports include information on:
Choose the Table reports to generate reports on the tables, columns, constraints, and indexes owned by the user connected to the TimesTen database. In addition, choose the Table reports to generate a report on private synonyms.
Reports for Table Sizes are displayed if you are using TimesTen Release 11.2.2 or later. If you are not using TimesTen Release 11.2.2 or later, then if you choose Table Sizes, a No Query Found dialog appears. You will see the error: No query found for version of selected database.