Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: OCP - Hotsos SQL Optimization
The Hotsos SQL Optimization course is worthwhile - their SQL test
harness includes statistical snapshots along with 10046 and 10053 event
traces. Also, the class SQL examples demonstrate many cost based
optimization issues along with encouraging scientific experimentation.
The SQL test harness is open source so class attendees can install and
modify the harness on their own databases (provided CD includes the SQL
test harness and class examples).
Looking forward to SQL test harness improvements (possibly a forum on
the Hotsos web site) and returning to this course at the alumni rate
(bit easier on my wallet).
A "disadvatage" of the Hotsos SQL test harness is the additional DBA work involved in setting up unit testing databases so developers can experiment on their own (including bouncing their database to see the optimizer mode differences for a SQL statement).
Note: I can share a wish with my employer for this course to be brought on-site for developers and DBA's.
Have Fun :)
>A hotsos course, just because I have heard of and respected the papers of the man known as Cary Millsap since I first heard of Oracle.
>
>
>If your employer were willing to pay for some good training gig this year, what would you ask for?
>
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Apr 23 2004 - 00:16:54 CDT
![]() |
![]() |