{"id":186,"date":"2016-09-20T17:02:33","date_gmt":"2016-09-20T23:02:33","guid":{"rendered":"http:\/\/www.aamirharoon.com\/?p=186"},"modified":"2016-09-20T17:02:33","modified_gmt":"2016-09-20T23:02:33","slug":"oracle-open-world-2016-notes","status":"publish","type":"post","link":"https:\/\/aamirharoon.com\/?p=186","title":{"rendered":"Advance Active Session History"},"content":{"rendered":"<p>I attended a session in Oracle Open World 2016 given by Kyle Hailey.<\/p>\n<p>In his presentation Kyle talked about how to measure database performance and what to look for when application is running slow.<\/p>\n<p>I am sharing few notes from his session:<\/p>\n<ul>\n<li>Counting is the key to v$active_session_history.<\/li>\n<\/ul>\n<p style=\"padding-left: 60px;\">DB Time ~= count(*)<\/p>\n<p style=\"padding-left: 60px;\">Average Active Session (AAS) = DB Time \/ elapsed<\/p>\n<ul>\n<li>AAS Formulas<\/li>\n<\/ul>\n<p style=\"padding-left: 60px;\">AAS &lt; 1 :\u00a0Database is not blocked<\/p>\n<p style=\"padding-left: 60px;\">AAS ~= 0 : Database basically idle<\/p>\n<p style=\"padding-left: 60px;\">AAS &lt; #\u00a0of CPUs :\u00a0CPU available<\/p>\n<p style=\"padding-left: 60px;\">AAS &gt; # of CPUs :\u00a0Could have performance problems<\/p>\n<p style=\"padding-left: 60px;\">AAS &gt;&gt; #\u00a0of CPUS :\u00a0There is a bottleneck<\/p>\n<p>Kyle provided following github link for all his scripts.<\/p>\n<p><a href=\"https:\/\/github.com\/khailey\/ashmasters\" target=\"_blank\">https:\/\/github.com\/khailey\/ashmasters<\/a><\/p>\n<p>This is the presentation given by him.<\/p>\n<p><iframe loading=\"lazy\" style=\"border: none;\" src=\"http:\/\/www.slideshare.net\/khailey\/slideshelf\" width=\"615px\" height=\"470px\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Cheers\u00a0<img loading=\"lazy\" decoding=\"async\" style=\"margin-left: 3px; margin-right: 3px; vertical-align: middle; -webkit-box-shadow: none; -moz-box-shadow: none; box-shadow: none;\" src=\"https:\/\/www.aamirharoon.com\/wp-content\/plugins\/wp-emoji-one\/icons\/1F600.png\" width=\"16\" height=\"16\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I attended a session in Oracle Open World 2016 given by Kyle Hailey. In his presentation Kyle talked about how to measure database performance and what to look for when application is running slow. I am sharing few notes from his session: Counting is the key to v$active_session_history. DB Time ~= count(*) Average Active Session [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4],"tags":[],"class_list":["post-186","post","type-post","status-publish","format-standard","hentry","category-11gr2","category-12cr1"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":8}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Advance Active Session History - The Database Handyman<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/aamirharoon.com\/?p=186\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advance Active Session History - The Database Handyman\" \/>\n<meta property=\"og:description\" content=\"I attended a session in Oracle Open World 2016 given by Kyle Hailey. In his presentation Kyle talked about how to measure database performance and what to look for when application is running slow. I am sharing few notes from his session: Counting is the key to v$active_session_history. DB Time ~= count(*) Average Active Session [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aamirharoon.com\/?p=186\" \/>\n<meta property=\"og:site_name\" content=\"The Database Handyman\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-20T23:02:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.aamirharoon.com\/wp-content\/plugins\/wp-emoji-one\/icons\/1F600.png\" \/>\n<meta name=\"author\" content=\"Aamir\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@aamir814\" \/>\n<meta name=\"twitter:site\" content=\"@aamir814\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aamir\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=186#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=186\"},\"author\":{\"name\":\"Aamir\",\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/#\\\/schema\\\/person\\\/5b7250c4974dcf9818ca431e21831c75\"},\"headline\":\"Advance Active Session History\",\"datePublished\":\"2016-09-20T23:02:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=186\"},\"wordCount\":122,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/#\\\/schema\\\/person\\\/5b7250c4974dcf9818ca431e21831c75\"},\"image\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=186#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.aamirharoon.com\\\/wp-content\\\/plugins\\\/wp-emoji-one\\\/icons\\\/1F600.png\",\"articleSection\":[\"Oracle Database 11gR2\",\"Oracle Database 12cR1\"],\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/aamirharoon.com\\\/?p=186#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=186\",\"url\":\"https:\\\/\\\/aamirharoon.com\\\/?p=186\",\"name\":\"Advance Active Session History - The Database Handyman\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=186#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=186#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.aamirharoon.com\\\/wp-content\\\/plugins\\\/wp-emoji-one\\\/icons\\\/1F600.png\",\"datePublished\":\"2016-09-20T23:02:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=186#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/aamirharoon.com\\\/?p=186\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=186#primaryimage\",\"url\":\"https:\\\/\\\/www.aamirharoon.com\\\/wp-content\\\/plugins\\\/wp-emoji-one\\\/icons\\\/1F600.png\",\"contentUrl\":\"https:\\\/\\\/www.aamirharoon.com\\\/wp-content\\\/plugins\\\/wp-emoji-one\\\/icons\\\/1F600.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/?p=186#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/aamirharoon.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Advance Active Session History\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/#website\",\"url\":\"https:\\\/\\\/aamirharoon.com\\\/\",\"name\":\"The Database Handyman\",\"description\":\"Cloud Architecture. Open-Source Databases. Data-Driven Solutions.\",\"publisher\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/#\\\/schema\\\/person\\\/5b7250c4974dcf9818ca431e21831c75\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/aamirharoon.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/#\\\/schema\\\/person\\\/5b7250c4974dcf9818ca431e21831c75\",\"name\":\"Aamir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/cropped-IMG_2639-scaled-1.jpg\",\"url\":\"https:\\\/\\\/aamirharoon.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/cropped-IMG_2639-scaled-1.jpg\",\"contentUrl\":\"https:\\\/\\\/aamirharoon.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/cropped-IMG_2639-scaled-1.jpg\",\"width\":512,\"height\":512,\"caption\":\"Aamir\"},\"logo\":{\"@id\":\"https:\\\/\\\/aamirharoon.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/cropped-IMG_2639-scaled-1.jpg\"},\"sameAs\":[\"https:\\\/\\\/www.aamirharoon.com\\\/about\\\/\",\"https:\\\/\\\/x.com\\\/aamir814\"],\"url\":\"https:\\\/\\\/aamirharoon.com\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Advance Active Session History - The Database Handyman","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/aamirharoon.com\/?p=186","og_locale":"en_US","og_type":"article","og_title":"Advance Active Session History - The Database Handyman","og_description":"I attended a session in Oracle Open World 2016 given by Kyle Hailey. In his presentation Kyle talked about how to measure database performance and what to look for when application is running slow. I am sharing few notes from his session: Counting is the key to v$active_session_history. DB Time ~= count(*) Average Active Session [&hellip;]","og_url":"https:\/\/aamirharoon.com\/?p=186","og_site_name":"The Database Handyman","article_published_time":"2016-09-20T23:02:33+00:00","og_image":[{"url":"https:\/\/www.aamirharoon.com\/wp-content\/plugins\/wp-emoji-one\/icons\/1F600.png","type":"","width":"","height":""}],"author":"Aamir","twitter_card":"summary_large_image","twitter_creator":"@aamir814","twitter_site":"@aamir814","twitter_misc":{"Written by":"Aamir","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aamirharoon.com\/?p=186#article","isPartOf":{"@id":"https:\/\/aamirharoon.com\/?p=186"},"author":{"name":"Aamir","@id":"https:\/\/aamirharoon.com\/#\/schema\/person\/5b7250c4974dcf9818ca431e21831c75"},"headline":"Advance Active Session History","datePublished":"2016-09-20T23:02:33+00:00","mainEntityOfPage":{"@id":"https:\/\/aamirharoon.com\/?p=186"},"wordCount":122,"commentCount":0,"publisher":{"@id":"https:\/\/aamirharoon.com\/#\/schema\/person\/5b7250c4974dcf9818ca431e21831c75"},"image":{"@id":"https:\/\/aamirharoon.com\/?p=186#primaryimage"},"thumbnailUrl":"https:\/\/www.aamirharoon.com\/wp-content\/plugins\/wp-emoji-one\/icons\/1F600.png","articleSection":["Oracle Database 11gR2","Oracle Database 12cR1"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/aamirharoon.com\/?p=186#respond"]}]},{"@type":"WebPage","@id":"https:\/\/aamirharoon.com\/?p=186","url":"https:\/\/aamirharoon.com\/?p=186","name":"Advance Active Session History - The Database Handyman","isPartOf":{"@id":"https:\/\/aamirharoon.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/aamirharoon.com\/?p=186#primaryimage"},"image":{"@id":"https:\/\/aamirharoon.com\/?p=186#primaryimage"},"thumbnailUrl":"https:\/\/www.aamirharoon.com\/wp-content\/plugins\/wp-emoji-one\/icons\/1F600.png","datePublished":"2016-09-20T23:02:33+00:00","breadcrumb":{"@id":"https:\/\/aamirharoon.com\/?p=186#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aamirharoon.com\/?p=186"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/aamirharoon.com\/?p=186#primaryimage","url":"https:\/\/www.aamirharoon.com\/wp-content\/plugins\/wp-emoji-one\/icons\/1F600.png","contentUrl":"https:\/\/www.aamirharoon.com\/wp-content\/plugins\/wp-emoji-one\/icons\/1F600.png"},{"@type":"BreadcrumbList","@id":"https:\/\/aamirharoon.com\/?p=186#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/aamirharoon.com\/"},{"@type":"ListItem","position":2,"name":"Advance Active Session History"}]},{"@type":"WebSite","@id":"https:\/\/aamirharoon.com\/#website","url":"https:\/\/aamirharoon.com\/","name":"The Database Handyman","description":"Cloud Architecture. Open-Source Databases. Data-Driven Solutions.","publisher":{"@id":"https:\/\/aamirharoon.com\/#\/schema\/person\/5b7250c4974dcf9818ca431e21831c75"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/aamirharoon.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":["Person","Organization"],"@id":"https:\/\/aamirharoon.com\/#\/schema\/person\/5b7250c4974dcf9818ca431e21831c75","name":"Aamir","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/aamirharoon.com\/wp-content\/uploads\/2020\/10\/cropped-IMG_2639-scaled-1.jpg","url":"https:\/\/aamirharoon.com\/wp-content\/uploads\/2020\/10\/cropped-IMG_2639-scaled-1.jpg","contentUrl":"https:\/\/aamirharoon.com\/wp-content\/uploads\/2020\/10\/cropped-IMG_2639-scaled-1.jpg","width":512,"height":512,"caption":"Aamir"},"logo":{"@id":"https:\/\/aamirharoon.com\/wp-content\/uploads\/2020\/10\/cropped-IMG_2639-scaled-1.jpg"},"sameAs":["https:\/\/www.aamirharoon.com\/about\/","https:\/\/x.com\/aamir814"],"url":"https:\/\/aamirharoon.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts\/186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aamirharoon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aamirharoon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=186"}],"version-history":[{"count":5,"href":"https:\/\/aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts\/186\/revisions"}],"predecessor-version":[{"id":191,"href":"https:\/\/aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts\/186\/revisions\/191"}],"wp:attachment":[{"href":"https:\/\/aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}