{"id":1590,"date":"2010-03-28T12:00:00","date_gmt":"2010-03-28T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1590"},"modified":"2010-03-28T12:00:00","modified_gmt":"2010-03-28T12:00:00","slug":"statistics-on-partitioned-tables-contents","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2010\/03\/28\/statistics-on-partitioned-tables-contents\/","title":{"rendered":"Statistics on Partitioned Tables – Contents"},"content":{"rendered":"

\nWhen Jonathan Lewis decided it was time to post a list of the Partition Stats posts<\/a> on his blog and Noons suggested I made them easier to track down<\/a>, I listened. So this post will link to the others and, at least in the short term, I’ve also included links in the side-bar on the right over there.<\/p>\n

Part
\n 1<\/a> – Default options – GLOBAL AND PARTITION
Part
\n 2<\/a> – Estimated Global Stats
Part
\n 3<\/a> – Stats Aggregation Problems I
Part
\n 4<\/a> – Stats Aggregation Problems II
Part
\n 5<\/a> – Minimal Stats Aggregation
Part 6a<\/a> – COPY_TABLE_STATS – Intro
Part 6b<\/a> – COPY_TABLE_STATS – Mistakes
Part 6c<\/a> – COPY_TABLE_STATS – Bugs and Patches
Part 6d<\/a> – COPY_TABLE_STATS – A Light-bulb Moment<\/p>\n

To be continued ….<\/p>\n

P.S. It was a lot easier doing this than actually finishing off Part 6 and I’m insanely busy at the moment.
P.P.S. My ultimate intention is to re-write the blog posts as a more considered, easier-to-read article but who knows when that might happen?<\/p>\n","protected":false},"excerpt":{"rendered":"

When Jonathan Lewis decided it was time to post a list of the Partition Stats posts on his blog and Noons suggested I made them easier to track down, I listened. So this post will link to the others and, at least in the short term, I’ve also included links in the side-bar on the… Continue reading Statistics on Partitioned Tables – Contents<\/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-1590","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1570,"url":"http:\/\/orcldoug.com\/blog\/2010\/02\/28\/statistics-on-partitioned-tables-part-5\/","url_meta":{"origin":1590,"position":0},"title":"Statistics on Partitioned Tables – Part 5","date":"February 28, 2010","format":false,"excerpt":"Actually, before looking at any recent features, let me introduce one more aspect of the existing aggregation approach used by Oracle. The examples used to date have been based on INSERTing new rows into subpartitions and, although that's the approach used for some of our tables and will suit some\u2026","rel":"","context":"With 18 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1568,"url":"http:\/\/orcldoug.com\/blog\/2010\/02\/28\/statistics-on-partitioned-tables-part-4\/","url_meta":{"origin":1590,"position":1},"title":"Statistics on Partitioned Tables – Part 4","date":"February 28, 2010","format":false,"excerpt":"In the last post I illustrated the problems you can run into when you rely on Oracle to aggregate statistics on partitions or subpartitions to generate estimated Global Statistics at higher levels of the table. Until there are statistics for all of the relevant structures then aggregation won't take place\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1673,"url":"http:\/\/orcldoug.com\/blog\/2012\/01\/17\/randolf-geist-on-11g-incremental-statistics\/","url_meta":{"origin":1590,"position":2},"title":"Randolf Geist on 11g Incremental Statistics","date":"January 17, 2012","format":false,"excerpt":"Well it wasn't the post I planned to return to technical matters with. Lots of readers here have asked me when I'm going to get round to writing about 11g Incremental Statistics as part of the stats series. Although Incrementals are on my To Do list, I wanted to finish\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1563,"url":"http:\/\/orcldoug.com\/blog\/2010\/02\/22\/statistics-on-partitioned-tables-part-2\/","url_meta":{"origin":1590,"position":3},"title":"Statistics on Partitioned Tables – Part 2","date":"February 22, 2010","format":false,"excerpt":"In the last part, I asked you to trust me that true Global Stats are a good thing so in this post I hope to show you why they are, to make sure you don't kid yourself that you can avoid them. (Updated later - this is all on 10.2.0.4)Why\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1616,"url":"http:\/\/orcldoug.com\/blog\/2010\/11\/03\/poor-performance-when-gathering-partitions-stats-in-11g\/","url_meta":{"origin":1590,"position":4},"title":"Poor performance when gathering partitions stats in 11g","date":"November 3, 2010","format":false,"excerpt":"Being busy at work is both a blessing and a curse to blogging activity. On the one hand, the more that's going on, the more technical issues there are likely to be to blog about. On the other, when the pace is frantic and problems are coming thick and fast,\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1596,"url":"http:\/\/orcldoug.com\/blog\/2010\/04\/22\/statistics-on-partitioned-tables-part-6a-copy_table_stats-intro\/","url_meta":{"origin":1590,"position":5},"title":"Statistics on Partitioned Tables – Part 6a – COPY_TABLE_STATS – Intro","date":"April 22, 2010","format":false,"excerpt":"[Phew. At last. The first draft of this was dated more than two weeks ago .... One of the problems with blogging about copying stats was the balance between explaining it and pointing out some of the problems I've encountered. So I've broken up this post, with a little explanation\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1590","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=1590"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1590\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1590"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1590"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}