OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide. Learn how to become an Oracle-certified Database Administrator Steve Ries, Walter S Ries

Spis treści książki

• OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
  • Table of Contents
  • OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
  • Credits
  • Foreword
  • About the Author
  • About the Reviewer
  • www.packtpub.com
    • Support files, eBooks, discount offers and more
      • Why Subscribe?
      • Free Access for Packt account holders
      • Instant Updates on New Packt Books
  • Preface
    • What this book covers
    • What you need for this book
    • Who this book is for
    • Conventions
    • Reader feedback
    • Customer support
      • Downloading the example code
      • Errata
      • Piracy
      • Questions
  • 1. Introducing the Oracle Relational Database System
    • Understanding the RDBMS
      • The importance of databases
      • Flat file databases
        • Limitations of the flat file paradigm
      • A new paradigm
    • Introducing the Oracle product family
      • Exploring the history of Oracle
      • Understanding the Oracle Database product
        • Understanding the different editions of Oracle Database
        • Understanding Oracle Database options
      • Examining the Oracle product family
        • Understanding Oracles hardware solutions
        • Examining Oracle virtualization solutions
        • Exploring Oracle operating systems
        • Examining Oracle Application Servers
    • Interpreting Oracle Database versioning
    • Understanding the role of the DBA
    • Examining the tools of the Oracle DBA
    • SQL*Plus
      • Oracle Enterprise Manager
      • TOAD
      • DBArtisan
      • Oracle SQL Developer
    • Introducing the Companylink database
    • Summary
    • Test your knowledge
  • 2. Installing the Oracle Database Software
    • Planning an Oracle installation
      • Understanding Oracle installation concepts
        • Acquiring the Oracle software
    • Reviewing the installation prerequisites
      • Reviewing hardware prerequisites for an installation
        • Meeting the minimum hardware requirements for an installation
      • Reviewing software prerequisites for an installation
    • Using the Oracle Universal Installer
      • Understanding how OUI works
      • Completing final preparations to install the Oracle software
        • Creating Oracle user accounts and groups
        • Establishing Oracle directory structures
        • Understanding the Optimal Flexible Architecture
        • Using environment variables in Oracle
    • Installing the Oracle Database software
      • Running the Oracle Universal Installer
      • Examining the installation
        • Understanding the de-installation process advanced topic
    • Summary
    • Test your knowledge
  • 3. Creating the Oracle Database
    • Planning for a database creation
      • Understanding the memory requirements of a database
      • Understanding the disk requirements of a database
      • Running the Network Configuration Assistant
    • Creating an Oracle database using DBCA
      • Introducing the Database Configuration Assistant
    • Examining a manual database creation
    • Examining Windows Services in Oracle
    • Certification objectives covered
    • Summary
    • Test your knowledge
  • 4. Examining the Oracle Architecture
    • Understanding the Oracle RDBMS
      • Distinguishing between an instance and a database
    • Examining the Oracle instance
      • Recognizing the primary Oracle processes
        • PMON the Process Monitor
        • SMON the System Monitor
        • DBWn the Database Writer process
        • CKPT the Checkpoint process
        • LGWR the Log Writer process
        • ARCn the Archiver process
      • Recognizing the secondary Oracle processes
        • MMON the Manageability Monitor
        • MMAN Memory Manager
        • RECO the Recoverer process
      • Recognizing other database processes
      • Identifying Oracle's memory caches
        • Understanding the SGA
          • Examining the database buffer cache
          • Examining the shared pool
          • Utilizing the log buffer
          • Understanding the large pool
          • Examining the streams pool
          • Understanding the Java pool
        • Understanding the PGA
    • Examining the Oracle database components
      • Understanding the control file
      • Exploring the redo logfiles
      • Understanding the archived redo logs
      • Examining Oracle's core infrastructure datafiles
        • Understanding the SYSTEM tablespace
        • Understanding the SYSAUX tablespace
        • Exploring the temporary tablespace
        • Understanding the Undo tablespace
      • Understanding non-specialized datafiles
    • Exploring Oracle Real Application Clusters
    • Certification objectives covered
    • Summary
    • Test your knowledge
  • 5. Managing Oracle Storage Structures
    • Examining Oracle's physical space paradigm
      • Understanding the database block
        • Sizing the database block
        • Examining the anatomy of a database block
      • Understanding the database extent
      • Understanding the database segment
      • Understanding the database datafile
    • Managing tablespaces
      • Starting SQL Developer
      • Creating tablespaces
      • Modifying tablespaces
        • Resizing datafiles
        • Adding datafiles
        • Automatically extending datafiles
        • Managing tablespace availability
        • Dropping a tablespace
    • Using advanced tablespace management techniques
      • Using non-standard block size tablespaces
      • Understanding locally managed tablespaces
    • Using Oracle Managed Files
    • Certification objectives covered
    • Summary
    • Test your knowledge
  • 6. Managing the Oracle Instance
    • Understanding database startup and shutdown
      • Understanding the startup process
      • Controlling the startup and shutdown process
        • Establishing a connection with SYSDBA privileges
        • Controlling the database startup process
        • Controlling the database shutdown process
        • Controlling startup and shutdown on Windows platforms
    • Setting database initialization parameters
      • Understanding the PFILE and SPFILE
      • Working with the PFILE and SPFILE
    • Understanding the data dictionary
      • Exploring the Oracle base tables
    • Exploring the static data dictionary views
      • Exploring the dynamic data dictionary views
      • Querying the data dictionary views
      • Listing common data dictionary views
        • Object-related views
        • Administration-related views
        • Security-related views
        • Storage-related views
    • Understanding database diagnostic information
      • Understanding the alert log
      • Understanding the trace files
      • Understanding the Automatic Diagnostic Repository
    • Understanding the Oracle Support model
      • Using My Oracle Support
      • Patching Oracle
      • Certification objectives covered
    • Summary
    • Test your knowledge
  • 7. Managing Security
    • Understanding the fundamentals of database security
      • Exploring the principles behind security
    • Creating and managing user accounts
      • Creating users
    • Understanding privileges
      • Granting system privileges
      • Granting object privileges
      • Removing privileges with REVOKE
    • Understanding role-based security
      • Using system roles
      • Managing user roles
      • Enabling roles
    • Understanding profiles
      • Understanding password limits
      • Using profiles to manage passwords
      • Using profiles to manage system resources
    • Understanding key security parameters
    • Understanding auditing
      • Exploring the audit trail
      • Auditing database actions
    • Certification objectives covered
    • Summary
    • Test your knowledge
  • 8. Managing Concurrency
    • Understanding the lifecycle of a transaction
      • Examining the rules of a transaction
      • Examining types of transactions
    • Managing undo data
      • Understanding undo-related parameters
      • Managing undo tablespaces
    • Managing serialization mechanisms
      • Understanding Oracle's locking scheme
      • Examining locking in action
      • Recognizing deadlocks
      • Understanding latches and mutexes
    • Certification objectives covered
    • Summary
    • Test your knowledge
  • 9. Configuring an Oracle Network
    • Understanding Oracle networking concepts
      • Exploring Oracle Net
      • Understanding the dedicated and shared server architectures
    • Understanding the listener
      • Controlling the listener
      • Understanding the networking configuration files
    • Using Oracle name resolution
      • Understanding Easy Connect
      • Understanding local naming
      • Using directory naming and external naming
    • Understanding database registration
      • Using static registration
      • Using dynamic registration
    • Using database links
    • Certification objectives covered
    • Summary
    • Test your knowledge
  • 10. Managing Database Performance
    • Understanding object-level tuning
      • Understanding the Oracle optimizer
      • Gathering object statistics
        • Gathering statistics manually
        • Gathering statistics automatically
      • Discovering invalid objects
    • Managing the Automatic Workload Repository
      • Understanding the AWR
      • Using statistics, metrics, and baselines
      • Generating an AWR report
    • Understanding Oracle's Advisory Framework
      • Understanding the Automatic Database Diagnostic Monitor
      • Generating an ADDM Report
      • Using Memory Advisors
        • Using the Buffer Pool Advisor
        • Using the Shared Pool Advisory
        • Using the PGA Advisor
      • Understanding the Alert Framework
    • Understanding Oracle Memory Management
      • Using Manual Memory Management
      • Using Automatic Shared Memory Management
      • Using Automatic Memory Management
    • Certification objectives covered
    • Summary
    • Test your knowledge
  • 11. Understanding Backup and Recovery Concepts
    • Understanding the redo-based architecture
      • Adding redo log members
      • Adding a redo log group
      • Exploring ARCHIVELOG mode
      • Converting to an ARCHIVELOG mode
    • Understanding Flash Recovery Area
      • Configuring the Flash Recovery Area
    • Understanding instance recovery
    • Understanding the categories of database failure
      • Addressing statement failures
      • Addressing user errors
      • Addressing user process errors
      • Addressing media failure
      • Understanding RAID
        • RAID 0
        • RAID 1
        • RAID 10
        • RAID 5
      • Understanding file-level media failure
    • Introducing the Data Recovery Advisor
    • Certification objectives covered
    • Summary
    • Test your knowledge
  • 12. Performing Database Backups
    • Creating user-managed backups
      • Creating user-managed cold backups
      • Creating user-managed hot backups
    • Understanding Oracle Recovery Manager
      • Introducing RMAN
      • Understanding the RMAN architecture
    • Performing RMAN offline backups
      • Performing a tablespace-level RMAN backup
      • Performing a full backup
      • Performing compressed backups
      • Backing up image copies
    • Performing RMAN hot backups
      • Performing full hot backups
      • Creating incremental backups
      • Understanding RMAN Parameters
      • Using the LIST command in RMAN
      • Using the REPORT command in RMAN
      • Checking files using CROSSCHECK
      • Monitoring the Flash Recovery Are with Enterprise Manager
    • Automating database backups
      • Automating Backups with scripting
      • Automating backups using Enterprise Manager
    • Certification objectives covered
    • Summary
    • Test your knowledge
  • 13. Performing Database Recovery
    • Understanding the recovery process
      • Understanding the importance of database recovery
      • Understanding the different types of recovery
    • Performing RMAN complete recoveries
      • Performing datafile-level RMAN complete recovery
      • Performing complete recovery of the database
    • Performing incomplete recoveries
      • Understanding incomplete recovery
      • Performing a time-based incomplete recovery
    • Using the Data Recovery Advisor
      • Performing recovery using the DRA command-line interface
      • Performing recovery using the DRA with Enterprise Manager
    • Certification objectives covered
    • Summary
    • Test your knowledge
  • 14. Migrating Data
    • Understanding external data access
      • Creating directory objects
      • Creating external tables
    • Loading data with SQL*Loader
      • Understanding the key command files used by SQL*Loader
        • Understanding SQL*Loader's load paths
        • Understanding the input data file
        • Constructing a parameter file
        • Constructing a control file
      • Running a SQL*Loader job
    • Migrating data with Oracle Data Pump
      • Understanding the architecture of Data Pump
      • Exporting data Using Data Pump
      • Importing data using Data Pump
      • Using Data Pump with NETWORK_LINK
      • Certification objectives covered
    • Summary
    • Test your knowledge
  • A. Preparing for the Certification Exam
    • About the exam
    • Helpful exam hints
    • A recommended strategy for preparation
  • B. Test Your Knowledge Answers
    • Chapter 1, Introducing the Oracle Relational Database System
    • Chapter 2, Installing the Oracle Database Software
    • Chapter 3, Creating the Oracle Database
    • Chapter 4, Examining the Oracle Architecture
    • Chapter 5, Managing Oracle Storage Structures
    • Chapter 6, Managing the Oracle Instance
    • Chapter 7, Managing Security
    • Chapter 8, Managing Concurrency
    • Chapter 9, Configuring an Oracle Network
    • Chapter 10, Managing Database Performance
    • Chapter 11, Understanding Backup and Recovery Concepts
    • Chapter 12, Performing Database Backups
    • Chapter 13, Performing Database Recovery
    • Chapter 14, Migrating Data
    • Online chapter 1, Managing Oracle Tables
    • Online chapter 2, Managing Other Database Objects
  • Index

pokaż cały spis treści

ukryj recenzje