InsertPictureHere-Oracle.pdfVIP

Insert Picture Here Essential Diagnostic Techniques for Oracle Database 11g Graham Wood, Uri Shaft, John Beresniewicz Oracle USA Agenda Diagnostic Pack Is Essential For Database Performance Tuning Insert Picture Here • 11g Diagnostic Pack: Highlights and Usage • However, we start with “Why It Works” • DB Time and Average Active Sessions • The DB Time Performance Method Insert Picture Here Oracle Performance Analysis: The DB Time Method Why Do We Care About Time? Performance Is Always About Time • Human time is critical to the enterprise • System time includes human and IT resource time to accomplish business goals • System performance affects business goals • “Time is money.” • Performance improvement usually means doing things faster • Method: find where system time is spent – reduce it! A Single Session Single session with Database Black Box server Browse Read Reviews Add to Cart Checkout Books For One Book = time spent in database TIME Fundamental concepts Active Session = Session currently spending time in a database call Database Time (DB Time) = Total time session spent in all database calls Average Activity of the Session = The ratio of time being active to total wall clock time Browse Read Reviews Add to Cart Checkout Books For One Book = time spent in database TIME The Basic Relationship Database Time Avg. Active Sessions = Wall Clock (Elapsed) Time Browse Read Reviews