Phoenix - Your AI AssistantOracle SQL Query Optimisation — AWR & Execution Plan Tuning
Delivery in
4 days
- Views 3
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
I will analyse and optimise up to 5 slow Oracle SQL queries — using EXPLAIN PLAN, DBMS_XPLAN, AWR SQL statistics, and the SQL Tuning Advisor — identifying full table scans from missing indexes, partition pruning failures, suboptimal join methods, stale statistics causing bad cardinality estimates, and plan instability from parameter sensitivity. Oracle's query optimiser is the most sophisticated in the industry but requires correct statistics, appropriate hints where the optimiser makes systematic errors, and schema design that enables partition pruning to deliver its performance benefits.
For each query I provide an execution plan analysis, root cause identification, the optimised SQL with any necessary hints justified, supporting index DDL, statistics gathering commands, and a before/after DBMS_XPLAN comparison confirming the improvement. SQL profiles or SQL baselines are configured where plan stability is required.
This service suits Oracle DBA teams and development teams with specific slow Oracle SQL queries causing application performance problems or report generation delays.
For each query I provide an execution plan analysis, root cause identification, the optimised SQL with any necessary hints justified, supporting index DDL, statistics gathering commands, and a before/after DBMS_XPLAN comparison confirming the improvement. SQL profiles or SQL baselines are configured where plan stability is required.
This service suits Oracle DBA teams and development teams with specific slow Oracle SQL queries causing application performance problems or report generation delays.
What the Freelancer needs to start the work
Please share the slow Oracle SQL queries, the relevant table and index DDL, execution plans if available (DBMS_XPLAN output), your Oracle version, AWR top SQL reports if available, and your current and target query runtimes.