Deprecated: Assigning the return value of new by reference is deprecated in /home/jjonahha/public_html/oracle-internals/blog/wp-includes/cache.php on line 36

Deprecated: Assigning the return value of new by reference is deprecated in /home/jjonahha/public_html/oracle-internals/blog/wp-includes/query.php on line 21

Deprecated: Assigning the return value of new by reference is deprecated in /home/jjonahha/public_html/oracle-internals/blog/wp-includes/theme.php on line 540
Comments on: Advanced Query Optimization Question http://www.oracle-internals.com/?p=48 Taking a peek inside the box... Sun, 19 May 2013 23:56:38 +0000 http://wordpress.org/?v=2.3.1 By: Charles Schultz http://www.oracle-internals.com/?p=48#comment-1621 Charles Schultz Thu, 23 Apr 2009 21:14:13 +0000 http://www.oracle-internals.com/?p=48#comment-1621 Jonah, I found this thread quite interesting. As some who is hoping to learn more about internals, I would also love to see your "Life of a Query" presentation - particularly, to see to what level of detail you go to. =) You also mentioned a Shallahamer-like paper. I would love to see something like that as well. I love when theory collides with reality and we mere humans get something we can sink our teeth into. Thanks for your contributions, Jonah,

I found this thread quite interesting. As some who is hoping to learn more about internals, I would also love to see your “Life of a Query” presentation - particularly, to see to what level of detail you go to. =)

You also mentioned a Shallahamer-like paper. I would love to see something like that as well. I love when theory collides with reality and we mere humans get something we can sink our teeth into.

Thanks for your contributions,

]]> By: jonah.harris http://www.oracle-internals.com/?p=48#comment-1527 jonah.harris Tue, 03 Mar 2009 01:50:37 +0000 http://www.oracle-internals.com/?p=48#comment-1527 Kevin, Agreed that you have an endless supply of detailed Exadata blog postings :) In fact, that was my initial source of information. I was just wondering on that particular aspect: does it just pass the QEP nodes to the storage server? -Jonah Kevin,

Agreed that you have an endless supply of detailed Exadata blog postings :) In fact, that was my initial source of information.

I was just wondering on that particular aspect: does it just pass the QEP nodes to the storage server?

-Jonah

]]> By: Kevin http://www.oracle-internals.com/?p=48#comment-1526 Kevin Tue, 03 Mar 2009 01:44:56 +0000 http://www.oracle-internals.com/?p=48#comment-1526 "Care to share more insight?" ...uh, I have how many blog posts on exadata ? :-) “Care to share more insight?”

…uh, I have how many blog posts on exadata ? :-)

]]> By: jonah.harris http://www.oracle-internals.com/?p=48#comment-1525 jonah.harris Mon, 02 Mar 2009 22:30:41 +0000 http://www.oracle-internals.com/?p=48#comment-1525 Hey Kevin, Thanks for checking out my blog. To answer your question, for those I talked to, I'm pretty sure they got it. However, it does seem that the majority of people I talk to seem to think the database is chopping the SQL predicate text out of the query and sending it directly to the storage server. Personally, I think it's just a case of people not understanding query optimization and execution plans below the level of EXPLAIN PLAN. Many people don't realize that the QEP contains actual nodes and that those nodes could be rewritten (as performed by the MSQ and KKFS subsystems) or shipped elsewhere (such as in parallel execution and certain RAC cases). Of course, having never seen the source and having reviewed the Exadata architecture for no more than a day or so myself, I may be wrong. For all I know, Oracle may be generating some SQL-ish statement from the storage predicate nodes like it does for distributed queries, but I doubt it. Care to share more insight? -Jonah Hey Kevin,

Thanks for checking out my blog.

To answer your question, for those I talked to, I’m pretty sure they got it. However, it does seem that the majority of people I talk to seem to think the database is chopping the SQL predicate text out of the query and sending it directly to the storage server.

Personally, I think it’s just a case of people not understanding query optimization and execution plans below the level of EXPLAIN PLAN. Many people don’t realize that the QEP contains actual nodes and that those nodes could be rewritten (as performed by the MSQ and KKFS subsystems) or shipped elsewhere (such as in parallel execution and certain RAC cases).

Of course, having never seen the source and having reviewed the Exadata architecture for no more than a day or so myself, I may be wrong. For all I know, Oracle may be generating some SQL-ish statement from the storage predicate nodes like it does for distributed queries, but I doubt it. Care to share more insight?

-Jonah

]]> By: Kevin http://www.oracle-internals.com/?p=48#comment-1524 Kevin Mon, 02 Mar 2009 22:01:32 +0000 http://www.oracle-internals.com/?p=48#comment-1524 "After the session, I had a few discussions with people regarding the Exadata architecture and the method by which Oracle Database is able to distribute nodes of a query execution plan directly to the storage server for local processing." ..is this still a source of confusion? “After the session, I had a few discussions with people regarding the Exadata architecture and the method by which Oracle Database is able to distribute nodes of a query execution plan directly to the storage server for local processing.”

..is this still a source of confusion?

]]> By: jonah.harris http://www.oracle-internals.com/?p=48#comment-1523 jonah.harris Mon, 02 Mar 2009 13:47:42 +0000 http://www.oracle-internals.com/?p=48#comment-1523 Hey Mathew, Yes, the Life of a Query/Life of an Oracle Query presentation will be up soon. I have two versions of it, one that I did awhile ago and another which I did the night before the presentation. I prefer the newest one, but it's a bit ugly and needs to be cleaned up a little. -Jonah Hey Mathew,

Yes, the Life of a Query/Life of an Oracle Query presentation will be up soon. I have two versions of it, one that I did awhile ago and another which I did the night before the presentation. I prefer the newest one, but it’s a bit ugly and needs to be cleaned up a little.

-Jonah

]]> By: Mathew Butler http://www.oracle-internals.com/?p=48#comment-1519 Mathew Butler Mon, 02 Mar 2009 10:06:29 +0000 http://www.oracle-internals.com/?p=48#comment-1519 Hi Jonah, Any plans to publish a link to your presentation? It sounds interesting. Best Regards, Mathew Butler Hi Jonah,

Any plans to publish a link to your presentation? It sounds interesting.

Best Regards,

Mathew Butler

]]>