# ⚡ Performance Lab

Deep Oracle performance analysis — top SQL killers, wait event root causes, live blocking contention, and segment hotspots. All with concrete DBA playbooks.

Connection:
🎯
Demo Mode — Sample Data

Connect a real Oracle DB via Dashboard → New Connection to see live data.

| SQL ID ↕ | Execs ↕ | Elapsed/exec ↕ | Buf Gets/exec ↕ | Disk Reads/exec ↕ | CPU/exec ↕ | Schema
--- | --- | --- | --- | --- | --- | --- | ---

⟳Querying Oracle + generating AI fixes… 15–30 seconds.
📊

Select a connection and click Fetch Data to see your top 25 SQL killers with AI fixes.

Window:
⟳Querying ASH + generating DBA playbooks…
⏱

Select a connection and click Fetch Data to see wait event distribution.

DB Time by Wait Class
Top Wait Events — Click to Expand Playbook

| Event | Wait Class | Count | Avg Wait | Total Wait | Top SQL ID
--- | --- | --- | --- | --- | --- | ---

⟳Querying V$SESSION for live locks…
🔒

Select a connection and click Fetch Data to check for blocking sessions.

⟳Querying V$SEGMENT_STATISTICS + generating AI recommendations…
📦

Select a connection and click Fetch Data to find your hottest segments.

| Segment | Owner | Type | Logical Reads
--- | --- | --- | --- | ---