Contents Lab128 - Tools for Advanced Oracler Tuning and Monitoring. Reference Guide.

Reports

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:QADBTime:Thu, 10/21/2010 10:32:31 AM, loc

Instance Info.

INSTANCE_NUMBER12
INSTANCE_NAMEqadb1qadb2
HOST_NAMEdb13db14
VERSION10.2.0.4.010.2.0.4.0
STARTUP_TIME10/20/2010 11:43:47 PM10/20/2010 11:51:06 PM
STATUSOPENOPEN
PARALLELYESYES
THREAD#12
ARCHIVERSTARTEDSTARTED
LOG_SWITCH_WAIT
LOGINSALLOWEDALLOWED
SHUTDOWN_PENDINGNONO
DATABASE_STATUSACTIVEACTIVE
INSTANCE_ROLEPRIMARY_INSTANCEPRIMARY_INSTANCE
ACTIVE_STATENORMALNORMAL
BLOCKEDNONO
source: gv$instance

This report was prepared by Lab128, visit www.lab128.com for more information.