suggestion from Peter Scott<\/a> in a comment to the first blog.<\/p>\nOne more word on event 10132. I forgot to say before that Jonathan mentioned this event could be useful before a major upgrade. Should this event be set pre-upgrade and the upgrade changed execution plans for the worse, you would have some pretty useful information to help solve the problems.<\/p>\n","protected":false},"excerpt":{"rendered":"
Oracle support updated my sr to say, yes, we could use event 10132 for this purpose but\u00a0that it involves some overhead, however small, as well as the 12k disk space per statement (10g) that Jonathan Lewis had already highlighted to me. If that’s undesirable, we could also use v$sql_plan as I mentioned before. This was… Continue reading Monitoring Index Usage III – Support response<\/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-1033","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1031,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/21\/monitoring-index-usage-ii-event-10132\/","url_meta":{"origin":1033,"position":0},"title":"Monitoring Index Usage II – Event 10132","date":"July 21, 2006","format":false,"excerpt":"That's a shame.I was hoping that setting the event at the instance level might generate one trace file in the background_dump_dest but, like event 10046, it generates one trace file per session in user_dump_dest. I should have expected that, but I suppose my optimism blinded me.It doesn't make event 10132\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1030,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/21\/monitoring-index-usage\/","url_meta":{"origin":1033,"position":1},"title":"Monitoring Index Usage","date":"July 21, 2006","format":false,"excerpt":"A common requirement cropped up this week. A new Data Warehouse has just gone live and is still in the 'do we have the right indexes here' phase. In this case, the suspicion is that there are too many indexes in a specific schema and that a number of them\u2026","rel":"","context":"With 8 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1421,"url":"http:\/\/orcldoug.com\/blog\/2008\/06\/23\/northern-server-technology-day\/","url_meta":{"origin":1033,"position":2},"title":"Northern Server Technology Day","date":"June 23, 2008","format":false,"excerpt":"Last Thursday's Northern Server Technology Day organised by the UKOUG was one of the more enjoyable events I've attended. It helped that there were no hotels, driving or airports involved, just a simple walk to the train station, a 90 minute train journey (free wireless on hand) and a 10\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":851,"url":"http:\/\/orcldoug.com\/blog\/2006\/02\/28\/my-hotsos-agenda\/","url_meta":{"origin":1033,"position":3},"title":"My Hotsos Agenda","date":"February 28, 2006","format":false,"excerpt":"I'm a bit surprised how excited I am about going to Dallas for the Hotsos Symposium next week (have I mentioned it yet?). I've already worked my personal agenda out but it hasn't been easy with two streams of equally high quality presentations. The full schedule is here and here's\u2026","rel":"","context":"With 11 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1573,"url":"http:\/\/orcldoug.com\/blog\/2010\/03\/07\/hotsos-2010-day-0-cuddly-toy-carnage\/","url_meta":{"origin":1033,"position":4},"title":"Hotsos 2010 – Day 0 – Cuddly Toy Carnage","date":"March 7, 2010","format":false,"excerpt":"It's 4am on Sunday, so it must be America.This time I think I'm going with the Jonathan Lewis approach of sticking to GMT while I'm over here and accepting I'll be waking up at some ungodly hour which means I can get several hours work done before the day kicks\u2026","rel":"","context":"With 8 comments","img":{"alt_text":"","src":"\/serendipity\/uploads\/hotsos2010_boys1.jpg","width":350,"height":200},"classes":[]},{"id":1089,"url":"http:\/\/orcldoug.com\/blog\/2006\/09\/29\/miracle-dbf-day-1\/","url_meta":{"origin":1033,"position":5},"title":"Miracle DBF – Day 1","date":"September 29, 2006","format":false,"excerpt":"These Miracle guys (and girls) certainly know how to stage an event. My highlights of the last 24 hours includeSitting in the baby seats at the back of Mogens 7-seater, surrounded by everyone's luggage and some goat food, with Jonathan Lewis lording it at the front. Mogens has a really\u2026","rel":"","context":"With 1 comment","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1033","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=1033"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1033\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1033"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}