Wow Connor, that was an amazing session!!! Massive amount of information, it was like a Matrix training but I can't say I know ASH :) And if you are going to bring in people like John please do invite them.
hi Wilson, sorry just seeing this, I used R and ggplot2 package to produce the viz and data was an old ASH dump (csv format) that I pulled into an R dataframe
Great presentation. Thanks a lot. One question: at 25:10 Why need to index V$ACTIVE_SESSION_HISTORY on time? and index on timestamp, buffer id or what?
Loved it!! I work with SAP HANA and I now see it looks like a lot like Oracle in this regard.
Wow Connor, that was an amazing session!!! Massive amount of information, it was like a Matrix training but I can't say I know ASH :)
And if you are going to bring in people like John please do invite them.
What an amazing explanation! Solid gold!
Great presentation. Thanks a lot. One question: What tool could be used to plot charts like the last ones?
hi Wilson, sorry just seeing this, I used R and ggplot2 package to produce the viz and data was an old ASH dump (csv format) that I pulled into an R dataframe
Thanks so much for a great masterclass
Great presentation. Thanks a lot. One question: at 25:10 Why need to index V$ACTIVE_SESSION_HISTORY on time? and index on timestamp, buffer id or what?