Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
As soon as this script begins to execute, proceed onto the next exercise. When this script finishes, be sure to return to the session and take note of the starting and ending AWR snapshot IDs as these values will be needed for the next workshop which follows this one.
The database home page will likely indicate a measure of intensive processing within the database. For instance, in our sample shown next Host CPU processing is at a very high level.
You might also drill-down into the SQL Response Time metric by clicking on the appropriate links from the SQL Response Time section.
The Performance link clearly indicates a recent surge in database resource consumption.