Closed

Oracle distributed query optimization

Looking for tuning help on Oracle SQL block. I have written the query myself and it works fine. I just want it to execute more efficiently and hopefully faster.

1. Query is 4500 lines, but it is composed of about 25 shorter and similar blocks.

2. It currently is executed in the scheduler as a stored procedure

3. Query updates tables on one schema, but all using “Merge” over a linked database where all the source tables exist.

a. It looks to the last 3 days of changed data.

4. There are no materialized view logs available nor can I create anything on the linked database.

5. I am unable to provide direct access to the databases or network

a. I will provide the SQL

b. For each table I can provide the number of rows in the table and any indexes

c. There are about 25 total tables and each is used multiple times

d. I can provide an approximation of how many rows the queries would result in

e. I cannot make any new indexes on the source database

f. I have little access to statistics or other things on the source database

6. Both databases are 12c Enterprise [login to view URL] and are 64bit

7. I suspect most of the optimization is going to come from hints in the queries and other ways of optimizing how best to manage the distributed nature of the query.

Skills: Database Administration, Database Development, Database Programming, Oracle, SQL

See more: oracle improve dblink performance, oracle driving_site hint insert, oracle driving_site hint multiple tables, dblink hint driving_site, oracle 11g dblink performance issues, oracle driving_site hint subquery, oracle dblink slow performance, how to use driving_site hint in oracle, looking for freelance oracle apex developers in south africa, looking for dba oracle, looking for a marketing company to help and market my b b in cape town, looking for a developer programmer job which has php java oracle postgres or mysql requirements, list of companies looking for oracle dba australia, im looking for oracle it, i am looking for a freelance oracle apex developer

About the Employer:
( 1 review ) West Bloomfield, United States

Project ID: #17134476

29 freelancers are bidding on average $184 for this job

truongnguyen86

Hello there, I’ve worked with so over 10k lines before, I think to tune this so we should go by each block, and if you can provide the cost for each block it will be good for tuning Relevant Skills and Experience Data More

$250 USD in 5 days
(165 Reviews)
6.6
muzzamilnoor

I am a software engineer with over 13 years of experience in varied technologies. My speciality is Oracle database and Application Express (Oracle Apex) development. I have worked on similar projects for my clients More

$111 USD in 10 days
(15 Reviews)
5.5
jagdishbhatt38

I am having more than 9 years of experience in sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utilizing my knowledge and skills.

$250 USD in 6 days
(28 Reviews)
4.8
dzdzegc

Had a lot of work with sql queries for reports for credit organizations, also used to optimize that.

$200 USD in 1 day
(6 Reviews)
3.1
donovan6

As an Oracle DBA/Developer with over 15 years experience, I should be able to help you with the optimization of this query.

$200 USD in 3 days
(1 Review)
2.1
pratik123

Hey hi let’s have quick discussion. I hope I could help you in this regards. After all performance tuning need lots of parameters to consider but I will try my best.

$200 USD in 3 days
(1 Review)
1.7
voronkov

Hello, I work with Oracle many years. I can advice these approaches: 1. Try to make copy of remote tables in your database, create indexes and collect statistic, after this update your tables, do not use MERGE. Clea More

$222 USD in 10 days
(1 Review)
0.8
adeeladeel1234

Hi Hope you doing Good I got your scenario , actually i have more than 10 years of Experience in SQL,PLSQL as well as oracle database Performance Tuning and SQL Optimization and Tuning .Please share your code and Fu More

$200 USD in 1 day
(2 Reviews)
0.7
challasuresh007

Hi, I am skilled and experienced in SQL ,PL/SQL Expert, I have more than 6.8 Years of experience in SQL ,PL/SQL and Application performance tuning I must give a better service than others ,Please fell free to c More

$155 USD in 3 days
(0 Reviews)
0.0
VISITNKS

I have 10 year of strong Oracle technical experience. I can suggest the best solution for your problematic sql.

$244 USD in 3 days
(0 Reviews)
0.0
vw8113236vw

Thanks for providing the information. I am new to this freelancer portal but have good real world working exposure. Would be great to get a opportunity to work together. Looking forward for your positive resp More

$155 USD in 3 days
(0 Reviews)
0.0
$222 USD in 5 days
(0 Reviews)
0.0
PMAKARM

• Implementing, support and maintaining Oracle Financial modules Account Receivables, Account Payable ,GL ,Inventory , Purchasing, Order Management , Purchasing and modules for R12 version. • Sharing in Oracle R12 up More

$30 USD in 1 day
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
$255 USD in 5 days
(0 Reviews)
0.0
$77 USD in 3 days
(0 Reviews)
0.0
vasanthsesumnit

with 10+ year experience in PLSQL performance tuning and optimization. The SQL can be tuning after verification, For taking over this project, I may need the current timings of PL/SQL run for each blocks and expl More

$133 USD in 3 days
(0 Reviews)
0.0
sumanthplsql

 Having around 4 Years of experience in IT industry as a Programmer (PL/SQL Developer) as well as production support engineer.  Experience in SQL and PL/SQL.  Experience in writing, Cursors, Joins, Exceptions, Sub More

$155 USD in 3 days
(0 Reviews)
0.0
mithlesh1984

I have 12 years experience as Oracle DBA. I have real time experience in RAC, Data Guard, Golden Gate and database & query tuning.

$155 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0