Session Number: 1199
Track: 5-Data Warehousing and SQL
Session Type: Best Practices, Tips & Tricks
Primary Presenter: Tanel Poder [Technology Evangelist - Gluent, Inc]
Time: Jan 26, 2016 (01:20 PM - 02:10 PM)
Session level: Intermediate
Abstract (250 words or less):
In this session, learn how to use SQL monitoring reports and the underlying active session data. The SQL monitoring features have been significantly improved in Oracle Database 12c, such as the ability to see more important metrics at execution plan line level and report SQL monitoring data from past problematic SQL executions. This session discusses multiple real-life SQL monitoring report examples from various Oracle databases.