I just found out that my alternate talk for the East Coast Oracle Users Conference is needed. So, I’ll be doing my Exadata talk on Wednesday and my Intro to SQL Tuning talk Thursday. This makes the conference even more fun for me since I’ll be busier making sure I do a good job on both talks.
Here is my schedule and links to the PowerPoint presentations:
Wednesday, October 17th, 1:15 pm-2:15 pm Exadata Distinctives
Thursday, October 18th, 11:30 am-12:30 pm Intro to SQL Tuning
If you are coming to the conference come check these out. They are both focused primarily on tuning. There is only a small overlap between the two. A couple of my SQL tuning examples come from Exadata systems.
– Bobby
I have used 12.1 dbms_stats.gather_table_stats (granularity=>’subpartition’, partname=> loop through all table subpartitions, to gather stats on all subpartitions first and noticed that it will gather partition stats at some point automatically as well. I then deleted all the stats a repeated the test but the t still did the same. There’s no documentation about that behaviour.
Dan,
Thanks for your comment. Did you mean to comment on the previous post?:
https://www.bobbydurrettdba.com/2012/10/09/subpartition-stats-quirks/
Bobby