Thanks
Gordon Cameron, August 31, 2015 - 2:23 pm UTC
OK, that would explain what I'm seeing. For example:
SQL> explain plan for
2 select /*+ qb_name(q1) */ *
3 from
4 ( select /*+ qb_name(q2) */ *
5 from emp
6 );
Explained.
SQL> select * from table(dbms_xplan.display(null,null,'BASIC +ALIAS'));
PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
Plan hash value: 3956160932
----------------------------------
| Id | Operation | Name |
----------------------------------
| 0 | SELECT STATEMENT | |
| 1 | TABLE ACCESS FULL| EMP |
----------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$D8208F20 / EMP@Q2
Long Absence
Fahd Bahoo, September 01, 2015 - 8:14 am UTC
Hi tom,
Where where you Tom waited for you for 8 months.
Such a long absence ?
Will you be replying now a day?
Last Update Datetime(Home Page)
Shimmy, September 15, 2015 - 12:56 pm UTC
Why is the last update datetime on whole bunch of Q&A have yesterday's date(eg: "Last updated: September 15, 2015 - 2:18 am UTC") and when you click the link/detail, you don't see any new update from yesterday.
September 15, 2015 - 6:51 pm UTC
We just added the feature to display who answered the question. This required us to go back through the recent qs and update them to say whether it was Connor or me who answered. Hence the update dates :)
Thanks
Gordon Cameron, September 25, 2015 - 1:03 am UTC
Thanks for the clarification on query block names. Even with transformation, I still think they are quite useful.
September 25, 2015 - 1:04 am UTC
I Agree.