Learn about ASH Masters a github repository of queries against Average Active Sessions (ASH). Learn about ASH math, average active sessions and the power and pitfalls of ASH queries. ASH queries will be shown that display over database performance from on high to diving deep down into the nitty gritty of performance bottleneck's internal workings. Active…

Learn about ASH Masters a github repository of queries against Average Active Sessions (ASH). Learn about ASH math, average active sessions and the power and pitfalls of ASH queries. ASH queries will be shown that display over database performance from on high to diving deep down into the nitty gritty of performance bottleneck's internal workings. Active…

Learn about ASH Masters a github repository of queries against Average Active Sessions (ASH). Learn about ASH math, average active sessions and the power and pitfalls of ASH queries. ASH queries will be shown that display over database performance from on high to diving deep down into the nitty gritty of performance bottleneck's internal workings. Active…

The promise of cloud computing—greater agility, less risk, and lower costs—is real, but realizing that promise depends on the approach one adopts. Various cloud vendors offer choice and flexibility with the most comprehensive, modern, and secure portfolio of cloud products and services to meet the business needs and deliver the full benefits of cloud computing.…

The promise of cloud computing—greater agility, less risk, and lower costs—is real, but realizing that promise depends on the approach one adopts. Various cloud vendors offer choice and flexibility with the most comprehensive, modern, and secure portfolio of cloud products and services to meet the business needs and deliver the full benefits of cloud computing.…

The promise of cloud computing—greater agility, less risk, and lower costs—is real, but realizing that promise depends on the approach one adopts. Various cloud vendors offer choice and flexibility with the most comprehensive, modern, and secure portfolio of cloud products and services to meet the business needs and deliver the full benefits of cloud computing.…

The promise of cloud computing—greater agility, less risk, and lower costs—is real, but realizing that promise depends on the approach one adopts. Various cloud vendors offer choice and flexibility with the most comprehensive, modern, and secure portfolio of cloud products and services to meet the business needs and deliver the full benefits of cloud computing.…

The promise of cloud computing—greater agility, less risk, and lower costs—is real, but realizing that promise depends on the approach one adopts. Various cloud vendors offer choice and flexibility with the most comprehensive, modern, and secure portfolio of cloud products and services to meet the business needs and deliver the full benefits of cloud computing.…

The promise of cloud computing—greater agility, less risk, and lower costs—is real, but realizing that promise depends on the approach one adopts. Various cloud vendors offer choice and flexibility with the most comprehensive, modern, and secure portfolio of cloud products and services to meet the business needs and deliver the full benefits of cloud computing.…

Your ASH repository is a veritable gold mine of performance information and while the GUI interface in OEM is very pretty and easy to use, it has its limitations.  In this session, I'll be showing several examples of how sifting thru the ASH data directly via SQL can shed new light on some common problems.…