HomeОбразованиеRelated VideosMore From: ODTUG

Understanding SQL Trace, TKPROF and Execution Plan for Beginners

5 ratings | 509 views
Presenter: Carlos Sierra, Oracle Corporation In this session, participants will learn about producing a SQL Trace then a summary TKPROF report. A sample TKPROF is navigated with the audience, where the trivial and the not so trivial is exposed and explained. Execution Plans are also navigated and explained, so participants can later untangle complex execution plans and start diagnosing SQL performing badly.
Html code for embedding videos on your blog
Text Comments (1)
krishna d (6 months ago)
Good One

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.