How Structured Prompting Is Becoming a Real Engineering Skill
Artificial intelligence is no longer just a curiosity for technical teams. In database operations, cloud administration, and automation engineering, it is increasingly being used as a working layer for faster troubleshooting, documentation, scripting, and architectural thinking.
50 Ready-to-Use Oracle DBA Prompt Layouts – Professional Handbook
Oracle DBA Handbook V3 – Real Production Prompts
1. Standby Apply Lag RCA
/production /dba /rca Act as senior Oracle DBA. Context: Oracle 19c physical standby lagging by 2 hours. Task: Diagnose whether lag is archive gap, network latency, standby I/O, or apply bottleneck. Constraints: No switchover. Output: Validation SQL, ranked causes, safest recovery.
2. Archive Log Generation Spike
/production /dba Analyze archive generation spike in Oracle RAC after deployment. Constraints: No restart, no hidden parameters. Output: Top redo-generating SQL, affected objects, safest fix.
3. ORA-04031 Shared Pool Pressure
/dba Diagnose ORA-04031 in 19c RAC. Context: Shared pool pressure during batch window. Constraints: Avoid hidden parameters first. Output: Memory analysis, root cause, safe correction.
4. RMAN Restore Validation Audit
/dba Generate RMAN restore validation checklist for weekly backup audit. Constraints: Include corruption detection and restore proof.
5. ASM FRA Growth Investigation
/dba Analyze FRA sudden growth in ASM diskgroup. Constraints: Production-safe cleanup only. Output: Root cause and cleanup sequence.
6. Blocking Sessions RCA
/rca /dba Analyze blocking sessions causing application timeout. Constraints: Avoid session kill unless necessary. Output: Blocking chain and safest action.
7. Deadlock Pattern Diagnosis
/dba Review repeated ORA-00060 deadlocks and infer SQL/application pattern. Output: Root cause and prevention.
8. Expdp Slow Performance
/dba Explain expdp performance bottleneck for large schema export. Constraints: Avoid unsafe parallel misuse. Output: Exact tuning steps.
9. AWR Dominant Wait Analysis
/tune Analyze AWR report and identify dominant wait event with exact corrective action.
10. PDB Clone Validation Checklist
/dba Create production-safe PDB clone checklist for SIT environment including rollback.
11. Listener Intermittent Refusal
/production /dba Act as senior Oracle DBA. Context: Listener Intermittent Refusal in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
12. Redo Transport Delay
/production /dba Act as senior Oracle DBA. Context: Redo Transport Delay in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
13. Temp Tablespace Explosion
/production /dba Act as senior Oracle DBA. Context: Temp Tablespace Explosion in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
14. Undo Growth Investigation
/production /dba Act as senior Oracle DBA. Context: Undo Growth Investigation in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
15. Datafile Autoextend Risk
/production /dba Act as senior Oracle DBA. Context: Datafile Autoextend Risk in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
16. Invalid Object Surge
/production /dba Act as senior Oracle DBA. Context: Invalid Object Surge in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
17. RMAN Catalog Sync Failure
/production /dba Act as senior Oracle DBA. Context: RMAN Catalog Sync Failure in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
18. ASM Rebalance Slowdown
/production /dba Act as senior Oracle DBA. Context: ASM Rebalance Slowdown in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
19. Password File Sync Issue
/production /dba Act as senior Oracle DBA. Context: Password File Sync Issue in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
20. Service Failover Validation
/production /dba Act as senior Oracle DBA. Context: Service Failover Validation in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
21. Node Eviction Analysis
/production /dba Act as senior Oracle DBA. Context: Node Eviction Analysis in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
22. CPU Spike During Batch
/production /dba Act as senior Oracle DBA. Context: CPU Spike During Batch in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
23. Latch Contention RCA
/production /dba Act as senior Oracle DBA. Context: Latch Contention RCA in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
24. Cursor Leak Diagnosis
/production /dba Act as senior Oracle DBA. Context: Cursor Leak Diagnosis in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
25. Library Cache Lock Analysis
/production /dba Act as senior Oracle DBA. Context: Library Cache Lock Analysis in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
26. GoldenGate Lag Diagnosis
/production /dba Act as senior Oracle DBA. Context: GoldenGate Lag Diagnosis in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
27. DB Link Failure RCA
/production /dba Act as senior Oracle DBA. Context: DB Link Failure RCA in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
28. Archive Destination Full
/production /dba Act as senior Oracle DBA. Context: Archive Destination Full in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
29. Flashback Retention Pressure
/production /dba Act as senior Oracle DBA. Context: Flashback Retention Pressure in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
30. Controlfile Record Saturation
/production /dba Act as senior Oracle DBA. Context: Controlfile Record Saturation in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
31. PDB Open Failure
/production /dba Act as senior Oracle DBA. Context: PDB Open Failure in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
32. Dictionary Stats Strategy
/production /dba Act as senior Oracle DBA. Context: Dictionary Stats Strategy in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
33. Object Invalid After Patch
/production /dba Act as senior Oracle DBA. Context: Object Invalid After Patch in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
34. Segment Growth Forecast
/production /dba Act as senior Oracle DBA. Context: Segment Growth Forecast in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
35. Top SQL Regression
/production /dba Act as senior Oracle DBA. Context: Top SQL Regression in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
36. Parallel Query Overload
/production /dba Act as senior Oracle DBA. Context: Parallel Query Overload in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
37. Scheduler Job Locking
/production /dba Act as senior Oracle DBA. Context: Scheduler Job Locking in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
38. AWR Baseline Comparison
/production /dba Act as senior Oracle DBA. Context: AWR Baseline Comparison in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
39. Alert Log Critical Pattern
/production /dba Act as senior Oracle DBA. Context: Alert Log Critical Pattern in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
40. RMAN Crosscheck Cleanup
/production /dba Act as senior Oracle DBA. Context: RMAN Crosscheck Cleanup in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
41. Standby Rebuild Strategy
/production /dba Act as senior Oracle DBA. Context: Standby Rebuild Strategy in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
42. Redo Log Switch Storm
/production /dba Act as senior Oracle DBA. Context: Redo Log Switch Storm in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
43. High Parse Rate RCA
/production /dba Act as senior Oracle DBA. Context: High Parse Rate RCA in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
44. Session Leak Detection
/production /dba Act as senior Oracle DBA. Context: Session Leak Detection in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
45. ASH Active Session Diagnosis
/production /dba Act as senior Oracle DBA. Context: ASH Active Session Diagnosis in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
46. Sequence Contention
/production /dba Act as senior Oracle DBA. Context: Sequence Contention in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
47. Metadata Lock Investigation
/production /dba Act as senior Oracle DBA. Context: Metadata Lock Investigation in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
48. SQL Plan Flip Analysis
/production /dba Act as senior Oracle DBA. Context: SQL Plan Flip Analysis in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
49. Large Object Segment Growth
/production /dba Act as senior Oracle DBA. Context: Large Object Segment Growth in production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
50. Hybrid Partition Maintenance
/production /dba Act as senior Oracle DBA. Context: Hybrid Partition Maintenance in a production Oracle environment. Task: Diagnose the exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
51. Standby Temp Usage
/production /dba Act as senior Oracle DBA. Context: Standby Temp Usage in production Oracle environment. Task: Diagnose the exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
52. Audit Trail Growth
/production /dba Act as senior Oracle DBA. Context: Audit Trail Growth in production Oracle environment. Task: Diagnose the exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
53. Password Rotation Validation
/production /dba Act as senior Oracle DBA. Context: Password Rotation Validation in production Oracle environment. Task: Diagnose the exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
54. TNS Timeout Analysis
/production /dba Act as senior Oracle DBA. Context: TNS Timeout Analysis in a production Oracle environment. Task: Diagnose the exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
55. Connection Storm Diagnosis
/production /dba Act as senior Oracle DBA. Context: Connection Storm Diagnosis in a production Oracle environment. Task: Diagnose exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
56. Index Fragmentation Review
/production /dba Act as senior Oracle DBA. Context: Index Fragmentation Review in production Oracle environment. Task: Diagnose the exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
57. Statistics Lock Strategy
/production /dba Act as senior Oracle DBA. Context: Statistics Lock Strategy in the production Oracle environment. Task: Diagnose the exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
58. Tablespace Forecast Model
/production /dba Act as senior Oracle DBA. Context: Tablespace Forecast Model in a production Oracle environment. Task: Diagnose the exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
59. PDB Resource Manager Review
/production /dba Act as senior Oracle DBA. Context: PDB Resource Manager Review in production Oracle environment. Task: Diagnose the exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
60. Failover Readiness Validation
/production /dba Act as senior Oracle DBA. Context: Failover Readiness Validation in production Oracle environment. Task: Diagnose the exact cause and safest resolution. Constraints: Include validation, rollback, and production risk. Output: SQL checks and recommended action.
Caution
The information provided in this document is intended for educational and internal reference purposes only. Although the procedure has been tested internally, no guarantee is given that it will behave identically in all environments. Use this guide at your own risk, and always validate the complete process in a test environment before applying it to production systems.