Chat now with support
Chat with Support

Spotlight on Oracle 10.10 - Release Notes

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 PageSessions Page | SQL PageTablespaces PageDatafiles 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

OS Performance Page | OS Processes Page | OS Storage Page

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 PageTablespace 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

Performance Page | Memory Management Page | Latch Page

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.


Diskgroups Page | Disks PageFiles 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

Predictive Diagnostics

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)

Activity Page (Xen)

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

Report Wizard | SAP Crystal Reports

The Report Wizard generates printable reports. The reports are designed and delivered through SAP Crystal Reports.
Alarm Log CTRL+L

Alarm log | Alarms by Time | Spotlight Today

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


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating