Author: Daniel Fink

My presentations are finished and the feedback positive. I will be presenting one of sessions (Using AWR/ASH data) at RMOUG Training Days and Hotsos Symposium 2011 with minor modifications (I wonder…can I use the 11g analytical function LISTAGG with AWR/ASH data?). Anyway here are some highlights from the last day and a half…

After an inauspicious start, my 7th visit to Birmingham for the UKOUG Conference is in full swing. As in the past, the quality of the presentations is outstanding and the biggest challenge to the attendee is to decide which of the 3 concurrent sessions to attend.

As of 10.2, Oracle supplies two scripts that enable you to extract and load AWR data into another database (even one already running AWR snapshots). You can even take the AWR data from a 10.2 database on Solaris and load it into an 11.2 database on Windows XP (other variations may work…but these are the two versions I have handy). I also took 11.2 database on Linux and loaded it to the Windows database