Kerry Osborne's Oracle Blog
Oracle Support Sanctions Manually Created SQL Profiles!
July 24, 2010 3:00pm
I originally titled this post: “SQLT - coe_xfr_sql_profile.sql” Catchy title huh? - (that’s why I changed it) I’ve been promoting the use of SQL Profiles as a plan control mechanism for some time. The basic idea is to use the undocumented procedure dbms_sqltune.import_sql_profile to build a set of hints to be applied behind the scenes via ...Read More
Writing Some Chapters in a Book
July 11, 2010 8:49pm
My friend Karen Morton asked if I would be willing to contribute to a book that she is working on (i.e. write a few chapters). Of course I said yes. The book’s title is Pro Oracle SQL and it is to be published by Apress sometime before the end of the year (my first deadline ...Read More
Exadata and Parallel Queuing
July 7, 2010 10:31pm
Over the years Oracle has added many enhancements in order to allow individual SQL statements to take full advantage of multiprocessor computers. A few months ago Cary Millsap did a talk where he recalled the presentation Larry Ellison did when Oracle first announced the Parallel Query feature. During Larry’s demo he had a multiprocessor computer ...Read More
Exadata Offload - The Secret Sauce
June 15, 2010 11:12pm
The “Secret Sauce” for Exadata is it’s ability to offload processing to the storage tier. Offloading means that the storage servers can apply predicate filters at the storage layer, instead of shipping every possible block back to the database server(s). Another thing that happens with offloading is that the volume of data returned can be ...Read More
Oracle Exadata Delivery Day
May 25, 2010 9:25pm
Well our new Exadata showed up this week. We had a pretty nice lab environment already. A bunch of Dell’s, some IBM’s, several Sun’s. We have a couple of EMC Sans as well (we actually threw away a whole EMC rack to make room for the Exadata). And of course we have every version of ...Read More
