Thanks!
ravi B, November 11, 2015 - 1:30 am UTC
Thanks!
Will be available?
Duke Ganote, November 27, 2017 - 3:59 pm UTC
It was a pleasant surprise to log into liveSQL today and get the explain plan (below); any chance we can get actuals?
explain plan for select * from scott.emp;
select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
Plan hash value: 3956160932
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 14 | 532 | 3 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| EMP | 14 | 532 | 3 (0)| 00:00:01 |
--------------------------------------------------------------------------
November 27, 2017 - 5:09 pm UTC
lack privileges to run dbms_xplan
Jim Dickson, July 26, 2018 - 10:05 am UTC
Chris
In current version of Live Oracle SQL, when using you test code, I get following error:
PLAN_TABLE_OUTPUT
User has no SELECT privilege on V$SQL
Can you please confirm you get the same - or is there a way to workaround this issue?
jim