Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Need Help With Oracle Database Performance Tuning

Vivek Garg

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:

Oracle Database version: 19c
Operating System: Windows Server 2019
CPU: 2 cores
RAM: 8GB
Storage: 256GB SSD

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!

2 Posts
12 Views

Omar Faruq

@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!