SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK BEGINNING ORACLE DATABASE 12C ADMINISTRATION, 2ND EDITION
SUMMARY
-
Items Found: 534
- 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?
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Part III: Database Support
- Chapter 9: Taking Control
- Enterprise Manager
- SQL Developer
- Remote Diagnostic Agent
- Dictionary Tables and Views
- Third-Party Tools
- Exercises
- Chapter 10: Monitoring
- Monitoring Database Availability
- Monitoring Changes
- Monitoring Security
- Monitoring Backups
- Monitoring Growth
- Monitoring Workload
- Monitoring Performance
- Monitoring Capacity
- Third-Party Tools
- 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
- 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
- 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
- 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
- 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
- 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
- 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!
- 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?
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Part III: Database Support
- Chapter 9: Taking Control
- Enterprise Manager
- SQL Developer
- Remote Diagnostic Agent
- Dictionary Tables and Views
- Third-Party Tools
- Exercises
- Chapter 10: Monitoring
- Monitoring Database Availability
- Monitoring Changes
- Monitoring Security
- Monitoring Backups
- Monitoring Growth
- Monitoring Workload
- Monitoring Performance
- Monitoring Capacity
- Third-Party Tools
- 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
- 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
- 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
- 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
- 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
- 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
- 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!
