United Kingdom
France
Germany
Netherlands
Sweden
USA
Italy
Spain
More From Contributor
Oracle: Advanced SQL Tuning Tips And Techniques With Dan Hotka
The course starts out with a complete overview of the Oracle architecture so students can get an understanding how their SQL and applications can take advantage of the computing environment. This seminar goes into detail on how Oracle arrives at
Product Description
The course starts out with a complete overview of the Oracle architecture so students can get an understanding how their SQL & applications can take advantage of the computing environment. This seminar goes into detail on how Oracle arrives at an execution plan, the explain plan.
Dan illustrates various coding techniques that insure the SQL runs at maximum performance in the current & future Oracle database environments. Indexes are closely examined as well. The internal structure is discussed as well as the decision process Oracle uses when selecting whether to use indexes or not.
Dan will illustrate how to tell which indexes are being used. Dan illustrates various free tuning aids such as the Oracle Trace Facility, Stats Pack, & the newer Trace Analyzer. This seminar then uses this information in a discussion on finding the problem SQL using scripts & additional information in the V$ & X$ dictionary views.
All scripts illustrated in this seminar will be made available to the attendees. The seminar concludes with a discussion on some Oracle 10g new features that might be causing performance issues.
This training may be available onsite; please contact us if you are interested.
Reviews/Comments
Add New
Vouchers
Do you know a voucher code for this product or supplier? Add it to Insights for others to use.
Denmark