(1) The beginning of the class explained the concepts like latching and locking pretty well
(2) Next in the line was understanding "why" they occur; not "how much"
(3) Reinforced the fact that latches smell like, look like, behave like locks; and are kind of locks
(4) Differentiated between soft and hard parses and explained the role of cursor_sharing parameter
(5) Differentiated between library cache pins, locks and latches
But if there is only one benefit I can say is priceless, that would be the holistic tuning, using the key concepts to understand the behavior all the way from the user response time to tracing the unix process to understand where the bottlenecks are. Tanel explained all that with a live example to cement that knowledge. All in all, an excellent class by an excellent instructor.
2 comments:
Thanks man, I liked it well ;-)
It's a excellent article. It's a really valuable and useful for me. Thanks man, keep it up.
Post a Comment