Spotlight on Oracle Drilldowns
Spotlight on Oracle Drilldowns
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 |
|---|---|---|---|---|
| Top Sessions |  |
CTRL+S |
Top Sessions Page | Parallel Query Sessions Page | DBMS Jobs Page |
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 |
Top SQL Page | Array Fetch Page | Parse Activity Page | Sort Activity Page | Trace Files Page | Result Cache Page |
Use the SQL & Application Workload drilldown to select, sort and display SQL statements executed according to specified criteria. |
| Activity |  |
CTRL+Y |
Summary Page | Waits Page | Blocking Locks Page | Lock Activity Page | Latches Page | Server Page | Transactions Page | Rollback Page | Buffer Busy Waits Page | Waiting Events Page |
The Activity drilldown shows Oracle database activity including: waits, waiting events, blocking locks, lock activity, latches, query servers, transactions, rollbacks, and buffer busy waits. 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 |
SGA Utilization Page | Shared Pool Utilization Page | Buffer Cache Page | In-Memory Page | Oracle Parameters Page | Alert Log Page | OEM Status Page | OEM Logs Page |
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. |
| Operating System |  |
CTRL+O |
Use the Operating System drilldown to show information on the performance, processes, and storage on the Spotlight on Oracle connection host. Tip: To open the related Spotlight on Windows or Spotlight on Unix connection, click the arrow next to the Operating System drilldown icon. | |
| Disk Storage |  |
CTRL+D |
Online Redo Page | Tablespace Utilization Page | Recovery Area Page | Archive Destinations Page | Flash Cache Page |
Use the Disk Storage drilldown to display information on online redo logs, tablespace utilization, archive destinations, and Flashback recovery. Right click the tables in the Disk Storage drilldown to open Space Manager. Tools | Space Manager |
| Tuning |  |
CTRL+U |
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. | |
| ASM |  |
CTRL+M |
Diskgroups Page | Disks Page | Files Page | Storage Page | Operation Page |
Use the ASM drilldown to diagnose ASM performance. 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. Applicable when the Spotlight on Oracle connection is hosted on a Unix operating system (Solaris 10 onwards). Install before use. Install And Configure DTrace Scripts |
| Predictive Diagnostics |  |
CTRL+G |
Collect and analyze performance metrics in order to predict the future behavior of the Oracle database. | |
| Virtualization |  |
CTRL+B |
Activity Page (ESX Server) | Virtual Machines Page (ESX Server) |
Applicable when the Spotlight on Oracle connection is hosted on a virtual machine. Show detailed information on the CPU and memory use of the virtual machine. |
| 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. | |
| Alarm Log |  |
CTRL+L |
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 |