Active Session History (ASH) Analytics was introduced in Oracle Enterprise Manager Cloud Control 12c. As the name implies, ASH Analytics is a data warehouse of sorts for Active Session History data over time. In fact, it is presented as a star schema design possessing many dimensions upon which to analyze, or “slice and dice,” the data. Through its extremely effective data visualization, ASH Analytics makes it far simpler to diagnose performance problems, and you will find numerous white papers and web blogs on the subject. Moreover, once most DBAs find and use ASH Analytics, it quickly becomes one of their most indispensable ...