- Oracle Database version: 19c
- Operating System: Windows Server 2019
- CPU: 2 cores
- RAM: 8GB
- Storage: 256GB SSD
- 2 Posts
- 12 Views
Need Help With Oracle Database Performance Tuning
Hello everyone,
I need advice on how to make my Oracle database work better because I'm currently having some performance problems.
Here are some details about my setup:
I've observed that my database queries are running more slowly than usual, and I'm experiencing a lot of CPU and disc wait times. I've tried to optimize my SQL queries and indexes, but the performance hasn't really increased.
Any advice you have on how I may make my Oracle database run more efficiently would be greatly appreciated. Are there any particular configurations or settings I need to pay attention to? Can I find bottlenecks and optimize my database using any tools?
Thank you in advance for your help!
@Vivek Garg Hi, we need to identify what are the bottlenecks and where, why and where most of the database time are being spent. A good starting point is to collect a few AWR (30 min snapshot interval is better) and ASH reports (10-15 min interval) around the problem time. Best!