This is generic guide to the Report page. The reports can be called using Main menu | Reports. Most reports depend on the calling environment - the instance currently in focus, selected SQL, selected session, selected time interval etc. If you see the Reports menu entry grayed (disabled), this means that these report needs more specific selection. For example, the Statspack-style report needs a time interval, so if you are currently in the Sessions window, the report cannot be called because it is not possible to select a time interval in this window. On the other hand, you can select a session in this screen, so all session-related reports will be enabled.
Alternatively, reports are available through most popup menus, in the Reports submenu.
Lab128 reports use HTML internally. A built-in viewer has the same behavior as a web browser. The reports can be exported and saved in several formats: they can be loaded into MS Word, or they can be copied onto the clipboard in HTML and text form and pasted into many other applications.
Additional options are accessible through the popup menu - using right-click:
Below is an example of report generated by Lab128:
Database: | QADB | Time: | Thu, 10/21/2010 10:32:31 AM, loc |
INSTANCE_NUMBER | 1 | 2 |
INSTANCE_NAME | qadb1 | qadb2 |
HOST_NAME | db13 | db14 |
VERSION | 10.2.0.4.0 | 10.2.0.4.0 |
STARTUP_TIME | 10/20/2010 11:43:47 PM | 10/20/2010 11:51:06 PM |
STATUS | OPEN | OPEN |
PARALLEL | YES | YES |
THREAD# | 1 | 2 |
ARCHIVER | STARTED | STARTED |
LOG_SWITCH_WAIT | ||
LOGINS | ALLOWED | ALLOWED |
SHUTDOWN_PENDING | NO | NO |
DATABASE_STATUS | ACTIVE | ACTIVE |
INSTANCE_ROLE | PRIMARY_INSTANCE | PRIMARY_INSTANCE |
ACTIVE_STATE | NORMAL | NORMAL |
BLOCKED | NO | NO |