Once a problem is isolated you can display a drilldown page with charts and tables that provide a detailed breakdown of the underlying statistics.
|Drilldown||Click to open||Keyboard Shortcut||Drilldown Pages||Description|
The Top Sessions drilldown displays information on the users connected to the Oracle database. Identify the users who contribute most to database activity. Display various details for these sessions, including the SQL statements, locks and resource usage.
|SQL & Application Workload||CTRL+Q|
Use the Activity drilldown to display overall efficiency and resource usage. In particular, the Event waits chart shows the amount of time database sessions spend waiting for various resources, as well as the amount of CPU being utilized.
Efforts at tuning the database are most likely to succeed when they concentrate on the resources being used most heavily. For more information, see Deal With Wait Events.
|I/O||CTRL+I||Summary Page | Sessions Page | SQL Page | Tablespaces Page | Datafiles Page | Segment Page | Buffer Pool Page | Chains / Migrations Page||The I/O drilldown shows the input and output activity for the Oracle database including: I/O by category, session, SQL, tablespaces, datafiles, segments and row chaining.|
|Configuration & Memory||CTRL+N||The Configuration and Memory drilldown shows the memory utilization for the Shared Pool and the SGA, the shared pool and buffer cache hit ratios, the Oracle alert log and Oracle parameters.|
Tip: To open the related Spotlight on Windows or Spotlight on Unix connection, click the arrow next to the Operating System drilldown icon.
Right click the tables in the Disk Storage drilldown to open Space Manager. Tools | Space Manager
Use the Tuning drilldown to view information on Oracle memory resources in the Oracle SGA and PGA (System and Program Global Areas), to tune memory resources where feasible, and to view and dynamically tune latch activity for systems with multiple CPUs.
This is relevant if your system uses ASM.
ASM (Automatic Storage Management) is a storage management solution from Oracle Corporation that automatically reorganizes data based on statistics collected from usage and user access patterns over time.
|DTrace||CTRL+R||System Calls Page | Disk IO Page||
DTrace is a dynamic analysis tool for Sun platforms. Spotlight uses DTrace to capture details of the interaction between Oracle and the operating system.
Install before use. Install And Configure DTrace Scripts
Collect and analyze performance metrics in order to predict the future behavior of the Oracle database.
|Pluggable Databases||CTRL+P||Resource Usage||
(Oracle 12c) View the resource usage of pluggable databases.
|Data Guard||CTRL+W||Standby Connections Dialog.||
Configure Spotlight to monitor Standby databases to this Primary database in an Oracle Data Guard environment.
Note: The Data Guard icon is enabled when the current Spotlight on Oracle connection is configured as a Primary database in an Oracle Data Guard environment.
|Reports||CTRL+R||The Report Wizard generates printable reports. The reports are designed and delivered through SAP Crystal Reports.|
The Alarm Log drilldown displays information on the alarms associated with the Windows system, including the name of the component that issued the alarm, the date and time the alarm was logged, and the severity of the alarm.
Note: The Alarm Log drilldown is common to all Spotlight applications. The alarms are specific to the current Spotlight connection. Spotlight on Oracle Alarms