tag:blogger.com,1999:blog-518481768015386858.post7079468655538913206..comments2023-08-06T04:28:52.092-04:00Comments on Karen Morton: Weekly posts - Anyone got any ideas?Karenhttp://www.blogger.com/profile/03309823327597536648noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-518481768015386858.post-62867292434226971252014-06-04T22:31:43.014-04:002014-06-04T22:31:43.014-04:00Heck how about some favorite cookie recipes! ;)
...Heck how about some favorite cookie recipes! ;)<br /><br />Really like to hear your views on the new Adaptive Query Optimization in 12c. This is really going to be a game changer for us all. <br /><br />- Ric Ric Van Dykehttps://www.blogger.com/profile/13372723714711916938noreply@blogger.comtag:blogger.com,1999:blog-518481768015386858.post-45172497045740253322014-06-04T12:28:56.400-04:002014-06-04T12:28:56.400-04:00I learn a lot from your blogs and webinars. I like...I learn a lot from your blogs and webinars. I like to see blogs on performance, SQL tuning (including basics), current trends in the data industry, design, maintaining databases behind third party products, etc. Thanks.Veehttps://www.blogger.com/profile/12136488060520372185noreply@blogger.comtag:blogger.com,1999:blog-518481768015386858.post-71821924096929999722014-05-30T12:50:30.567-04:002014-05-30T12:50:30.567-04:00I've got a list started and will get geared up...I've got a list started and will get geared up and start regular posts in a couple of weeks once I get back from Enkitec's E4 conference. Thanks for the ideas everyone (and thanks for the poem Joel)! Karenhttps://www.blogger.com/profile/03309823327597536648noreply@blogger.comtag:blogger.com,1999:blog-518481768015386858.post-72907491106739877952014-05-30T09:41:43.200-04:002014-05-30T09:41:43.200-04:00I am subscribed to your RSS feed, and welcome your...I am subscribed to your RSS feed, and welcome your plan to make more regular posts.<br /><br />As a DBA I regularly get a SQL statement with a 100-200 line plan and am asked why it is going slow. It is generally rewritten, but I feel I should be able to look at the plan, find the part using the most resources and write a test SQL that replicates that part of the plan (Divide and conquer). It is the last part (Changing a part of a plan back into SQL) that I would welcome guidance on, unless you think that strategy is flawed.<br /><br />But to be honest, whatever you say will be of value to me.Unknownhttps://www.blogger.com/profile/07456539326727358991noreply@blogger.comtag:blogger.com,1999:blog-518481768015386858.post-38281875574706548542014-05-28T17:00:30.894-04:002014-05-28T17:00:30.894-04:00As Robert Plant screams, "Ramble on!"
H...As Robert Plant screams, "Ramble on!"<br /><br />How years ago in days of old<br />When magic filled the air,<br />'Twas in the darkest depths of Morton<br />I met a girl so fair.Joel Garryhttps://www.blogger.com/profile/13325061229393838224noreply@blogger.comtag:blogger.com,1999:blog-518481768015386858.post-50169174618332154562014-05-28T14:39:58.774-04:002014-05-28T14:39:58.774-04:00Hi Karen -
Good to hear you will be back to blogg...Hi Karen -<br /><br />Good to hear you will be back to blogging regularly again! For ideas, how about the less used pieces of DBMS_STATS.. like extended stats or diff_table_stats functions, etc? Look forward to whatever you decide on!<br /><br />Craig Craig Martinhttps://www.blogger.com/profile/01210939485432835552noreply@blogger.comtag:blogger.com,1999:blog-518481768015386858.post-29863681450879145642014-05-28T14:33:01.752-04:002014-05-28T14:33:01.752-04:00Your recent webinar on anti patterns was good, esp...Your recent webinar on anti patterns was good, especially the discussion on min/max and how the optimizer deals/doesn't deal with that request. Those types of things are great.<br /><br />I'd also like a detailed example of how you might use 10046 trace data to diagnose a problem and how that data tells guides you on fixing the SQL. <br /><br />Lastly, anything you've got on choosing the right data structures for good performance (i.e. IOT, partitioning), I'd assume this would lead to further discussions on stats and indexing schemes as well.Tonyhttps://www.blogger.com/profile/12184354575866057215noreply@blogger.com