Know your gear
Quest Central Performance Diagnostics with Spotlight allows you to quickly discover any performance bottleneck - in real-time or historically - using the granular record and playback function. Spotlight identifies and diagnoses thousands of performance issues, whether it's a specific user, resource-intensive SQL transaction, I/O bottleneck, lock wait or other exact source. Spotlight on Oracle automatically sets a baseline of normal activity for each instance, and can automatically set thresholds and display alerts when it detects performance bottlenecks of any kind.