Oracle 12c For Dummies^®

Visit www.dummies.com/cheatsheet/oracle12 to view this book's cheat sheet.

Table of Contents

Introduction

About This Book

Who Are You?

Icons in This Book

Beyond the Book

Where to Go from Here

Part I: Getting Started with Oracle 12c

Chapter 1: Discovering Databases and Oracle 12c

Discovering Databases

Defining a database

Examining how databases work

Finding the right database for the job

Choosing Oracle

Oracle as a database

What is the “c” in Oracle 12c?

Keeping a Database Safe and Sound

DBA responsibilities

Common tasks

Chapter 2: Understanding Oracle Database Architecture

Defining Databases and Instances

Deconstructing the Oracle Architecture

Walking Down Oracle Memory Structures

Trotting around the System Global Area

Shared pool

Database buffer cache

Redo log buffer

Large pool

Java pool

Streams pool

Program Global Area

Managing Memory

Managing memory automatically

Following the Oracle Processes

Background processes

User and server processes

Getting Physical with Files

Data files: Where the data meets the disk

Control files

Redo log files

Moving to the archives

Server and initialization parameter files

Applying Some Logical Structures

Tablespaces

Segments

Extents

Oracle blocks

Pluggable Databases

Chapter 3: Preparing to Implement Oracle

Understanding How an Oracle Database Fits into a System’s Architecture

Client-server applications

Multi-tier applications

Component configurations

Verifying System Requirements

User and directory requirements

Hardware requirements ...