{"id":951,"date":"2005-08-19T12:00:00","date_gmt":"2005-08-19T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=951"},"modified":"2005-08-19T12:00:00","modified_gmt":"2005-08-19T12:00:00","slug":"px-article-and-select-magazine","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2005\/08\/19\/px-article-and-select-magazine\/","title":{"rendered":"PX article and Select magazine"},"content":{"rendered":"<p>Good news from Select (the IOUG magazine). I mentioned a couple of postings go that they\ufffdd printed an incorrect version of the PX article. Jonathan Lewis suggested that I should contact them to make sure a correction was printed. Although the next issue is already in layout (only just after I received the current issue) they\ufffdre going to include the following correction.<\/p>\n<p>&#8220;Correction: The article &#8220;Tuning Parallel Execution&#8221; by Doug Burns, published in Q3, 2005 has some incorrect information regarding parallel queries against partitioned tables. The author has updated the article and is available at <a href=\"http:\/\/oracledoug.com\/px.pdf\">http:\/\/oracledoug.com\/px.pdf<\/a> for the readers.&#8221;<\/p>\n<p>I plan to post a detailed list of all the changes that were made, but it\ufffdll take me a little while to put together because many comments came from several sources and some of the changes were subtle.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Good news from Select (the IOUG magazine). I mentioned a couple of postings go that they\ufffdd printed an incorrect version of the PX article. Jonathan Lewis suggested that I should contact them to make sure a correction was printed. Although the next issue is already in layout (only just after I received the current issue)&hellip; <a class=\"more-link\" href=\"http:\/\/orcldoug.com\/blog\/2005\/08\/19\/px-article-and-select-magazine\/\">Continue reading <span class=\"screen-reader-text\">PX article and Select magazine<\/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-951","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":949,"url":"http:\/\/orcldoug.com\/blog\/2005\/08\/21\/px-article-and-select-magazine-part-2\/","url_meta":{"origin":951,"position":0},"title":"PX article and Select magazine (part 2)","date":"August 21, 2005","format":false,"excerpt":"I've uploaded a document outlining the changes between the various online versions of the px article and the one published in Select Journal. It's available as a PDF or Word document. I've also asked the editors if they would include a link to this document in the next edition of\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1319,"url":"http:\/\/orcldoug.com\/blog\/2007\/09\/23\/parallel-query-and-11g\/","url_meta":{"origin":951,"position":1},"title":"Parallel Query and 11g","date":"September 23, 2007","format":false,"excerpt":"I've been playing around with 11g on and off this week, re-running some of the tests in this document (PDF file).The main edits required to the scripts were simple ones to correct the locations of trace files, for example (where $ORACLE_BASE is \/ora on the 10g system) rm \/ora\/admin\/TEST1020\/udump\/*.trc and\u2026","rel":"","context":"With 7 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":951,"position":2},"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":846,"url":"http:\/\/orcldoug.com\/blog\/2006\/03\/06\/tuning-and-tracing-parallel-execution-an-introduction\/","url_meta":{"origin":951,"position":3},"title":"Tuning and Tracing Parallel Execution : An Introduction","date":"March 6, 2006","format":false,"excerpt":"That's the title of my first presentation at 9:45 on Tuesday morning - tomorrow. I thought I'd write a brief blog about the presentation to help any Hotsos attendees decide if you want to attend.The first thing to say is that this is the presentation I've given previously at UKOUG\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":958,"url":"http:\/\/orcldoug.com\/blog\/2005\/08\/08\/the-internet\/","url_meta":{"origin":951,"position":4},"title":"The Internet","date":"August 8, 2005","format":false,"excerpt":"I know this isn't a breathtakingly original sentiment, but the new styles of communication facilitated by the Internet throw up new situations, or are they just the same old human quirks magnified? I've come across a few examples recently.On the down-side, there have been a few times when I've felt\u2026","rel":"","context":"With 13 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":976,"url":"http:\/\/orcldoug.com\/blog\/2005\/05\/29\/px-slave-trace-files\/","url_meta":{"origin":951,"position":5},"title":"PX Slave Trace Files","date":"May 29, 2005","format":false,"excerpt":"It's sad that it takes a Bank Holiday weekend for me to get round to doing some more research on parallel execution. Anyway, I was on the verge of modifying the following line from the PX paper ...The trace files for the slave processes may be created in background_dump_dest, rather\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/951","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=951"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/951\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=951"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}