Lecture 6.2. Reading a Trace File (Oracle SQL Optimization Course)
A description of the contents of a raw and parsed Oracle .trc file, what to pay attention to, and which columns are responsible for what. The topic of reading session trace files is quite extensive.
Students cover how to create trace files and the available options in previous lectures.
Analytics and bottleneck detection are covered in subsequent lectures.
This is one lesson in the 3-month "Oracle SQL Optimization" course.
🚀 The "Oracle SQL Optimization: Fundamentals" course is a unique opportunity to master the art of SQL query optimization from a professional with many years of Oracle experience 🔥
The main goal of the course: to take students from scratch to a confident specialist who can solve 80-90% of typical problems related to SQL query optimization.
🔺Learn to find and solve problems in a PROD environment;
🔺Learn to write optimal queries right away;
🔺Successfully complete the optimization section during interviews;
🔺Systematize your knowledge.
Why choose this course?
🎓 Practical experience from the first lesson.
🚀 Coverage of most real-life scenarios.
🛠 Problem-solving at the interview and job level.
🕒 Master the material faster with a mentor.
💵Increase your salary by changing jobs or roles within your current company.
Feedback from previous colleagues
💬 "I received several offers in two weeks, and after a month of searching, I reached a position almost double my previous one";
💬 "As you said, by the end of the course we will be solving optimization problems quickly and in a completely different way";
💬 "I want to boast that the course has already paid for itself, so it wasn't all in vain";
💬 "Yeah, your course has already paid for itself by half. This thing would have saved me a couple of weeks of my life."
💬 "15 minutes, but so much useful information, it's just awful. I'm afraid no one will teach me that."
⚠️ Want to join? Message me at https://t.me/denis_dbd
https://oracle-dbd.tilda.ws/opt - course promo page.
Recommended Reading
🔸https://docs.oracle.com/en/database/o... - Lots of theory about tracing
🔸https://databaseinternalmechanism.com... - A good explanation of how to interpret traces (ENG)
🔸https://docs.oracle.com/en/database/o... - About reading in current and consistent modes.
🔸Book "Oracle - Performance Optimization" (Millsap, Holt)
Video timestamps
00:00 - Introduction
00:30 - Reading a raw trace file
02:30 - Reading a parsed trace file
05:00 - Parsing a plan in a trace file
09:55 - Recommended reading
Subscribe:
Telegram channel - https://t.me/oracle_dbd
Training website - https://oracle-dbd.ru/
YouTube channel - / oracledbd
Telegram PM - https://t.me/denis_dbd