Browse categories
Explore
Fiverr Pro
English
$
USD
I will tune slow oracle sql queries and fix plsql bugs procedures packages
Data entry, Excel cleanup, web scraping and product CSV automation
Hi, I'm Adnan Naveed, a freelancer from Pakistan working with data. I turn messy files, PDFs, and websites into clean, organized spreadsheets. I use Excel and Python to convert, clean, scrape, and bul...
About this Gig
Is a query, report or PL/SQL job slowing your Oracle system down, or failing with errors you can't trace?
I'm a Senior Oracle Developer with 11+ years building and supporting Oracle ERP systems (HR, Payroll, Inventory, Supply Chain, Finance) and Oracle EBS customizations in manufacturing. I write and tune SQL and PL/SQL every day.
WHAT I DO
- Find why a query is slow, using execution plans and statistics
- Rewrite SQL: joins, analytic functions, table functions, set-based logic instead of row-by-row loops
- Recommend indexes and materialized views only where they help
- Fix PL/SQL errors in procedures, functions, packages and triggers
- Add proper exception handling and logging
WHAT YOU GET
- Before/after execution plan comparison
- Clean, commented, tested script
- Short report: what was wrong, what I changed, why
- Rollback script (Premium)
HOW I WORK
I never run changes on your production database. I work on the code and a test copy or sample you provide, and you deploy when you're happy.
Oracle certified (Autonomous Database Cloud 2023 Professional, APEX Cloud Developer Professional).
Message me with the query or error first and I'll confirm the right package.
Database type:
Relational database
Platform:
Oracle
•
PL/SQL
Expertise:
SQL
•
DQL
•
Performance
•
Query optimization
Other Databases Services I Offer
FAQ
Do you need access to my database?
No. Send the query, the execution plan (EXPLAIN PLAN or DBMS_XPLAN output), table/index definitions and approximate row counts. Read-only access to a test copy helps but is not required. I never touch production.
Which Oracle versions do you work with?
I work mainly with Oracle Database SQL and PL/SQL in ERP environments, including Oracle EBS. Tell me your version and I will check whether any feature I suggest is available on it.
Can you guarantee a specific speed-up?
No honest developer can promise a number before seeing the plan and data. I show you the before/after plan and timings on your test data. If I cannot find a meaningful improvement, I will tell you before delivering.
Can you fix Oracle Forms or Reports bugs too?
Yes. I have long experience with Oracle Forms and Reports 6i/10g/11g/12c. Message me first so I can size the work.
Is my code kept confidential?
Yes. Your code and data are used only for your order. You can anonymize table names if you prefer.
