Hello,
Thanks for the insightful response. If I understood correctly, you're suggesting the following ways to improve the situation:
1. Add More Resources: Increase the number of processes that can scan segments, which in essence means increasing the capacity of our system to handle more queries.
2. Database Optimization: Work on database maintenance tasks such as indexing, defragmentation and partitioning. This includes actions like range partitioning for better segment pruning, compaction to reduce fragmentation, and configuring segments for faster scanning through secondary partitioning.
So, the key takeaway is that improving system resources and maintaining the health of the database could alleviate the problem. Have I understood this correctly?