Welcome to Spotlight
Install Spotlight
Start Spotlight
Spotlight on Oracle now includes web based analytics
Get Spotlight on your favorite mobile device
User Experience Feedback
Authorize Spotlight
Spotlight on Oracle
Connect to an Oracle Database
Oracle User Wizard
Spotlight on Oracle Data Guard
DBA Connection Credentials
User Account
New Oracle User
Select Tablespace
Predictive Diagnostics
Ready To Configure Oracle User
End
Configuring Oracle User for Spotlight Dialog
Toad DBA Suite for Oracle
Oracle Architecture Overview
Spotlight on Oracle Home Page
Spotlight on Oracle Alarms
Spotlight on Oracle Drilldowns
Install And Configure DTrace Scripts
Tune Your Oracle Database
Predictive Diagnostics
Spotlight on Oracle Tools: Explain Plan, SQL Optimizer, Space Manager
Spotlight on your favorite mobile device
Standby Connections Dialog
Spotlight on Oracle Data Guard Home Page
Spotlight on Oracle Data Guard Alarms
Spotlight on Oracle RAC
Connect to Spotlight on Oracle RAC
Spotlight on Unix
Oracle RAC Connection Details
Verify Cluster Connection Details Dialog
Connect to an Exadata Storage Server (Cells)
Spotlight on Oracle RAC Home Page
Spotlight on Oracle RAC Alarms
Spotlight on Oracle RAC Drilldowns
Configure the Unix System
Connect to Unix Systems
Spotlight on Unix Home Page
Spotlight on Unix Alarms
Spotlight on Unix Drilldowns
Spotlight on Windows
Connect to Windows Systems
Spotlight on Windows Home Page
Spotlight on Windows Alarms
Spotlight on Windows Drilldowns
Spotlight on MySQL
Connect to a MySQL Database
Spotlight on MySQL Home Page
Spotlight on MySQL Alarms
Spotlight on MySQL Drilldowns
Troubleshooting: Connection Problems
Sessions Page
Note: Oracle In-Memory is available for Oracle 12c Release 1 (12.1.0.2) and above. Data is displayed for Oracle instances where In-Memory is available and has been enabled. In-Memory is disabled by default.
Use this page to determine which sessions are benefiting from the use of the In-Memory column store.
To open the Sessions page
- Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
-
Click Configuration & Memory | In-Memory Page | Sessions Page.
Top Sessions by IM Scans Grid
Show the top 100 active sessions in descending order of their use of the in-memory column store (MB/GB).
Tip: Double-click on a Session to open that session in the Top Sessions drilldown.
| Column | Description |
|---|---|
| Instance Name | The instance in the RAC cluster where the session is running. |
| SID | The session identifier. |
| Oracle User | The Oracle user who started the session. |
| OS User | The operating system user for the client. |
| Machine | The name of the computer on which the client is running. |
| Logical Reads (blocks/s) | The rate at which data was read from SGA (not the In-Memory column store) in the preceding sampling interval. |
| IM Scans (blocks/s) | The rate at which data (blocks) was read from the In-Memory column store in the preceding sampling interval. |
| CPU Time (ms/s) |
The rate of CPU time (ms/s) used in the preceding sampling interval. |
| DB Time (ms/s) |
The rate of time spent performing user calls on the session in the preceding sampling interval. |
| IM Scans (Mbytes/s) | The rate at which data (Megabytes) was read from the In-Memory column store in the preceding sampling interval. |
| Disk Reads/s | The number of disk reads per second in the preceding sampling interval. |
| PGA Memory (Mbytes) | The amount of PGA memory used by the session. |
| Total IM Scans (Mbytes) | Total number of megabytes scanned from the In-Memory column store since the session connected. |
| Container Name |
The name of the container for the pluggable database. |
| Serial # | The serial number of the session. |
| SidSerial | The SID and Serial# combined and separated by '_'. This combination is always unique. |
| Total Consistent Gets | Total number of consistent (query) mode reads since the session connected. |
| Total CPU Time (ms) | Total amount of CPU time used since the session connected. |
| Total DB Block Gets | Total number of block gets since the session connected. |
| Total DB Time (ms) | Total amount of DB time (time spent processing user calls) since the session connected. |
| Total IM Scans (blocks) | Total number of blocks scanned from the In-Memory column store since the session connected. |
| Total Physical Reads | Total number of physical reads since the session connected. |