Built-In Database ObjectsIn addition to creating the database files, several other structures are created.Data dictionary: Contains descriptions of the objects in the databaseDynamic performance tables: Contains information used by the database administrator (DBA) to monitor and tune the database and instancePL/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.Database event triggers: Triggers are procedures that execute implicitly whenever a table or view is modified, or when some user actions or database system actions...
Nội dung trích xuất từ tài liệu:
Using Data Dictionary and Dynamic Performance Views
Using Data Dictionary and Dynamic Performance Views
Số trang: 20
Loại file: ppt
Dung lượng: 125.50 KB
Lượt xem: 33
Lượt tải: 0
Thông tin tài liệu:
Tìm kiếm theo từ khóa liên quan:
Data Dictionary Oracle XML Applications database data management Oracle XML Performance Tuning XML Data AdministrationTài liệu có liên quan:
-
Trắc nghiệm 300 câu phân tích và thiết kế hệ thống
29 trang 122 0 0 -
863 trang 89 0 0
-
710 trang 45 0 0
-
0 trang 36 0 0
-
Lecture Principles of network and system administration: Performance monitoring
26 trang 35 0 0 -
Lecture Introduction to computing - Lesson 36: Data management
54 trang 34 0 0 -
Nhập môn Cơ sở Dữ liệu - Phần 5
51 trang 34 0 0 -
Advanced SQL Functions in Oracle 10g
417 trang 34 0 0 -
20 trang 33 0 0
-
GUIDANCE PAPER ON INVESTMENT RISK MANAGEMENT
31 trang 32 0 0
