The Performance Hub is designed in a master-detail format, where the timepicker at the top of the page drives the contents of the details displayed in the tabs below. The timepicker displays average active sessions over time, and if there are peaks in the timepicker, the user can move the selected time range to the period of interest to get more information.
The Performance Hub can be used to view both historical and realtime data.
In realtime mode, performance data is retrieved from in-memory views. The timepicker shows data for the past hour and the user can select any time range from within this period. The default selection is the past 5 minutes.
In historical mode, data is retrieved from the Automatic Workload Repository (AWR). The user can select any time period, provided there is sufficient data in AWR. When the user switches to historical mode, the default selected time range is dependent on the amount of data shown in the timepicker: if the timepicker displays data for the past week, the default selected time range is one day; and if the timepicker displays data for the past day, the default selected time range is one hour.
The Performance Hub organizes performance data by dividing it into different tabs. Each tab addresses a specific aspect of database performance. Details for what each tab displays can be found below:
The user can drill down from the Performance Hub to other pages to get more information. A user can view Monitored Executions, ADDM reports, as well as the SQL Details and the Session Details pages.