Home Page Icon
Home Page
Table of Contents for
Title
Close
Title
by Ignatius Fernandez
Beginning Oracle Database 12c Administration: From Novice to Professional, Second Edition
Cover
Title
Copyright
Dedication
About IOUG Press
Contents at a Glance
Contents
About the Author
About the Technical Reviewer
Acknowledgments
Foreword to the First Edition
Introduction
Part I: Database Concepts
Chapter 1: Relational Database Management Systems
A First Look at Oracle Database 12c
What Is a Database?
What Is a Relational Database?
The Secret Sauce
Examples of Relational Operations
Efficiency of Relational Operators
Query Optimization
What Is a Database Management System?
Transaction Management
The Atomicity Property of Transactions
The Consistency Property of Transactions
The Isolation Property of Transactions
The Durability Property of Transactions
Data Integrity
Data Security
What Makes a Relational Database Management System Relational?
Summary
Further Reading
Chapter 2: SQL and PL/SQL by Example
Railroad Diagrams
Types of SQL
Data Definition Language
Database Manipulation Language
Embedded SQL
SQL*Plus and SQL Developer
Criticisms of SQL
Duplicates
Redundancy
Nullable Data Items
Introduction to PL/SQL
Summary
Exercises
Further Reading
Chapter 3: Oracle Architecture
Database vs. Instance
Database
Software
Configuration Files
Data Files
Temporary Files
Redo Log Files
Archived Redo Log Files
Control File
Event Logs
Database Backups
Instance
System Global Area
Buffer Cache
Shared Pool
Log Buffer
Server Processes
Background Processes
One-to-Many Configuration
Many-to-One Architecture
Life Cycle of a Database Session
Summary
Exercises
Further Reading
Part II: Database Implementation
Chapter 4: Planning
Licensing
Practical Example
Free to Download, Free to Learn, Unlimited Evaluation
Database Editions
Architectural Choices
Dedicated Server
Shared Server
Real Application Clusters
Standby Database
Maximum Availability Architecture (MAA)
Sizing
Disk Sizing
Other Disk Considerations
Memory Sizing
CPU Sizing
Network Sizing
Modern Options
Engineered Systems
Cloud Computing
Summary
Further Reading
Chapter 5: Software Installation
Oracle Technology Network
The Forgotten Manuals
Prerequisites and Preinstallation Requirements
Client Installations
Instant Client
SQL Developer
Server Installations
Oracle Database Examples
Summary
Chapter 6: Database Creation
Creating and Configuring a Listener
Creating and Configuring a Database
Common Options
Initialization Parameters
Data Files
Control Files
Redo Log Groups
Basic Database Administration Tasks
Stopping the Database
Stopping the Listener
Starting the Listener
Starting the Database
Enterprise Manager Database Express
Summary
Chapter 7: Physical Database Design
Indexes
Unique vs. Non-Unique Indexes
Concatenated Indexes
Function-Based Indexes
Structure of an Index
What Indexes to Create?
Index-Organized Tables
Advanced Topics
Partitioning
Advantages of Partitioning
List Partitioning
Range Partitioning
Interval Partitioning
Hash Partitioning
Reference Partitioning
Composite Partitioning
Local and Global Indexes
Partitioned Views
Denormalization and Materialized Views
Clusters
Summary
Chapter 8: User Management and Data Loading
Schemas
User Management
Creating Users
Giving Permissions to Users
Revoking Permissions Granted to Users
Modifying User Attributes
Removing Users
Data Loading
The Export and Import Utilities
The Data Pump Utilities
SQL*Loader
Summary
Part III: Database Support
Chapter 9: Taking Control
Enterprise Manager
SQL Developer
Remote Diagnostic Agent
Dictionary Tables and Views
Third-Party Tools
Summary
Exercises
Chapter 10: Monitoring
Monitoring Database Availability
Monitoring Changes
Monitoring Security
Monitoring Backups
Monitoring Growth
Monitoring Workload
Monitoring Performance
Monitoring Capacity
Third-Party Tools
Summary
Exercises
Further Reading
Chapter 11: Fixing Problems
Systematic Five-Step Problem-Solving Method
The Book We All Want and Best Practices for Problem Management
Real-Life Example: Unresponsive Listener
Define the Problem
Investigate and Analyze the Problem
Solve and Implement the Problem
One Week Later
Opportunities for Improvement
Incident Management vs. Problem Management
Internet Resources
Working with Oracle Support
Remote Diagnostic Agent (RDA)
ORAchk Oracle Configuration Audit Tool
Automatic Diagnostic Repository (ADR)
Error Codes
Four Errors
ORA-01555: Snapshot Too Old
ORA-00060: Deadlock Detected
ORA-00600: Internal Error Code
ORA-07445: Exception Encountered
Summary
Exercises
Chapter 12: Backups
Why Do You Need Backups?
Types of Backup
Tape Backups vs. Disk Backups
Full Backups vs. Partial Backups
Level 0 Backups vs. Level 1 Backups
Physical Backups vs. Logical Backups
Consistent Backups vs. Inconsistent Backups
Hot vs. Cold Backups
Oracle-Managed Backups vs. User-Managed Backups
Practical Demonstration: Physical Backups
Practical Demonstration: Logical Backups
Common RMAN Commands
Horror Stories
Summary
Exercises
Chapter 13: Recovery
Horror Stories
Types of Recovery
Restore vs. Recover
Full Recovery vs. Partial Recovery
Complete Recovery vs. Incomplete Recovery
Traditional vs. Flashback
Physical Recovery vs. Logical Recovery
Flashback Technology
Flashback Query
Flashback Versions
Flashback Transaction
Flashback Table
Flashback Drop
Flashback Data Archive
Flashback Database
LogMiner
Data Recovery Advisor
Documentation and Testing
Summary
Exercises
Chapter 14: Database Maintenance
The Maintenance Plan
Backups
Generic Best Practices for Database Backups
Best Practices for Oracle Database Backups
Statistics
Archiving and Purging
Rebuilding
Log File Maintenance
Auditing
User Management
Capacity Management
Time Series
Patching
Summary
Exercises
Chapter 15: The Big Picture and the Ten Deliverables
An Instructive Job Interview
How I Became a DBA
ITIL
The Big Picture
IT Service Management Processes
Start with the End in Mind: The Ten Deliverables
The Book You Really Need and the Art of the SOP
Benefits of SOPs
Structure of an SOP
Suggested SOPs
Summary
Exercises
Further Reading
Part IV: Database Tuning
Chapter 16: Database Tuning
Using a Systematic Five-Step Tuning Method
Analyzing DB Time
Understanding the Oracle Wait Interface
V$SYSSTAT and V$SESSTAT
V$SESSION_EVENT and V$SYSTEM_EVENT
Mining the Statspack Repository
Using the Statspack Report
Summary
Exercises
Further Reading
Chapter 17: SQL Tuning
Defining Efficiency
Identifying Inefficient SQL Statements
Understanding the Causes of Inefficient SQL
Ways to Improve SQL
Indexes
Hints
Statistics
Tuning by Example
Creating and Populating the Tables
Establishing a Baseline
Examining the Query Plan
Indexes and Statistics
Using SQL Access Advisor
Optimizer Hints
Extreme Tuning
But Wait, There’s More!
Summary
Exercises
Index
General
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Cover
Next
Next Chapter
Copyright
Beginning Oracle Database 12c Administration
From Novice to Professional
Second Edition
Ignatius Fernandez
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset