Chat now with support
Chat with Support

Spotlight on Oracle 10.6 - Release Notes

Spotlight on Oracle RAC Drilldowns

Spotlight on Oracle RAC 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

Top Sessions lists all users connected to the Oracle database.

As per Spotlight on Oracle.

SQL & Application Workload CTRL+Q Top SQL Page | Array Fetch Page | Parse Activity Page | Sort Activity Page

As per Spotlight on Oracle.

The SQL & Application Workload drilldown in Spotlight on Oracle RAC does NOT contain the following pages:

  • Analyze Trace
  • Result Cache
Activity CTRL+Y Summary Page | Waits Page | Waiting Events Page | Blocking Locks Page | Latches Page | Transactions Page | Buffer Busy Waits Page

As per Spotlight on Oracle.

The Activity drilldown in Spotlight on Oracle RAC does NOT contain the following pages:

  • Lock Activity
  • Server
  • Rollback
I/O CTRL+I Summary Page | Sessions Page | Tablespaces Page | Datafiles Page | Segment Page | Buffer Pool Page | Chains / Migrations Page

As per Spotlight on Oracle.

Configuration & Memory CTRL+N SGA Utilization Page | In-Memory Page | Oracle Parameters Page | Alert Log Page

As per Spotlight on Oracle.

The Configuration & Memory drilldown in Spotlight on Oracle RAC does NOT contain the following pages:

  • Shared Pool Utilization
  • Buffer Cache
Disk Storage CTRL+D Archive Destinations Page | Tablespace Utilization Page

The Disks drilldown displays detailed information about the logical and physical disks.

As per Spotlight on Oracle.

The Disk Storage drilldown in Spotlight on Oracle RAC does NOT contain the following pages:

  • Online Redo
  • Recovery Area
Cluster CTRL+U

Latency Page | Balance Page | Miss Ratio Page | Corrupt/Lost Blocks Page

Overhead Page

The pages in the Cluster drilldown display information about the performance of the Oracle RAC cluster, including details on cluster latency, balance, overhead, miss ratios, and corrupt or lost blocks.
ASM CTRL+M Diskgroups Page | Disks PageFiles Page | Storage Page | Operation Page

Diagnose the performance of Automatic Storage Management (ASM) for the Oracle RAC cluster.

As per Spotlight on Oracle.

Services CTRL+E Services By Instance | Resources Page | Activity PageWaits Page | Configuration Page

The Services drilldown displays details of the services defined and deployed for the Oracle RAC cluster.

Note: Available for Oracle 10.2 and later.

Predictive Diagnostics CTRL+G Predictive Diagnostics

Collect and analyze performance metrics in order to predict the future behavior of the Oracle database.

As per Spotlight on Oracle.

Pluggable Databases CTRL+P Resource Usage

(Oracle 12c) View resource usage of pluggable databases.

Data Guard CTRL+W Standby Connections Dialog

Use to 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 RAC connection is configured as a Primary database in an Oracle Data Guard environment.

Exadata CTRL+T

Exadata Databases | Exadata ASM Groups | Exadata Cell Disks |Exadata Smart Flash Cache | Exadata Cell Balance | Exadata Cell Metrics

Detect and help resolve performance issues on Oracle's Exadata machine.

Note: Spotlight on Oracle RAC may include monitoring of Exadata systems depending on the license purchased. When licensed, the Exadata icon is enabled on connection to an Oracle Exadata system.

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. For more information, see Spotlight on Oracle RAC Alarms.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating