Limit search to available items
Book Cover
E-book
Author Kyte, Thomas, author

Title Expert Oracle database architecture / Thomas Kyte, Darl Kuhn
Edition Third edition
Published New York : Apress, [2014]
New York : Distributed to the Book trade worldwide by Springer Science+Business Media New York
©2014

Copies

Description 1 online resource (1 volume) : illustrations
Series Expert's Voice in Oracle
Expert's voice in Oracle.
Contents Machine generated contents note: ch. 1 Developing Successful Oracle Applications -- My Approach -- Black Box Approach -- How (and How Not) to Develop Database Applications -- Understanding Oracle Architecture -- Understanding Concurrency Control -- Multiversioning -- Database Independence? -- How Do I Make It Run Faster? -- DBA-Developer Relationship -- Summary -- ch. 2 Architecture Overview -- Defining Database and Instance -- SGA and Background Processes -- Connecting to Oracle -- Dedicated Server -- Shared Server -- Mechanics of Connecting over TCP/IP -- Pluggable Databases -- Reduced Resource Utilization -- Reduced Maintenance -- How Is a Pluggable Database Different? -- Summary -- ch. 3 Files -- Parameter Files -- What Are Parameters? -- Legacy init.ora Parameter Files -- Server Parameter Files (SPFILEs) -- Converting to SPFILEs -- Trace Files -- Requested Trace Files -- Trace Files Generated in Response to Internal Errors -- Trace File Wrap-up -- Alert File -- Data Files -- Brief Review of File System Mechanisms -- Storage Hierarchy in an Oracle Database -- Dictionary-Managed and Locally-Managed Tablespaces -- Temp Files -- Control Files -- Redo Log Files -- Online Redo Log -- Archived Redo Log -- Password Files -- Change Tracking File -- Flashback Logs -- Flashback Database -- Fast Recovery Area -- DMP Files (EXP/IMP Files) -- Data Pump Files -- Flat Files -- Summary -- ch. 4 Memory Structures -- Process Global Area and User Global Area -- Manual PGA Memory Management -- Automatic PGA Memory Management -- Choosing Between Manual and Auto Memory Management -- PGA and UGA Wrap-up -- System Global Area -- Fixed SGA -- Redo Buffer -- Block Buffer Cache -- Shared Pool -- Large Pool -- Java Pool -- Streams Pool -- SGA Memory Management -- Summary -- ch. 5 Oracle Processes -- Server Processes -- Dedicated Server Connections -- Shared Server Connections -- Database Resident Connection Pooling (DRCP) -- Connections vs. Sessions -- Dedicated Server vs. Shared Server vs. DRCP -- Dedicated/Shared Server Wrap-up -- Background Processes -- Focused Background Processes -- Utility Background Processes -- Implications of Multiversion Read Consistency -- Common Data Warehousing Technique That Fails -- Explanation for Higher Than Expected I/O on Hot Tables -- Write Consistency -- Consistent Reads and Current Reads -- Seeing a Restart -- Why Is a Restart Important to Us? -- Summary -- ch. 8 Transactions -- Transaction Control Statements -- Atomicity -- Statement-Level Atomicity -- Procedure-Level Atomicity -- Transaction-Level Atomicity -- DDL and Atomicity -- Durability -- WRITE Extensions to COMMIT -- COMMITS in a Nondistributed PL/SQL Block -- Integrity Constraints and Transactions -- IMMEDIATE Constraints -- DEFERRABLE Constraints and Cascading Updates -- Bad Transaction Habits -- Committing in a Loop -- Using Autocommit -- Distributed Transactions -- Autonomous Transactions -- How Autonomous Transactions Work -- When to Use Autonomous Transactions -- Summary -- ch. 9 Redo and Undo -- What Is Redo? -- What Is Undo? -- How Redo and Undo Work Together -- Example INSERT-UPDATE-DELETE-COMMIT Scenario -- Commit and Rollback Processing -- What Does a COMMIT Do? -- What Does a ROLLBACK Do? -- Investigating Redo -- Measuring Redo -- Can I Turn Off Redo Log Generation? -- Why Can't I Allocate a New Log? -- Block Cleanout -- Log Contention -- Temporary Tables and Redo/Undo -- Investigating Undo -- What Generates the Most and Least Undo? -- ORA-01555: Snapshot Too Old Error -- Summary -- ch. 10 Database Tables -- Types of Tables -- Terminology -- Segment -- Segment Space Management -- High-water Mark -- FREEUSTS -- PCTFREE and PCTUSED -- LOGGING and NOLOGGING -- INITRANS and MAXTRANS -- Heap Organized Tables -- Index Organized Tables -- Index Organized Tables Wrap-up -- Index Clustered Tables -- Index Clustered Tables Wrap-up -- Hash Clustered Tables -- Hash Clustered Tables Wrap-up -- Sorted Hash Clustered Tables -- Nested Tables -- Nested Tables Syntax -- Nested Table Storage -- Nested Tables Wrap-up -- Temporary Tables -- Statistics Prior to 12c -- Statistics Starting with 12c -- Temporary Tables Wrap-up -- Object Tables -- Object Tables Wrap-up -- Summary -- ch. 11 Indexes -- Overview of Oracle Indexes -- B*Tree Indexes -- Index Key Compression -- Reverse Key Indexes -- Descending Indexes -- When Should You Use a B*Tree Index? -- B*Trees Wrap-up -- Bitmap Indexes -- When Should You Use a Bitmap Index? -- Bitmap Join Indexes -- Bitmap Indexes Wrap-up -- Function-Based Indexes -- Simple Function-Based Index Example -- Indexing Only Some of the Rows -- Implementing Selective Uniqueness -- Caveat Regarding ORA-01743 -- Function-Based Indexes Wrap-up -- Application Domain Indexes -- Invisible Indexes -- Multiple Indexes on the Same Column Combinations -- Indexing Extended Columns -- Virtual Column Solution -- Function-Based Index Solution -- Frequently Asked Questions and Myths About Indexes -- Do Indexes Work on Views? -- Do Nulls and Indexes Work Together? -- Should Foreign Keys Be Indexed? -- Why Isn't My Index Getting Used? -- Myth: Space Is Never Reused in an Index -- Myth: Most Discriminating Elements Should Be First -- Summary -- ch. 12 Datatypes -- Overview of Oracle Datatypes -- Character and Binary String Types -- NLS Overview -- Character Strings -- Binary Strings: RAW Types -- Extended Datatypes -- Number Types -- NUMBER Type Syntax and Usage -- BINARY_FLOAT/BINARY_DOUBLE Type Syntax and Usage -- Non-Native Number Types -- Performance Considerations -- Long Types -- Restrictions on LONG and LONG RAW Types -- Coping with Legacy LONG Types -- Dates, Timestamps, and Interval Types -- Formats -- DATE Type -- TIMESTAMP Type -- INTERVAL Type -- LOB Types -- Internal LOBs -- BFILEs -- ROWID/UROWID Types -- Summary -- ch. 13 Partitioning -- Partitioning Overview -- Increased Availability -- Reduced Administrative Burden -- Enhanced Statement Performance -- Reduced Contention in an OLTP System -- Table Partitioning Schemes -- Range Partitioning -- Hash Partitioning -- List Partitioning -- Interval Partitioning -- Reference Partitioning -- Interval Reference Partitioning -- Virtual Column Partitioning -- Composite Partitioning -- Row Movement -- Table Partitioning Schemes Wrap-up -- Partitioning Indexes -- Local Indexes vs. Global Indexes -- Local Indexes -- Global Indexes -- Partial Indexes -- Partitioning and Performance, Revisited -- Ease of Maintenance Features -- Multiple Partition Maintenance Operations -- Cascade Truncate -- Cascade Exchange -- Auditing and Segment Space Compression -- Summary -- ch. 14 Parallel Execution -- When to Use Parallel Execution -- Parallel Processing Analogy -- Oracle Exadata -- Parallel Query -- Parallel DML -- Parallel DDL -- Parallel DDL and Data Loading Using External Tables -- Parallel DDL and Extent Trimming -- Procedural Parallelism -- Parallel Pipelined Functions -- Do-It-Yourself Parallelism -- Old School Do-It-Yourself Parallelism -- Summary -- ch. 15 Data Loading and Unloading -- External Tables -- Setting Up External Tables -- Dealing with Errors -- Using an External Table to Load Different Files -- Multiuser Issues -- Preprocessing -- External Tables Summary -- Data Pump Unload -- SQLLDR -- Loading Data with SQLLDR FAQs -- SQLLDR Caveats -- SQLLDR Summary -- Flat File Unload -- Summary
Summary This fully revised third edition covers the developments up to Oracle Database 12c. Significant new content is included surrounding Oracle's new cloud feature set, and especially the use of pluggable databases. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. Readers will learn how to develop an evidence-based approach to problem solving; manage transactions in highly concurrent environments; speed access to data through table and index design; manage files and memory structures for performance and reliability; scale up through partitioning and parallel processing; and load and unload data to interface with external systems. -- Edited summary from book
Notes Includes index
English
Online resource; title from title page (Safari, viewed December 6, 2014)
SUBJECT Oracle (Computer file) http://id.loc.gov/authorities/names/n91015760
Oracle (Computer file) fast
Subject Relational databases.
Relational databases
Form Electronic book
Author Kuhn, Darl, author
ISBN 1430262982
9781430262985
9781430262992
1430262990