Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Section 8: Application Tracing > Solutions
Solutions
APPLICATION TRACING-1
APPLICATION TRACING-2
APPLICATION TRACING-3
APPLICATION TRACING-4
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.
APPLICATION TRACING-5
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.