10gR2 new features<\/a> article, which had been in a small collection for me to get through after I’d finished the paper. The very first thing in the article is that 10gR2 sqlplus autotrace displays the new style of execution plan. Marvellous.<\/p>\nSo I downloaded release 2, updated my laptop (which was all very smooth and straightforward), reran the examples and nice new execution plans were displayed. Unfortunately they are *much* wider than the traditional style. I know that’s completely obvious and it had never been a problem when using them in the past, but when you’re trying to keep the formatting nice, it doesn’t help.<\/p>\n
I’m still thinking about this.<\/p>\n","protected":false},"excerpt":{"rendered":"
When I was putting the finishing touches to the CASE paper, Andy Campbell (one of the reviewers) pointed out that he preferred the DBMS_XPLAN output when looking at execution plans for SQL statements. I do too, but I wanted to use Autotrace, partly for consistency with the original DECODE paper, partly because I don\ufffdt like… Continue reading DBMS_XPLAN, 10gR2 Autotrace and the CASE 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-925","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":882,"url":"http:\/\/orcldoug.com\/blog\/2006\/01\/15\/jonathan-lewis-on-10gr2-sort-efficiency\/","url_meta":{"origin":925,"position":0},"title":"Jonathan Lewis on 10gR2 Sort efficiency","date":"January 15, 2006","format":false,"excerpt":"Just in case you miss it ... Jonathan has an interesting new piece on sort efficiency in 10gR2.What struck me on reading this is that, no matter how mature the CBO may be, small improvements are constant. That tells me that it's a mistake to rely on an optimiser to\u2026","rel":"","context":"With 1 comment","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":895,"url":"http:\/\/orcldoug.com\/blog\/2005\/12\/07\/oracle-enterprise-manager-10gr2\/","url_meta":{"origin":925,"position":1},"title":"Oracle Enterprise Manager 10gR2","date":"December 7, 2005","format":false,"excerpt":"First of all, let me be clear that I'm not a fan of GUI tools. That's not based on a misguided macho opinion that somehow you need to be able to struggle with a command line interface to prove that you're a good DBA but because :- I'm a contractor\u2026","rel":"","context":"With 9 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1102,"url":"http:\/\/orcldoug.com\/blog\/2006\/10\/08\/10gr2-on-solaris-10\/","url_meta":{"origin":925,"position":2},"title":"10gR2 on Solaris 10","date":"October 8, 2006","format":false,"excerpt":"I was surprised to realise that it's nearly 7 months since I bemoaned the lack of availability of 10gR2 on Solaris 10 (x86). Well, it's been out a few weeks now and I've been waiting since then for a free weekend to install it on the ISP4400. One of the\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1101,"url":"http:\/\/orcldoug.com\/blog\/2006\/10\/07\/supporting-scotland\/","url_meta":{"origin":925,"position":3},"title":"Supporting Scotland","date":"October 7, 2006","format":false,"excerpt":"I've spent all morning installing Solaris 10 and Oracle 10gR2 on the ISP4400 and configured my first ZFS filesystem. I'll blog about that later, but I had to get this one out of the way before Scotland play France at football at five o'clock.This is from an interview with Walter\u2026","rel":"","context":"With 8 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1122,"url":"http:\/\/orcldoug.com\/blog\/2006\/11\/06\/ukoug-agenda-2\/","url_meta":{"origin":925,"position":4},"title":"UKOUG Agenda","date":"November 6, 2006","format":false,"excerpt":"Another late shift today followed a busy weekend attending an evening wedding reception on Friday and a friend's 40th birthday party in Newcastle on Saturday night, so that closing part of the Recovery Design series might have to wait for a day or two. I'm also in a growing panic\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1496,"url":"http:\/\/orcldoug.com\/blog\/2009\/05\/07\/adaptive-thresholds-in-10g-part-1-metric-baselines\/","url_meta":{"origin":925,"position":5},"title":"Adaptive Thresholds in 10g – Part 1 (Metric Baselines)","date":"May 7, 2009","format":false,"excerpt":"Some features in this post require a Diagnostics Pack license.[I really didn't want to get into another multi-part blog post, but this has grown longer than I hoped, so I'll split it up ...]One of the more interesting components of the 10gR2 instrumentation improvements is the use of Metric Baselines\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/18.133.199.212\/wp-content\/uploads\/recovered\/oem1.JPG?resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/925","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=925"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/925\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=925"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=925"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}