Oracle DBA Pocket Guide

Book description

The Oracle database is one of the most popular in the world, and for good reason. It's compatible, scalable, portable, and capable of performing incredibly fast. The advantages Oracle holds over its competition come with a price, however--it's a highly complex database that's becoming more complex with every release. And this level of detail, of course, can begin to weigh on database administrators (DBAs).

Fortunately, the Oracle DBA Pocket Guide from O'Reilly is on the case. This handy reference is designed to help administrators make more effective use of their time by presenting a compact summary of DBA tasks in an easy-to-use form. With this book by your side, you'll have instant access to the most important concepts, best practices, tips, and checklists. Key topics include architecture, installation, configuration, tuning, and backup/recovery. Everything that you absolutely must know to do your job well is right there at your fingertips.

Moreover, the Oracle DBA Pocket Guide covers Oracle Database 9i, as well as its latest release, Oracle Database 10g. The first database designed for enterprising grid computing, Oracle Database 10g significantly reduces the cost of managing the IT environment with a simplified install, reduced configuration and management requirements, and automatic performance diagnosis and SQL tuning.

The latest in O'Reilly's line of bestselling Oracle titles, this book is an invaluable companion for any database administrator--new or experienced--interested in reviewing core Oracle concepts at a glance.

Table of contents

  1. Contents
  2. Oracle DBA Pocket Guide
    1. Introduction
      1. Acknowledgments
      2. Conventions
    2. Oracle Architecture
      1. Database Versus Instance
      2. Background Processes
      3. System Global Area
        1. Database buffer cache
        2. Shared pool
        3. Redo log buffer
        4. Large pool
      4. Files
        1. Parameter files
        2. Control file
        3. Datafiles
        4. Redo log files
      5. Logical Database Structures
    3. Software Options
      1. Base Product
      2. Licensing
      3. Version Numbers
    4. Configuration Planning
      1. Availability
        1. Replication
        2. Hot standby database
        3. Real Application Clusters (RAC)
      2. Backup and Recovery
      3. Performance
        1. Memory
        2. Disk layout
    5. Installation
      1. Planning
      2. Installing the Oracle Software
      3. Creating a Database
        1. Using the DBCA
        2. Creating a database manually
    6. Initialization Parameters
      1. INIT.ORA: The Initialization File
      2. SPFILE: The Server Parameter File
      3. Dynamic and Static Parameters
    7. Backup and Recovery
      1. Export (EXP) and Import (IMP) (1/3)
      2. Export (EXP) and Import (IMP) (2/3)
      3. Export (EXP) and Import (IMP) (3/3)
        1. EXP and IMP commands
        2. Common Export/Import parameters
        3. Export-only parameters
        4. Import-only parameters
      4. Data Pump Export and Import (1/3)
      5. Data Pump Export and Import (2/3)
      6. Data Pump Export and Import (3/3)
        1. Data Pump features
        2. Data Pump privileges
        3. Data Pump Export and Import commands
        4. Export comparison
        5. Import comparison
      7. User-Managed Backup and Recovery (1/2)
      8. User-Managed Backup and Recovery (2/2)
        1. Archivelog mode
        2. What files should be backed up?
        3. Backing up datafiles
        4. Backing up log files
        5. Backing up the control file
        6. Backing up miscellaneous files
        7. Restoring datafiles
        8. Restoring the control file
        9. Tablespace point-in-time recovery
      9. Backup and Recovery Commands (1/2)
      10. Backup and Recovery Commands (2/2)
        1. ALTER DATABASE BACKUP CONTROLFILE
        2. ALTER DATABASE OPEN
        3. ALTER SYSTEM
        4. CREATE CONTROLFILE
        5. DBVERIFY
        6. OCOPY
        7. RECOVER
        8. STARTUP MOUNT
      11. Recovery Manager (1/2)
      12. Recovery Manager (2/2)
        1. RMAN fundamentals
        2. Running RMAN
        3. Using RMAN scripts
        4. RMAN commands
    8. Security
      1. Authentication
        1. CREATE USER
        2. ALTER USER
      2. Profiles
        1. CREATE PROFILE
        2. ALTER PROFILE
        3. DROP PROFILE
      3. Privileges (1/3)
      4. Privileges (2/3)
      5. Privileges (3/3)
        1. System privileges
        2. AUDIT
        3. CLUSTER
        4. CONTEXT
        5. DATABASE
        6. DATABASE LINKS
        7. DEBUG
        8. DIMENSION
        9. DIRECTORY
        10. INDEX
        11. INDEXTYPE
        12. LIBRARY
        13. MATERIALIZED VIEW
        14. OPERATOR
        15. OUTLINE
        16. PROCEDURE
        17. PROFILE
        18. RESOURCE COST
        19. ROLE
        20. ROLLBACK SEGMENT
        21. SEQUENCE
        22. SESSION
        23. SYNONYM
        24. SYSTEM
        25. TABLE
        26. TABLESPACES
        27. TRIGGER
        28. TYPES
        29. USER
        30. VIEW
        31. Miscellaneous privileges
        32. Special system privileges
        33. Schema object privileges
        34. Directories
        35. External tables
        36. Indextypes
        37. Libraries
        38. Materialized views
        39. Operators
        40. Procedures, functions, and packages
        41. Sequences
        42. Tables
        43. User-defined types
        44. Views
        45. Privilege commands
        46. GRANT
        47. REVOKE
      6. Roles
        1. CREATE ROLE
        2. ALTER ROLE
        3. DROP ROLE
        4. SET ROLE
      7. Auditing (1/2)
      8. Auditing (2/2)
        1. AUDIT
        2. NOAUDIT
      9. Other Security Features
        1. Views
        2. Stored procedures
        3. Fine-grained access control and security policy
        4. Virtual Private Database
        5. Label security and Policy Manager
        6. Application contexts
        7. Fine-grained auditing
        8. LogMiner
        9. Oracle Advanced Security
        10. Oracle Internet Directory
        11. Invoker rights
    9. The Data Dictionary
      1. Static Views (1/3)
      2. Static Views (2/3)
      3. Static Views (3/3)
        1. Families of views
        2. Advisor views
        3. Change Data Capture views
        4. Constraint views
        5. Data dictionary views
        6. Index views
        7. Jobs and Advanced Queuing views
        8. Lock views
        9. Log group views
        10. Materialized view views
        11. Networking and distributed transaction views
        12. Objects Option views
        13. Partitioning views
        14. Programming and PL/SQL views
        15. Replication views
        16. Scheduler views
        17. Security and auditing views
        18. Server information views
        19. SQLJ views
        20. Storage views
        21. Streams views
        22. Table, column, and view views
      4. Dynamic Views
        1. Availability of dynamic views
        2. How dynamic views are built
        3. Global dynamic performance data dictionary views
  3. Index (1/2)
  4. Index (2/2)

Product information

  • Title: Oracle DBA Pocket Guide
  • Author(s): David C. Kreines
  • Release date: August 2005
  • Publisher(s): O'Reilly Media, Inc.
  • ISBN: 9780596528843