Real-World Performance - 19 - Architecture with an AWR Report

Check out the entire series on the Oracle Learning Library at www.oracle.com/goto/oll/rwp
In this video, listen and watch Graham Wood, Architect and Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as they explain and analyze the information gathered via an AWR Report from a large internet retailer and how that affects performance.
Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.

[@viltran]

This is a very educational AWR report analysis. Thank you so much for sharing!

[@pahariayogi]

Really nice video understanding performance bottlenecks using AWR. Someone rightly said.. A picture is worth 1000 words but a video is worth 100000 words :-) Thanks much!!

[@ajojohnk]

Wish to see more of similar ones

[@ajojohnk]

Thanks a lot. a wonderful presentation

[@laurenoe]

I love these two! ;)

[@sampathyamsani5930]

Thanks. Nice presentation..

[@anandjanakiraman2323]

Hi Graham,
at the beginning of the video, you explain about the CPUS cores and sessions details based on the awr report and say its almost 100 per core. can you please explain what would be ideal sessions that can be there for the number of CORES configured and how can it be restricted if say sessions init parameter value is configured with 6000?
Thanks,
Anand Janakiraman

[@sabariraj5743]

Thanks for knowledge sharing.

[@BabitaSingh-rn4ol]

So beautiful so elegant just looking like a wow

[@nalinapg]

Thanks a lot. Need a tool for AWR report comparision. Good presentation

[@grahamwood8118]

+Nalina P G There is the AWR Compare Period report, awrddrpt.sql