The five-step guide to SQL tuning | CloudWorld 2022
YouTube video by Oracle
youtu.be
June 25, 2025 at 2:16 PM
SQL Plan Baseline, SQL Patch, SQL Profile: Differences and Use Cases dincosman.com/2025/04/10/s...
SQL Plan Baseline, SQL Patch, SQL Profile: Differences and Use Cases
This content highlights the importance of stability in database performance, especially regarding Oracle’s SQL execution plans, which can fluctuate based on various factors. It focuses on three pri…
dincosman.com
June 9, 2025 at 9:45 AM
SQL Plan Baseline, SQL Patch, SQL Profile: Differences and Use Cases dincosman.com/2025/04/10/s...
OPTIMIZER_FEATURES_ENABLE (OFE) method to address a slow SQL query
www.dbi-services.com/blog/oracle-...
www.dbi-services.com/blog/oracle-...
Oracle: A possible method to address a slow query if there is time pressure
Sometimes there is no time for a long analysis of a slow query and a fix (workaround) has to be provided asap. In such cases it often helps to check if a query did run faster with a previous OPTIMIZER...
www.dbi-services.com
May 27, 2025 at 12:55 PM
OPTIMIZER_FEATURES_ENABLE (OFE) method to address a slow SQL query
www.dbi-services.com/blog/oracle-...
www.dbi-services.com/blog/oracle-...
"Silver bullet" for resolving RAC DB hang due to gc freelist even in 19c
mikedietrichde.com/2016/03/22/g...
mikedietrichde.com/2016/03/22/g...
May 21, 2025 at 12:56 PM
"Silver bullet" for resolving RAC DB hang due to gc freelist even in 19c
mikedietrichde.com/2016/03/22/g...
mikedietrichde.com/2016/03/22/g...
April 26, 2025 at 2:52 PM
Reposted by Vlatko J.
November 23, 2024 at 6:14 PM
👇interesting tread and resources by the man himself, @christophlutz.bsky.social
1/5
Oracle can restart DMLs for different reasons, each behaving differently:
Write consistency: on write conflict, handled in updThreePhaseExe
Internal errors: on ORA-14403 (and possibly others), handled in opiexe
A stmt can even incur both restart types in a single execution.
Oracle can restart DMLs for different reasons, each behaving differently:
Write consistency: on write conflict, handled in updThreePhaseExe
Internal errors: on ORA-14403 (and possibly others), handled in opiexe
A stmt can even incur both restart types in a single execution.
February 27, 2025 at 8:21 PM
👇interesting tread and resources by the man himself, @christophlutz.bsky.social
A Single Disk Replacement can cause Performance Issues on entire Exadata System (Doc ID 3059053.1)
February 19, 2025 at 4:31 PM
A Single Disk Replacement can cause Performance Issues on entire Exadata System (Doc ID 3059053.1)
