The Easy way to read a SQL execution plan using Oracle SQL Developer Web

preview_player
Показать описание
We have a new SQL execution plan viewer in Oracle SQL Developer Web! In this tour the product manager will show you:

Table of Contents
2:28 generating a plan
6:10 navigating plans
10:48 viewing plan step details
12:15 seeing parallel degree execution information
15:09 accessing the built-in documentation/help

Links that Jeff promised you -

Blog post overview:

Jeff's video on installing ORDS and running SQL Developer Web

Maria's YouTube Series on Reading Execution Plans

Description of Parallel In-Out step labels in the Oracle Docs
Рекомендации по теме
Комментарии
Автор

Will this pretty interface be available for the desktop version?

joephendrix
Автор

Can I acces a database hosted in a local server?

josejaviermarticamarasa
Автор

It might be more intuitive but not very productive.. lot of wasted space results in scrolling/filtering/clicking. I know it’s not an easy task, but a more expert oriented view would be nice (and also easy offline import to view in suppor and consulting)

berndeckenfels
Автор

Oracle Database is a great product but why oracle do not improve it's tooling, SQL Developer needs alot of improvements, I am not saying rewrite an entire 15+ years just to make it prettier, but there is some functionalities that are important in the Developer, Architect, DBA day to day work that are not present, we keep herring 'Oracle is improving, oracle is making things better ...' well at least improve the main tool of your most valuable product

michelchaghoury
visit shbcf.ru