To download an ASH report:
Open the Performance Hub page from the database details page, if not already open.
From the menu in the upper-right corner, click Reports and select Active Session History. The Generate ASH Report dialog box is displayed.
Select the date of the Start Time. In the calendar and time dialog boxes that are displayed, select the start date and time for the report.
Repeat this step for the End Time date and time.
Click Download to generate the report for the selected time range and download it.
While the report is being generated, a message
is in progress appears at the upper-right corner of the screen. When
the report is complete and downloaded, a confirmation message with the name of the
report file is displayed.