Re: Query performance
Enabling slow_query_log in production is generally safe, but it can add slight I/O overhead if the volume of slow queries is high. A safe approach is to enable it with a reasonable threshold, e.g., long_query_time = 1 second, and monitor performance. Use a dedicated log file to avoid impacting main operations.
Subject
Written By
Posted
November 28, 2025 01:12PM
Re: Query performance
November 25, 2025 02:24PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.