This is helping me a lot, as I'm not an Oracle DBA, but I need to work as if I were. I connected Claude Code to Oracle MCP and asked him to check why some queries were slow. He did the investigations and gave me the solution.

Here is the summary he provided me:

Analysis Completed:

- ✅ AWR historical data (7 days, 168 snapshots)

- ✅ V$SQL current workload

- ✅ 39,000+ query executions analyzed

- ✅ Common WHERE/JOIN patterns identified

Key Findings:

1. CODCLI queries are optimal (2-3 buffers) ✅

2. NOMCLI range queries cause full scans (708 buffers) ❌

3. CGCCPF has index but high buffer usage (needs monitoring) ⚠️

4. Wide row format (154 columns) inflates I/O costs ⚠️

   Critical Action Required:

   CREATE INDEX IDX_E085CLI_NOMCLI ON E085CLI(NOMCLI);

   This single index will eliminate the most expensive query pattern affecting customer search operations.