Please pre-register here to let us know if you plan to attend. This will immensely help us in planning. 1:00 pm - 2:30 pm - Listen to your database. How to understand an Oracle AWR report Speaker : Alfredo Krieg, Sherwin Williams Is sometimes difficult to quickly identify the root cause of a performance issue in the database. Automatic workload Repository (AWR) contains most of the information needed to identify these issues, but it could be overwhelming due the amount of data and statistics. Then, there's a need of a method to quickly identify if the database system is CPU or I/O bound along with the top SQL statements in that period of time. This session will explain how to identify the time consumed and the time waited by the database. It also drills down to particular SQL statements responsible of this time consumed. Learner will be able to: - How time is measured in the database - Difference between time consumed and time waited Learner will also be able to: - Identify TOP SQL responsible of time consumed and waited Outline: - What is time? - Why we use time? - Time consumed VS time waited - Is the DB system CPU-bound or I/O-bound? - Where we should focus? - What is a bottleneck? - Identify TOP SQL 3:00 pm - 4:30 pm - Understanding how Oracle Sessions work Speaker : Eric A. Mortensen, Sherwin Williams This session will discuss Oracle Sessions Processes. I will describe how Oracle Session Processes work, the four distinct architectures that database Session processes can be configured, how distributed sessions work, and how parallel sessions work. I will also discuss the work that an Oracle Session Process must do from five different perspectives: a data input and output perspective; a shared pool perspective; a transaction perspective; a multi-session perspective; and a session data perspective>