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

свернуть