Another celebrity in the town!

Dan Hotka is a Training Specialist who has over 31 years in the computer industry and over 26 years of experience with Oracle products. He is an accepted member of the Oracle Ace group. He is an internationally recognized Oracle expert with Oracle experience dating back to the Oracle V4.0 days. Dan’s latest book is the TOAD Handbook by Pearson. He is also the author of SQL Developer Handbook by Oracle Press, SQL Developer Handbook by Oracle Press, Oracle9i Development By Example, and Oracle8i from Scratch by Que and has co-authored 7 other popular books including the Database Oracle10g Linux Administration by Oracle Press. He is frequently published in Oracle trade journals, and regularly speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com. Dan can be reached at [masked] .

Tools of the Trade: All the Free Tools from Oracle Corp

Dan has used a variety of SQL tuning tools thru the years. This presentation will include a live demonstration on various available tools from Oracle Corp…including SQL Developer, TKProf, Trace Analyzer, SQLXPlan, PL/SQL Profiler, and undocumented explain plan tools. This presentation is packed full of tips and techniques, including scripts that help find offending SQL statements.
Dan will cover these topics:
· SQL Developer
· SQL*Plus Autotrace
· SQL*Plus Explain Plan Scripts
· SQL*Plus undocumented Explain Plan features
· TKProf (Oracle Trace Facility with scripts)
· Oracle10g Trace Analyzer
· SQLXPlan (New Metalink tool)
· PL/SQL Profiler (with scripts)
· JSAnalyzer – a freeware trace file tool that runs TKProf and Trace Analyzer
· JSTuner – a freeware explain plan tool that shows the ‘where clause’ predicates, includes index stat information, hints, etc

As always beside of interesting discussions there will be beer and pizza ...

Sydney Oracle Meetup Organizer,

Yury