tailieunhanh - Less12_ProactiveM_MB3

After completing this lesson, you should be able to do the following: • Use statistics • Manage the Automatic Workload Repository (AWR) • Use the Automatic Database Diagnostic Monitor (ADDM) • Describe the advisory framework • Set alert thresholds • Use server-generated alerts • Use automated tasks | Proactive Maintenance Objectives After completing this lesson, you should be able to do the following: Use statistics Manage the Automatic Workload Repository (AWR) Use the Automatic Database Diagnostic Monitor (ADDM) Describe the advisory framework Set alert thresholds Use server-generated alerts Use automated tasks Proactive Maintenance Automatic Workload Repository Server alerts Automated tasks Advisory framework Data warehouse of the database Automatic collection of important statistics Direct memory access Automatic Proactive Efficient Proactive Maintenance Proactive maintenance is made easy by the sophisticated infrastructure of the Oracle database. The main elements are as follows: The Automatic Workload Repository (AWR) is a built-in repository in each Oracle database. At regular intervals, the Oracle database makes a snapshot of all its vital statistics and workload information and stores them in the AWR. The captured data can be analyzed by you, by the database itself, or . | Proactive Maintenance Objectives After completing this lesson, you should be able to do the following: Use statistics Manage the Automatic Workload Repository (AWR) Use the Automatic Database Diagnostic Monitor (ADDM) Describe the advisory framework Set alert thresholds Use server-generated alerts Use automated tasks Proactive Maintenance Automatic Workload Repository Server alerts Automated tasks Advisory framework Data warehouse of the database Automatic collection of important statistics Direct memory access Automatic Proactive Efficient Proactive Maintenance Proactive maintenance is made easy by the sophisticated infrastructure of the Oracle database. The main elements are as follows: The Automatic Workload Repository (AWR) is a built-in repository in each Oracle database. At regular intervals, the Oracle database makes a snapshot of all its vital statistics and workload information and stores them in the AWR. The captured data can be analyzed by you, by the database itself, or by both. By analyzing the information that is stored in the AWR, the database can identify the need to perform routine maintenance tasks, such as performing regular backups to maximize availability or refreshing statistics, which are used to optimize the execution of SQL statements. For problems that cannot be resolved automatically and require administrators to be notified (such as running out of space), the Oracle database provides server-generated alerts. The Oracle database can monitor itself and send out alerts to notify you of any problem. The alerts not only notify you of the problem, they also provide recommendations on how the reported problem can be resolved. Recommendations are generated from a number of advisors, each of which is responsible for a subsystem. For example, there are memory and SQL advisors. Introducing Terminology Automatic Workload Repository (AWR): Infrastructure for data gathering, analysis, and solutions recommendations Baseline: Data gathered of a “normal

• Cơ sở dữ liệu
• workshopI
• oca 10g
• oracle
• database
• dba
• Tìm hiểu GPON
• Dynamic bandwidth allocation (DBA)
• Status reporting
• Tìm hiểu OPNET
• Tham khảo Dynamic bandwidth allocation (DBA)
• Tìm hiểu Dynamic bandwidth allocation (DBA)
• câu lệnh T SQL Index
• SQL Server DBA
• quản trị cơ sở dữ liệu
• câu lệnh về T SQL
• Enterprise DBA
• Performance and Tuning
• Database Resource Manager
• quản lý tài nguyên
• SQL Server™ 2005
• DBA Street Smarts
• Guide to SQL Server 2005
• Certification Skills
• Joseph L
• Jorden
• Wiley Publishing
• O’Reilly Media
• Cookbook
• O’Reilly books
• Oracle DBA Checklists
• Pocket Reference
• ORACLE DBA
• SURVIVAL GUIDE
• Oracle Installations
• Planning an Oracle Upgrade
• Oracle Upgrades
• hệ thống thông tin
• lập trình dữ liệu
• kỹ năng máy tính
• thủ thuật máy tính
• tài liệu về DBA Field Guide
• Oracle9i DBA Fundamentals II
• Jumpstart with Examples
• Features of Oracle SQL
• Oracle Database Architecture
• SQL Server 2008 DBA
• SQL server Configuring SQL Server
• Extents Files
• Rebuilding System
• Managing Database Services
• Unix and Linux electronic
• mechanical
• photocopying
• recording
• DBA Survivor
• Rock Star DBA
• SQL Server
• giáo trình cơ sở dữ liệu
• MySQL cơ bản
• bảo mật cơ sở dữ liệu
• giáo trình sql cơ bản