If you're not familiar with the Oracle Live SQL environment, then you should definitely try it. I wrote a blog some time ago on what it is and how to work with execution plans there. Here I will provide an overview of some of the new features added since that time. Let's start with the interface. In the earlier release it was impossible to select and execute only one query among others. Now you can do just that. You are now able to select a query from the list and push the "Run" button:
![](https://www.pythian.com/hs-fs/hubfs/Imported_Blog_Media/Screen-Shot-2018-09-05-at-1_07_30-PM.png?width=1254&height=686&name=Screen-Shot-2018-09-05-at-1_07_30-PM.png)
create table t1 as select rownum id, rpad('x',50,'x') str from dual connect by level <10001;
Run the "explain plan for" statement for the query we want to check.
explain plan for select /*+ gather_plan_statistics */ id from t1 where str='y';
select * from table(dbms_xplan.display(format=>'ALL'));
![](https://www.pythian.com/hs-fs/hubfs/Imported_Blog_Media/Screen-Shot-2018-09-05-at-1_17_44-PM.png?width=1692&height=1084&name=Screen-Shot-2018-09-05-at-1_17_44-PM.png)
![](https://www.pythian.com/hs-fs/hubfs/Imported_Blog_Media/Screen-Shot-2018-09-05-at-1_25_39-PM.png?width=2164&height=1260&name=Screen-Shot-2018-09-05-at-1_25_39-PM.png)
![](https://www.pythian.com/hs-fs/hubfs/Imported_Blog_Media/Screen-Shot-2018-09-05-at-1_33_35-PM.png?width=1788&height=870&name=Screen-Shot-2018-09-05-at-1_33_35-PM.png)
![](https://www.pythian.com/hs-fs/hubfs/Imported_Blog_Media/Screen-Shot-2018-09-05-at-1_34_58-PM.png?width=1874&height=718&name=Screen-Shot-2018-09-05-at-1_34_58-PM.png)
Share this
You May Also Like
These Related Stories
Oracle E-Business Suite: Virtual host names
Oracle E-Business Suite: Virtual host names
Oct 6, 2015
1
min read
OEM 13c Monitoring Features - Part 2, Extended Metrics
OEM 13c Monitoring Features - Part 2, Extended Metrics
Jan 14, 2020
7
min read
OEM 13c Monitoring Features - Part 4, Corrective Actions
OEM 13c Monitoring Features - Part 4, Corrective Actions
Jan 21, 2020
8
min read
No Comments Yet
Let us know what you think