Spotlight on Oracle 10.4 - Getting Started Guide

The Spotlight home page shows the flow of information and commands between various sub-components and the size and status of internal resources such as processes, disk files and memory structures.

Related operating system statistics are grouped together on panels that are connected by a series of graphical flows and icons. Spotlight updates these flows in real time so you can see how quickly data is moving through the system. The icons change color as Spotlight alarms are raised, upgraded, downgraded and canceled.

Tip: Hover the mouse pointer over a panel component for more information.

To see the Spotlight on MySQL Home Page

Select the Spotlight on MySQL connection from the Spotlight browser.
Click .

Spotlight on MySQL Alarms

Spotlight alarms indicate when the MySQL database exceeds acceptable performance thresholds.

Alarm	Description
Buffer Pool Hit Rate Alarm	The Buffer Pool Hit Rate alarm fires when the proportion of table data that can be found in the InnoDB buffer pool drops below a specified threshold.
CPU Busy Alarm	The CPU Busy alarm occurs when the total CPU utilization of the system exceeds a threshold. The CPU may encounter a large number of requests, or you may have un-tuned SQL, which unnecessarily uses excessive amounts of CPU.
Inefficient Sort Alarm	The Inefficient Sort alarm fires when the number of temporary files created for sorts is high in comparison to the number of sorts performed.
Low Free Physical RAM Alarm	The Low Free Physical RAM alarm occurs when the server’s available RAM is low.
Query Cache Hit Rate Alarm	The Query Cache Hit Rate alarm fires when the proportion of SQL queries that can be found in the MySQL query cache drops below a specified threshold.

Spotlight on MySQL 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	Keyboard Shortcut	Drilldown Pages	Description
Top Sessions	CTRL+S	Top Sessions Page	The pages in the Top Sessions drilldown display information about the users connected to the MySQL database.
Activity	CTRL+Y	Summary Page \| Mutex Page \| Sorts Page \| Query Cache Page \| Configuration Page \| Statistics Page \| InnoDB Status Page \| Error Log Page \| General Log Page \| Slow Query Log Page	The pages in the Activity drilldown display details of the activity on the MySQL database.
Operating System	CTRL+O	OS Performance Page \| OS Processes Page	The pages in the Operating System drilldown display information related to the performance of, and processes on, the operating system where the MySQL server is running.
Alarm Log	CTRL+L	Alarm log \| Alarms by Time \| Spotlight Today	The Alarm Log drilldown displays information on the alarms associated with the MySQL database. Note: The Alarm Log drilldown is common to all Spotlight applications. The alarms are specific to the current Spotlight connection. Spotlight on MySQL Alarms