tailieunhanh - DBA Handbook for Oracle P1

A database administrator in any company is responsible for establishing policies and procedures pertaining to the management, security, maintenance and use of database management systems. Besides planning, implementing and maintaining databases for a company, they also play a key role in training users, programmers and test engineers on database use and procedures. A Database administrator's role requires knowledge in the following area | SOLIX Technologies t i Sas DBA Handbook for Oracle Chapter 1 Introduction .5 Chapter 2 Oracle Database Architecture .6 The Database -----------------------------7 The Instance ----------------------------7 Database Components ---------------------8 Memory Structures ----------------------20 Oracle Processes for an Instance -------23 Chapter 3 Administration Activities .26 Installing the Oracle Database Software -27 Creating Databases ----------------------29 Database Operation ----------------------30 Space Management ------------------------34 User Management ------------------------37 Oracle Network Management---------------38 Chapter 4 Managing Schema Tables ----------------------------------44 Clusters -------------------------------47 Views ----------------------------------48 Indexes --------------------------------49 Synonyms -------------------------------52 Triggers -------------------------------53 Database Links -------------------------54 Chapter 5 Database Security and User Management ---------55 Roles -----------------------------------56 Privilege -------------------------------58 Grant -----------------------------------59 Revoke ----------------------------------60 Password Management --------------------61 Oracle Auditing ------------------------63 Chapter 6 Database Tuning .66 Database Tuning Strategy-----------------67 SQL Tuning ------------------------------68 Memory Tuning ---------------------------70 I O Tuning ------------------------------71 Sort Tuning ----------------------------71 The Optimizer---------------------------72 SQL Explain Plan -----------------------73 Chapter 7 Backup and Backup and Recovery Mechanisms--------------76 Expo ---------------------------------------78 SQL ----------------------------------------80 Standby Database ---------------------------82 .

TỪ KHÓA LIÊN QUAN