{"id":967,"date":"2005-07-25T12:00:00","date_gmt":"2005-07-25T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=967"},"modified":"2005-07-25T12:00:00","modified_gmt":"2005-07-25T12:00:00","slug":"a-small-follow-up","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2005\/07\/25\/a-small-follow-up\/","title":{"rendered":"A small follow-up"},"content":{"rendered":"<p>From a previous blog entry :-<\/p>\n<p>&#8220;<em>&#8230; I noticed that the slave trace files are appearing in user_dump_dest. This is with 9.2.0.1.0 on Windows XP Home. I&#8217;m using 9.2 because I want to see the discrete SQL statements that the slaves are processing. <\/em><\/p>\n<p><em>So, just an interesting anomaly from what I&#8217;ve seen previously. I&#8217;ll check it out on other versions \/ OS in future.<\/em>&#8220;<\/p>\n<p>Well, I&#8217;ve just tried it on 10.1.0.4 on XP at home and the px slave trace files are appearing in background_dump_dest, as usual.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>From a previous blog entry :- &#8220;&#8230; I noticed that the slave trace files are appearing in user_dump_dest. This is with 9.2.0.1.0 on Windows XP Home. I&#8217;m using 9.2 because I want to see the discrete SQL statements that the slaves are processing. So, just an interesting anomaly from what I&#8217;ve seen previously. I&#8217;ll check&hellip; <a class=\"more-link\" href=\"http:\/\/orcldoug.com\/blog\/2005\/07\/25\/a-small-follow-up\/\">Continue reading <span class=\"screen-reader-text\">A small follow-up<\/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-967","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":976,"url":"http:\/\/orcldoug.com\/blog\/2005\/05\/29\/px-slave-trace-files\/","url_meta":{"origin":967,"position":0},"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":[]},{"id":1112,"url":"http:\/\/orcldoug.com\/blog\/2009\/10\/29\/10g-consolidated-trace-files-and-px\/","url_meta":{"origin":967,"position":1},"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":1697,"url":"http:\/\/orcldoug.com\/blog\/2013\/03\/11\/not-all-deadlocks-are-created-the-same\/","url_meta":{"origin":967,"position":2},"title":"Not all Deadlocks are created the same","date":"March 11, 2013","format":false,"excerpt":"I've blogged about deadlocks in Oracle at least once before. I said then that although the following message in deadlock trace files is usually true, it isn't always. The following deadlock is not an Oracle error. Deadlocks of\u00a0 this type can be expected if certain SQL statements are\u00a0\u00a0\u00a0\u00a0\u00a0 issued. The\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1701,"url":"http:\/\/orcldoug.com\/blog\/2013\/03\/18\/10053-trace-files-getting-started\/","url_meta":{"origin":967,"position":3},"title":"10053 Trace Files &#8211; Getting Started","date":"March 18, 2013","format":false,"excerpt":"Before getting into the contents of a 10053 trace file and looking at any useful stuff, you need to know what the files are for and how and where they are created. Essentially, setting event 10053 causes the Cost Based Optimizer to write information to a trace file describing the\u2026","rel":"","context":"With 5 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1699,"url":"http:\/\/orcldoug.com\/blog\/2013\/03\/17\/10053-trace-files\/","url_meta":{"origin":967,"position":4},"title":"10053 Trace Files","date":"March 17, 2013","format":false,"excerpt":"Sometimes I'm really not sure whether a blog post is a good idea or not. This is one of those times.I remember a while ago that Neil Chandler wrote a blog post about why you probably don't need 10046 trace files that I didn't completely agree with and I kept\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":883,"url":"http:\/\/orcldoug.com\/blog\/2006\/01\/15\/windows-orion-numbers\/","url_meta":{"origin":967,"position":5},"title":"Windows ORION Numbers","date":"January 15, 2006","format":false,"excerpt":"Prompted by Jeff Moss' blog, I decided to use ORION to measure the performance of various I\/O configurations I'm testing for the upcoming Hotsos presentation. I've already blogged about the Linux results on a couple of configurations but I'm still tempted to include a Windows Laptop test (although I haven't\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\/967","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=967"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/967\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=967"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}