OCA /OCP Oracle Database 11g A ll-in-One Exam Guide- P94:There is an ever increasing demand for staff with IT industry certification. The benefits to employers are significant—they can be certain that staff have a certain level of competence—and the benefits to the individuals, in terms of demand for their services, are equally great. Many employers are now requiring technical staff to have certifications, and many IT purchasers will not buy from firms that do not have certified staff. | OCA OCP Oracle Database 11g All-in-One Exam Guide 886 6. In your Database Control session within a few seconds you will see that the alert has been raised as shown here 7. Tidy up by returning to the Edit Thresholds window and clearing the threshold values. Two-Minute Drill Use and Manage the Automatic Workload Repository By default snapshots are taken every hour and stored for eight days. Additional snapshots can be taken on demand. Snapshots can be preserved indefinitely if nominated for a baseline. MMON is responsible for creating snapshots and launching the ADDM. The AWR consists of tables and related objects in the SYSMAN schema in the SYSAUX tablespace. Use the Advisory Framework The ADDM runs automatically whenever a snapshot is taken and manually on demand. Chapter 24 The AWR and the Alert System 887 ADDM reports will give advice directly and may recommend running other advisors. By default the SQL Tuning Advisor and the Segment Advisor will run automatically in the maintenance windows. Setting STATISTICS_LEVEL to BASIC will disable gathering snapshots and running the advisors. Manage Alerts and Thresholds Stateful alerts must be configured with thresholds. If a stateful alert is raised it will remain until the situation is cleared stateless alerts are reported and do not need to be cleared. Thresholds are stored in the AWR. It is the MMON background process that raises an alert and usually Enterprise Manager that reports it. Self Test 1. The AWR is located in the SYSAUX tablespace. If you suspect that it is growing to such a size that it will fill the SYSAUX tablespace what actions could you take to reduce the likelihood of this happening Choose all correct answers. A. Relocate the AWR to a tablespace created specifically for storing it. B. Reduce the time between snapshots so that less data will be generated by each one. C. Increase the time between snapshots so that fewer snapshots will be generated. D. Adjust the scheduling of the automatic maintenance
