Update cookies preferences

E-book: Beginning Oracle Database 12c Administration: From Novice to Professional

  • Format: PDF+DRM
  • Pub. Date: 20-Jul-2015
  • Publisher: APress
  • Language: eng
  • ISBN-13: 9781484201930
Other books in subject:
  • Format - PDF+DRM
  • Price: 92,01 €*
  • * the price is final i.e. no additional discount will apply
  • Add to basket
  • Add to Wishlist
  • This ebook is for personal use only. E-Books are non-refundable.
Beginning Oracle Database 12c Administration: From Novice to ProfessionalLarger Image
  • Format: PDF+DRM
  • Pub. Date: 20-Jul-2015
  • Publisher: APress
  • Language: eng
  • ISBN-13: 9781484201930
Other books in subject:

DRM restrictions

  • Copying (copy/paste):

    not allowed

  • Printing:

    not allowed

  • Usage:

    Digital Rights Management (DRM)
    The publisher has supplied this book in encrypted form, which means that you need to install free software in order to unlock and read it.  To read this e-book you have to create Adobe ID More info here. Ebook can be read and downloaded up to 6 devices (single user with the same Adobe ID).

    Required software
    To read this ebook on a mobile device (phone or tablet) you'll need to install this free app: PocketBook Reader (iOS / Android)

    To download and read this eBook on a PC or Mac you need Adobe Digital Editions (This is a free app specially developed for eBooks. It's not the same as Adobe Reader, which you probably already have on your computer.)

    You can't read this ebook with Amazon Kindle

Beginning Oracle Database 12c Administration is your entry point into a successful and satisfying career as an Oracle Database Administrator.

The chapters of this book are logically organized into four parts closely tracking the way your database administration career will naturally evolve. Part 1 "Database Concepts" gives necessary background in relational database theory and Oracle Database concepts, Part 2 "Database Implementation" teaches how to implement an Oracle database correctly, Part 3 "Database Support" exposes you to the daily routine of a database administrator, and Part 4 "Database Tuning" introduces the fine art of performance tuning.

Beginning Oracle Database 12c Administration provides information that you won't find in other books on Oracle Database. You'll discover not only technical information, but also guidance on work practices that are as vital to your success as are your technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." (It is the editor’s favorite chapter too!) If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible.

You will grasp the key aspects of theory behind relational database management systems and learn how to:

• Install and configure an Oracle database, and ensure that it’s properly licensed;

• Execute common management tasks in a Linux environment;

• Defend against data loss by implementing sound backup and recovery practices; and

• Improve database and query performance.

About the Author xix
About the Technical Reviewer xxi
Acknowledgments xxiii
Foreword to the First Edition xxv
Introduction xxvii
Part I Database Concepts
1(58)
Chapter 1 Relational Database Management Systems
3(22)
A First Look at Oracle Database 12c
4(4)
What Is a Database?
8(1)
What Is a Relational Database?
9(11)
The Secret Sauce
12(1)
Examples of Relational Operations
13(6)
Efficiency of Relational Operators
19(1)
Query Optimization
19(1)
What Is a Database Management System?
20(2)
Transaction Management
20(1)
The Atomicity Property of Transactions
21(1)
The Consistency Property of Transactions
21(1)
The Isolation Property of Transactions
21(1)
The Durability Property of Transactions
21(1)
Data Integrity
21(1)
Data Security
22(1)
What Makes a Relational Database Management System Relational?
22(1)
Summary
23(1)
Further Reading
24(1)
Chapter 2 SQL and PL/SQL by Example
25(22)
Railroad Diagrams
27(3)
Types of SQL
30(4)
Data Definition Language
30(1)
Database Manipulation Language
31(3)
Embedded SQL
34(1)
SQL*Plus and SQL Developer
35(1)
Criticisms of SQL
36(4)
Duplicates
37(1)
Redundancy
37(3)
Nullable Data Items
40(1)
Introduction to PL/SQL
40(5)
Summary
45(1)
Exercises
45(1)
Further Reading
46(1)
Chapter 3 Oracle Architecture
47(12)
Database vs. Instance
49(1)
Database
49(2)
Software
49(1)
Configuration Files
49(1)
Data Files
49(1)
Temporary Files
50(1)
Redo Log Files
50(1)
Archived Redo Log Files
50(1)
Control File
51(1)
Event Logs
51(1)
Database Backups
51(1)
Instance
51(2)
System Global Area
51(1)
Buffer Cache
52(1)
Shared Pool
52(1)
Log Buffer
52(1)
Server Processes
52(1)
Background Processes
52(1)
One-to-Many Configuration
53(1)
Many-to-One Architecture
54(1)
Life Cycle of a Database Session
55(1)
Summary
56(1)
Exercises
57(1)
Further Reading
58(1)
Part II Database Implementation
59(100)
Chapter 4 Planning
61(12)
Licensing
61(3)
Practical Example
61(2)
Free to Download, Free to Learn, Unlimited Evaluation
63(1)
Database Editions
63(1)
Architectural Choices
64(2)
Dedicated Server
64(1)
Shared Server
65(1)
Real Application Clusters
65(1)
Standby Database
65(1)
Maximum Availability Architecture (MAA)
66(1)
Sizing
66(3)
Disk Sizing
66(1)
Other Disk Considerations
67(1)
Memory Sizing
68(1)
CPU Sizing
69(1)
Network Sizing
69(1)
Modem Options
69(2)
Engineered Systems
69(1)
Cloud Computing
70(1)
Summary
71(1)
Further Reading
72(1)
Chapter 5 Software Installation
73(18)
Oracle Technology Network
74(1)
The Forgotten Manuals
74(1)
Prerequisites and Preinstallation Requirements
74(1)
Client Installations
75(1)
Instant Client
75(3)
SQL Developer
78(2)
Server Installations
80(9)
Oracle Database Examples
89(1)
Summary
90(1)
Chapter 6 Database Creation
91(26)
Creating and Configuring a Listener
92(5)
Creating and Configuring a Database
97(15)
Common Options
110(1)
Initialization Parameters
111(1)
Data Files
111(1)
Control Files
112(1)
Redo Log Groups
112(1)
Basic Database Administration Tasks
112(4)
Stopping the Database
112(1)
Stopping the Listener
113(1)
Starting the Listener
113(1)
Starting the Database
114(1)
Enterprise Manager Database Express
114(2)
Summary
116(1)
Chapter 7 Physical Database Design
117(18)
Indexes
117(4)
Unique vs. Non-Unique Indexes
118(1)
Concatenated Indexes
118(1)
Function-Based Indexes
119(1)
Structure of an Index
119(1)
What Indexes to Create?
120(1)
Index-Organized Tables
121(1)
Advanced Topics
121(1)
Partitioning
121(9)
Advantages of Partitioning
122(1)
List Partitioning
122(1)
Range Partitioning
123(1)
Interval Partitioning
123(1)
Hash Partitioning
124(1)
Reference Partitioning
124(1)
Composite Partitioning
125(1)
Local and Global Indexes
126(1)
Partitioned Views
126(4)
Denormalization and Materialized Views
130(1)
Clusters
131(1)
Summary
132(3)
Chapter 8 User Management and Data Loading
135(24)
Schemas
135(6)
User Management
141(8)
Creating Users
141(3)
Giving Permissions to Users
144(4)
Revoking Permissions Granted to Users
148(1)
Modifying User Attributes
148(1)
Removing Users
148(1)
Data Loading
149(9)
The Export and Import Utilities
149(4)
The Data Pump Utilities
153(3)
SQL*Loader
156(2)
Summary
158(1)
Part III Database Support
159(132)
Chapter 9 Taking Control
161(14)
Enterprise Manager
162(1)
SQL Developer
163(3)
Remote Diagnostic Agent
166(2)
Dictionary Tables and Views
168(3)
Third-Party Tools
171(1)
Summary
172(1)
Exercises
173(2)
Chapter 10 Monitoring
175(16)
Monitoring Database Availability
176(2)
Monitoring Changes
178(1)
Monitoring Security
179(1)
Monitoring Backups
180(1)
Monitoring Growth
180(2)
Monitoring Workload
182(3)
Monitoring Performance
185(2)
Monitoring Capacity
187(2)
Third-Party Tools
189(1)
Summary
189(1)
Exercises
190(1)
Further Reading
190(1)
Chapter 11 Fixing Problems
191(26)
Systematic Five-Step Problem-Solving Method
193(1)
The Book We All Want and Best Practices for Problem Management
194(2)
Real-Life Example: Unresponsive Listener
196(4)
Define the Problem
196(1)
Investigate and Analyze the Problem
197(1)
Solve and Implement the Problem
198(1)
One Week Later
199(1)
Opportunities for Improvement
199(1)
Incident Management vs. Problem Management
200(1)
Internet Resources
200(3)
Working with Oracle Support
203(4)
Remote Diagnostic Agent (RDA)
204(1)
ORAchk Oracle Configuration Audit Tool
205(2)
Automatic Diagnostic Repository (ADR)
207(1)
Error Codes
207(2)
Four Errors
209(6)
ORA-01555: Snapshot Too Old
209(1)
ORA-00060: Deadlock Detected
210(1)
ORA-00600: Internal Error Code
211(3)
ORA-07445: Exception Encountered
214(1)
Summary
215(1)
Exercises
216(1)
Chapter 12 Backups
217(18)
Why Do You Need Backups?
217(2)
Types of Backup
219(2)
Tape Backups vs. Disk Backups
219(1)
Full Backups vs. Partial Backups
219(1)
Level 0 Backups vs. Level 1 Backups
220(1)
Physical Backups vs. Logical Backups
220(1)
Consistent Backups vs. Inconsistent Backups
220(1)
Hot vs. Cold Backups
220(1)
Oracle-Managed Backups vs. User-Managed Backups
220(1)
Practical Demonstration: Physical Backups
221(5)
Practical Demonstration: Logical Backups
226(2)
Common RMAN Commands
228(4)
Horror Stories
232(1)
Summary
233(1)
Exercises
233(2)
Chapter 13 Recovery
235(18)
Horror Stories
235(1)
Types of Recovery
236(2)
Restore vs. Recover
236(1)
Full Recovery vs. Partial Recovery
236(1)
Complete Recovery vs. Incomplete Recovery
237(1)
Traditional vs. Flashback
237(1)
Physical Recovery vs. Logical Recovery
237(1)
Flashback Technology
238(5)
Flashback Query
238(1)
Flashback Versions
239(1)
Flashback Transaction
240(1)
Flashback Table
240(1)
Flashback Drop
241(1)
Flashback Data Archive
242(1)
Flashback Database
243(1)
LogMiner
243(1)
Data Recovery Advisor
244(5)
Documentation and Testing
249(1)
Summary
249(1)
Exercises
250(3)
Chapter 14 Database Maintenance
253(18)
The Maintenance Plan
253(1)
Backups
254(2)
Generic Best Practices for Database Backups
254(1)
Best Practices for Oracle Database Backups
255(1)
Statistics
256(1)
Archiving and Purging
256(2)
Rebuilding
257(1)
Log File Maintenance
258(2)
Auditing
260(2)
User Management
262(1)
Capacity Management
263(4)
Time Series
263(4)
Patching
267(1)
Summary
268(1)
Exercises
269(2)
Chapter 15 The Big Picture and the Ten Deliverables
271(20)
An Instructive Job Interview
272(1)
How I Became a DBA
273(2)
ITIL
275(5)
The Big Picture
275(1)
IT Service Management Processes
276(4)
Start with the End in Mind: The Ten Deliverables
280(1)
The Book You Really Need and the Art of the SOP
281(7)
Benefits of SOPs
282(2)
Structure of an SOP
284(3)
Suggested SOPs
287(1)
Summary
288(1)
Exercises
289(1)
Further Reading
289(2)
Part IV Database Tuning
291(50)
Chapter 16 Database Tuning
293(20)
Using a Systematic Five-Step Tuning Method
293(3)
Analyzing DB Time
296(4)
Understanding the Oracle Wait Interface
300(1)
V$SYSSTAT and V$SESSTAT
300(1)
V$SESSION_EVENT and V$SYSTEM_EVENT
301(1)
Mining the Statspack Repository
301(8)
Using the Statspack Report
309(1)
Summary
309(1)
Exercises
310(2)
Further Reading
312(1)
Chapter 17 SQL Tuning
313(28)
Defining Efficiency
313(1)
Identifying Inefficient SQL Statements
313(3)
Understanding the Causes of Inefficient SQL
316(1)
Ways to Improve SQL
317(4)
Indexes
317(1)
Hints
318(1)
Statistics
319(2)
Tuning by Example
321(17)
Creating and Populating the Tables
323(1)
Establishing a Baseline
324(5)
Examining the Query Plan
329(2)
Indexes and Statistics
331(1)
Using SQL Access Advisor
332(2)
Optimizer Hints
334(1)
Extreme Tuning
335(2)
But Wait, There's More!
337(1)
Summary
338(1)
Exercises
339(2)
Index 341
Iggy Fernandez has a rich history of working with Oracle Database in many capacities. He is the author of Beginning Oracle Database 11g Administration (Apress, 2009) and teaches Oracle database administration at University of Washington Professional & Continuing Education. He was the president of the Northern California Oracle Users Group (NoCOUG), the longest running and most active Oracle users group in the world. He writes regularly for the NoCOUG Journal and has been its editor for many years. Iggy's favorite topics are database performance and SQL performance, and he regularly speaks on these topics at Oracle conferences. He has a lot of opinions but is willing to change them when confronted with fresh facts. His favorite quote is "A foolish consistency is the hobgoblin of little minds, adored by little statesmen and philosophers and divines - Speak what you think now in hard words, and to-morrow speak what to-morrow thinks in hard words again, though it contradict every thing yousaid to-day." - Ralph Waldo Emerson. You can follow him online at http://iggyfernandez.wordpress.com/.
More information about ebooks More information about ebooks
Permanent link: https://www.kriso.ee/db/97814842019302e.html
Keywords: