In February's session, Chris looked at options for tuning distributed queries; aka those using database links.
Highlights include:
06:10 - Challenges with getting the execution plan for distributed queries
08:00 - How to get execution details for the queries run on the remote DBs
15:00 - How to minimize network roundtrips to improve DB link queries:
17:10 - The driving_site hint
21:50 - Use the no_merge hint to ensure joins happen remotely
25:00 - Remove the network from the equation by using materialized views
27:30 - Demo of how to diagnose and tune a distributed query
37:25 - Recap of process for diagnosing and tuning database link queries
[ Ссылка ]
[ Ссылка ]
AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.
[ Ссылка ]
Oracle Developers portal: [ Ссылка ]
Sign up for an Oracle Cloud trial: [ Ссылка ]
#sql #distributed
![](https://s2.save4k.ru/pic/rDxYO6QQfsI/maxresdefault.jpg)