Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Execution plan sequence

ronald_2017Dec 6 2020 — edited Dec 6 2020

Hi All,

The following execution plan is excerpted from the following link.
https://jonathanlewis.wordpress.com/2010/12/10/quiz-night-10

I am just wondering what is the sequence of the following execution plan?

--------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
--------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 24 | 11 |
| 1 | SORT AGGREGATE | | 1 | 24 | |
|* 2 | HASH JOIN | | 70 | 1680 | 11 |
| 3 | TABLE ACCESS FULL | T4 | 70 | 420 | 2 |
|* 4 | HASH JOIN | | 70 | 1260 | 8 |
| 5 | TABLE ACCESS FULL | T3 | 70 | 420 | 2 |
|* 6 | HASH JOIN | | 70 | 840 | 5 |
| 7 | TABLE ACCESS FULL| T2 | 70 | 420 | 2 |
| 8 | TABLE ACCESS FULL| T1 | 70 | 420 | 2 |
--------------------------------------------------------------
Is the sequence below correct?
3-> 5 -> 7 -> 8 -> 6 -> 4 -> 2-> 1

First creates a hash table for T4, then creates a second hash table for T3 then creates a third hash table for T2 right?
If So, 3 hash tables has been built in the memory before joining the tables?
Also, the join order and the execution plan operation order are not the same right?

Thanks in advance
This post has been answered by Jonathan Lewis on Dec 6 2020
Jump to Answer

Comments

tschodt
user13732465 wrote:
I know after downloading a Java Applet from a server, the applet can only connect to the server where it is download. But what about accepting connections other than the server? Can Applet sit in a loop, listening to connections, and accept connections from outside world?
Did you try?
What happened?
831132
Not yet. I want to know technically it's possible or not, because of sandbox.
tschodt
Will the applet be signed?
User_64CKJ
See also "Can Java Applets(unsigned) Accept Incoming Connections " (http://forums.oracle.com/forums/thread.jspa?threadID=2158964).
darrylburke
Andrew Thompson wrote:
See also ...
Moderator action: user13732465, please don't double post the same question.

Moderator action: Deleted the other thread.

db
User_64CKJ
user13732465 wrote:
Not yet. I want to know technically it's possible or not, because of sandbox.
OK. On forums we typically expect the person asking the question (e.g. you), to do a bit of research rather than expect to be spoon-fed answers. But now that other matter of the double-post has been settled (thanks Darryl), this is getting painful.

An unsigned applet would not be able to 'accept incoming connections' from anything other than its home server.

But to probe this a little further, what is your exact use-case? I cannot think of anything where it would be logical for an applet to be communicating with anything but its own server. For example, a chat application would have all the Java applets sending their messages back to the server for distribution back out to the intended recipient of the message. And every applet could be sand-boxed.

So what (functionality) is it that you think requires an applet to accept arbitrary connections?
831132
Sorry for the double post. I should really hold my breath to wait for a simple answer like yes or no.

The question is related to download crossdomain.xml file and p2p applicaiton.

Edited by: user13732465 on Jan 17, 2011 9:03 PM
1 - 7

Post Details

Added on Dec 6 2020
6 comments
247 views