Oracle database 12c DBA handbook /

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Bryla, Bob (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York : McGraw-Hill Education, [2015]
Temas:
Oracle (Computer file)
Database management.
Relational databases.
Bases de données > Gestion.
Bases de données relationnelles.
Database management
Relational databases
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • Title Page
  • Copyright Page
  • Dedication
  • Contents at a Glance
  • Contents
  • Acknowledgments
  • Introduction
  • Part I Database Architecture
  • 1 Getting Started with the Oracle Architecture
  • An Overview of Databases and Instances
  • Databases
  • Instances
  • Oracle Logical Storage Structures
  • Tablespaces
  • Blocks
  • Extents
  • Segments
  • Oracle Logical Database Structures
  • Tables
  • Constraints
  • Indexes
  • Views
  • Users and Schemas
  • Profiles
  • Sequences
  • Synonyms
  • PL/SQL
  • External File Access
  • Database Links and Remote Databases
  • Oracle Physical Storage Structures
  • Datafiles
  • Redo Log Files
  • Control Files
  • Archived Log Files
  • Initialization Parameter Files
  • Alert and Trace Log Files
  • Backup Files
  • Oracle Managed Files
  • Password Files
  • Multiplexing Database Files
  • Automatic Storage Management
  • Manual Multiplexing
  • Oracle Memory Structures
  • System Global Area
  • Program Global Area
  • Software Code Area
  • Background Processes
  • Backup/Recovery Overview
  • Export/Import
  • Offline Backups
  • Online Backups
  • RMAN
  • Security Capabilities
  • Privileges and Roles
  • Auditing
  • Fine-Grained Auditing
  • Virtual Private Database
  • Label Security
  • Real Application Clusters
  • Oracle Streams
  • Oracle Enterprise Manager
  • Oracle Initialization Parameters
  • Basic Initialization Parameters
  • Advanced Initialization Parameters
  • Summary
  • 2 Upgrading to Oracle Database 12c
  • Choosing an Upgrade Method
  • Before Upgrading
  • Using the Database Upgrade Assistant
  • Performing a Manual Direct Upgrade
  • Using Data Pump Export and Import
  • Export and Import Versions to Use
  • Performing the Upgrade
  • Using the Data-Copying Method
  • After Upgrading
  • Summary
  • 3 Planning and Managing Tablespaces
  • Tablespace Architecture
  • Tablespace Types
  • Optimal Flexible Architecture
  • Oracle Installation Tablespaces
  • SYSTEM
  • SYSAUX
  • TEMP
  • UNDOTBS1
  • USERS
  • EXAMPLE
  • Segment Segregation
  • Summary
  • 4 Physical Database Layouts and Storage Management
  • Traditional Disk Space Storage
  • Resizing Tablespaces and Datafiles
  • Moving Datafiles
  • Moving Online Redo Log Files
  • Moving Control Files
  • Automatic Storage Management
  • ASM Architecture
  • Creating an ASM Instance
  • ASM Instance Components
  • ASM Dynamic Performance Views
  • ASM Filename Formats
  • ASM File Types and Templates
  • Administering ASM Disk Groups
  • Summary
  • Part II Database Management
  • 5 Developing and Implementing Applications
  • Tuning by Design: Best Practices
  • Do As Little As Possible
  • Do It As Simply As Possible
  • Tell the Database What It Needs to Know
  • Maximize the Throughput in the Environment
  • Divide and Conquer Your Data
  • Test Correctly
  • Standard Deliverables
  • Resource Management
  • Implementing the Database Resource Manager
  • Sizing Database Objects
  • Using Global Temporary Tables

Ejemplares similares