{"id":1508,"date":"2009-07-21T12:00:00","date_gmt":"2009-07-21T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1508"},"modified":"2009-07-21T12:00:00","modified_gmt":"2009-07-21T12:00:00","slug":"the-best-oracle-parallel-execution-paper","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2009\/07\/21\/the-best-oracle-parallel-execution-paper\/","title":{"rendered":"The Best Oracle Parallel Execution Paper"},"content":{"rendered":"

I’d already made a note to read and blog about Greg Rahn’s Parallel Execution over RAC<\/a> blog post which is excellent, as usual, but Jonathan Lewis beat me to it<\/a> 😉 What struck me when I eventually took the time to read it, though, was the link in his post to an Oracle White Paper (PDF) on Parallel Execution<\/a> which I hadn’t seen, despite it being published last year? When Oracle do get round to publishing White Papers expanding on the documentation, I typically find them superior to a lot of community efforts (much as the documentation is still usually my first port of call). This is no exception.<\/p>\n

It’s terrific stuff because it combines more technical rigour than my own papers based on my own experience with several statements that reflect my real world experience very well. Or, to put it another way, it’s technically sound and detailed but never loses sight of the day to day problems that people face. I could have picked out tons of quotes from it, but here are a couple …<\/p>\n

“Do not use a single 1 TB disk for your 800 GB database, because you will not get good performance running operations in parallel against the database; this might work well for your single-user home video archive, but not for a database leveraging parallel query with multiple users.”<\/p><\/blockquote>\n

<\/p>\n

“The internal code rewrite introduced with Oracle Database 10g lifted a number of parallel execution restrictions that existed in Oracle Database 9i. As a result you might see that some operations that were running in serial are now executed in parallel when you use parallel settings at the table level. This may be great for the execution time of these operations that did not run in parallel before, but it also means that the system will end up using a lot more parallel resources than it used to.”<\/p><\/blockquote>\n

Whilst I don’t need<\/em> an Oracle White Paper to confirm what I’ve seen in the field, it’s nice when it does. Oh, and I’ll say nothing about what it has to say about parallel_adaptive_multi_user 😉 other than to say I think it’s clearer than anything I’ve seen coming out of Oracle in saying it might not always be a good thing<\/p>\n

So, yes, it’s better than anything I’ve written on the subject but the unfortunate side-effect is that my plans to update the PX papers very soon can be delayed 😉 Actually, I wish<\/em> they could, but as I’ve just had two abstracts accepted for UKOUG 2009, one of which is titled ‘More Parallel Fun’ it might be clear that <\/p>\n

a) I was thinking about and have been doing more PX work anyway; and
b) I can’t get out of it now 😉<\/p>\n

Seriously, that paper might be quite long, but it’s well worth your time reading it if you’re remotely interested in the subject. Oh, but if you’re going to print it out to read it, make sure it’s a colour printer! The use of colour is effective if you know about it in advance 😉<\/p>\n

P.S. One more thing. It’s yet another good paper to come out of Oracle that could have done with one more proof reading (spelling here and there), but I am enormously picky at times – usually with other people’s stuff!<\/p>\n","protected":false},"excerpt":{"rendered":"

I’d already made a note to read and blog about Greg Rahn’s Parallel Execution over RAC blog post which is excellent, as usual, but Jonathan Lewis beat me to it 😉 What struck me when I eventually took the time to read it, though, was the link in his post to an Oracle White Paper… Continue reading The Best Oracle Parallel Execution Paper<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1508","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1333,"url":"http:\/\/orcldoug.com\/blog\/2007\/10\/29\/parallel-tidbits\/","url_meta":{"origin":1508,"position":0},"title":"Parallel Tidbits","date":"October 29, 2007","format":false,"excerpt":"A couple of small things I noticed recently. The first was a mention of the presence of Bloom Filters in PX plans over on Greg Rahn's blog, another one that I picked up through OraNA which looks very interesting. Greg's looking for ideas for performance related blogs at the moment,\u2026","rel":"","context":"With 1 comment","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1320,"url":"http:\/\/orcldoug.com\/blog\/2007\/09\/23\/parallel-query-and-11g-part-2\/","url_meta":{"origin":1508,"position":1},"title":"Parallel Query and 11g – Part 2","date":"September 23, 2007","format":false,"excerpt":"Now, that's weird. A little surprising might be more accurate and maybe I'm missing something.During the various tests with and without parallel hints and different parallel_io_cap_enabled settings, I expected the runs that didn't use parallelism to show up \"db file scattered read\" events in the trace files. For example, here's\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1691,"url":"http:\/\/orcldoug.com\/blog\/2012\/10\/14\/parallel-dml-and-odp-net\/","url_meta":{"origin":1508,"position":2},"title":"Parallel DML and ODP.Net","date":"October 14, 2012","format":false,"excerpt":"I've been doing a lot of work around large volume data loads into an Oracle 11.2 database recently using External Tables and Parallelism and, despite the fact it's all used well-known techniques, I think it's probably worth a couple of posts to re-emphasise how successful using the right tools for\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1112,"url":"http:\/\/orcldoug.com\/blog\/2009\/10\/29\/10g-consolidated-trace-files-and-px\/","url_meta":{"origin":1508,"position":3},"title":"10g Consolidated Trace Files and PX","date":"October 29, 2009","format":false,"excerpt":"At the end of my Tracing Parallel Execution presentation at the Scottish OUG conference, Michael M\u00f8ller of Miracle asked whether the consolidated trace files produced by the DBMS_MONITOR package and trcsess utility are in strict time order. i.e. Will I see the actions of the query coordinator, then the actions\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1515,"url":"http:\/\/orcldoug.com\/blog\/2009\/09\/01\/11-2-release\/","url_meta":{"origin":1508,"position":4},"title":"11.2 Release","date":"September 1, 2009","format":false,"excerpt":"Some features in this post require a Diagnostics Pack license. I noticed my Netvibes home page light up today with the release of 11.2 on OTN (Greg's is just one of a bunch of posts) - official home page here.More important to me was the documentation and there were two\u2026","rel":"","context":"With 27 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1044,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/04\/tracing-session-activity-over-a-remote-database-link\/","url_meta":{"origin":1508,"position":5},"title":"Tracing session activity over a remote database link","date":"August 4, 2006","format":false,"excerpt":"Yesterday someone asked me how to trace a session that selects from a view in a remote database via a link. If they activated the trace on the local instance, they wouldn't see the bulk of the work which was happening on the remote instance - just a bunch of\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1508"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1508\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1508"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}