Dynamic management views

Bài giảng Cơ sở dữ liệu nâng cao - Chapter 8: Monitoring SQL server. Chương này trình bày một số nội dung: The goal of monitoring, performance monitor, dynamic management views, monitoring events, event notifications,...

47p nomoney10 05-04-2017 82 9   Download

After completing this lesson, you should be able to do the following: Describe the concept of automaticundo management Create and maintain the automatic managedundo tablespace Set the retention period Use dynamic performance views to check rollback segment performance Reconfigure and monitor rollback segments Define the number and sizes of rollback segments Allocate rollback segments to transactions

36p trinh02 28-01-2013 46 7   Download

Built-In Database Objects In addition to creating the database files, several other structures are created. Data dictionary: Contains descriptions of the objects in the database Dynamic performance tables: Contains information used by the database administrator (DBA) to monitor and tune the database and instance PL/SQL packages: Program units adding functionality to the database. These packages are created when the catproc.sql script is run after the CREATE DATABASE command. PL/SQL packages will not be discussed within the scope of this course.

20p trinh02 28-01-2013 63 4   Download

After completing this lesson, you should be able to do the following: Identify key tuning components of the alert log file Identify key tuning components of backgroundtrace files Identify key tuning components of user trace files Collect statistics with Oracle Enterprise Manager Describe how Statspack collects statistics Collect statistics with Statspack Identify dynamic performance views useful in tuning Describe other tools used for tuning

44p trinh02 28-01-2013 43 5   Download