Welcome to Spotlight
Install Spotlight
Start 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
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
Troubleshooting: Connection Problems
Analyze Trace Settings Dialog
To open the Analyze Trace Settings Dialog
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click SQL & Application Workload | Analyze Trace | Trace Files.
- Right click a row on the Trace File Details grid and select Analyze Trace File.
To fill in the Analyze Trace Settings Dialog
| Option | Description |
|---|---|
| Process Wait Events | Select to analyze the behavior of wait events that appear in this trace file. |
| Process Bind Variables | Select to analyze the execution of bind variables that appear in this trace file. |
| PGA Limit (in MB) |
This is the amount of Program Global Area memory that can be allocated to analyzing trace files. If left blank the value defaults to the current value of PGA_AGGREGATE_TARGET. |
| Comment | Enter the comments (if any) that you want to add when you analyze this trace file. |
| Analysis Methods | Select whether to analyze the trace file immediately, or whether to schedule the analysis for a later time (as per Oracle scheduling). |