Muutke küpsiste eelistusi

Achieving Extreme Performance with Oracle Exadata [Pehme köide]

5.00/5 (4 hinnangut Goodreads-ist)
, , ,
  • Formaat: Paperback / softback, 432 pages, kõrgus x laius x paksus: 229x178x22 mm, kaal: 703 g, 50 Illustrations
  • Sari: Oracle Press
  • Ilmumisaeg: 16-Apr-2011
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0071752595
  • ISBN-13: 9780071752596
Teised raamatud teemal:
Achieving Extreme Performance with Oracle ExadataSuurem pilt
  • Formaat: Paperback / softback, 432 pages, kõrgus x laius x paksus: 229x178x22 mm, kaal: 703 g, 50 Illustrations
  • Sari: Oracle Press
  • Ilmumisaeg: 16-Apr-2011
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0071752595
  • ISBN-13: 9780071752596
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780071752596.html
Märksõnad:
"Leverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and migrationare included in this authoritative resource"--

"Maximize Oracle Exadata CapabilitiesLeverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and migration are included in this authoritative resource. Take advantage of the tightly integrated hardware and software in the Oracle Exadata Database Machine Work with Oracle Exadata software features, including Smart Scans, Oracle Exadata Hybrid Columnar Compression, storage indexes, Oracle Exadata Smart Flash Cache, and I/O Resource Manager Understand Oracle Exadata Database Machine balanced hardware architecture Architect, administer, and monitor Oracle Exadata Storage Servers Deploy data warehouses on the Oracle Exadata Database Machine Run online transaction processing (OLTP) workloads on the Oracle Exadata Database Machine Consolidate databases with and migrate databases to the Oracle Exadata Database Machine"--

"Maximize Oracle Exadata CapabilitiesLeverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and migration are included in this authoritative resource. Take advantage of the tightly integrated hardware and software in the Oracle Exadata Database Machine Work with Oracle Exadata software features, including Smart Scans, Oracle Exadata Hybrid Columnar Compression, storage indexes, Oracle Exadata Smart Flash Cache, and I/O Resource Manager Understand Oracle Exadata Database Machine balanced hardware architecture Architect, administer, and monitor Oracle Exadata Storage ServersDeploy data warehouses on the Oracle Exadata Database Machine Run online transaction processing (OLTP) workloads on the Oracle Exadata Database Machine Consolidate databases with and migrate databases to the Oracle Exadata Database Machine"--

Provided by publisher.

Leverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and migration are included in this authoritative resource.

-Take advantage of the tightly integrated hardware and software in the Oracle Exadata Database Machine

-Work with Oracle Exadata software features, including Smart Scans, Oracle Exadata Hybrid Columnar Compression, storage indexes, Oracle Exadata Smart Flash Cache, and I/O Resource Manager

-Understand Oracle Exadata Database Machine balanced hardware architecture

-Architect, administer, and monitor Oracle Exadata Storage Servers

-Implement high availability, backup, and recovery strategies

-Deploy data warehouses on the Oracle Exadata Database Machine

-Run online transaction processing (OLTP) workloads on the Oracle Exadata Database Machine

-Consolidate databases with and migrate databases to the Oracle Exadata Database Machine

The only Oracle Press guide to the powerful technology available in the Sun Oracle Database Machine and the Exadata Storage Server

Achieving Extreme Performance with Oracle Exadata and the Sun Oracle Database Machine is filled with best practices for deployments, hardware sizing, architecting the database machine environments for maximum availability, and backup and recovery. Oracle Database 11gR2 features used within these offerings, as well as migration options and paths for Oracle and non-Oracle databases to Oracle Exadata are covered. This Oracle Press guide also discusses architecture, administration, maintenance, monitoring, and tuning of Oracle Exadata Storage Servers and the Sun Oracle Database Machine.

Achieving Extreme Performance with Oracle Exadata and the Sun Oracle Database Machine

  • Covers Oracle Exadata concepts and best practices for deployments in enterprise data centers
  • Is written by experts who are educating the sales and technical teams at Oracle about Oracle Exadata and the Sun Oracle Database Machine
  • Contains all the information you need for successful implementation in one book

Expert coverage from Oracle Press
Features and Foundation; Oracle and Tightly Integrated Hardware and Software Platforms; Oracle 11g Enterprise Edition Software Features; Oracle Exadata Software Features; Sun Oracle Database Machine Hardware and Storage; Best Practices; Managing the Sun Oracle Database Machine; High Availability and Backup Strategies; Deploying Data Warehousing on the Sun Oracle Database Machine; Deploying OLTP, Batch, and Ad Hoc Workloads on the Sun Oracle Database Machine; Consolidating Databases with the Sun Oracle Database Machine; Migrating to the Sun Oracle Database Machine; Sample Source Environment Metrics; Exadata Capacity and Performance Specs

Foreword xv
Acknowledgments xvii
Introduction xix
Part I Features and Foundations
1 Oracle and Tightly Integrated Hardware and Software Platforms
3(16)
A History of Appliance-like Computing Solutions
5(2)
Oracle's Evolution Towards Integrated Hardware and Software
7(3)
Oracle Exadata Database Machine Fundamental Concepts
10(3)
Software Integration and the Oracle Exadata Database Machine
13(2)
Impact of the Platform on Personnel
15(2)
Future Directions
17(1)
Summary
18(1)
2 Oracle 11g Enterprise Edition Features
19(68)
Data Integrity and Performance
20(7)
Locks and Lock Management
22(1)
MVRC
23(3)
Flashback
26(1)
Real Application Clusters
27(10)
What Is RAC?
27(1)
RAC and Availability
28(1)
RAC and Scalability
29(1)
Cache Fusion
30(3)
Allocating Resources and RAC
33(3)
RAC One
36(1)
RAC and the Exadata Database Machine
36(1)
Automatic Storage Management
37(4)
What Is ASM?
37(2)
ASM and Performance
39(1)
ASM and Availability
39(1)
ASM and Management
40(1)
Partitioning
41(6)
What Is Partitioning?
41(1)
Partitioning Types
42(4)
Other Benefits
46(1)
Partitioning and the Exadata Database Machine
47(1)
Parallel Execution
47(16)
What Is Parallel Execution?
48(1)
What Can Be Parallelized?
48(1)
How Parallelism Works
49(3)
Partition-wise Parallel Joins
52(2)
How Do You Configure Parallel Execution?
54(1)
Degree of Parallelism
55(2)
Modifying DOP
57(2)
Ensuring DOP
59(2)
Parallelism and RAC
61(1)
In-memory Parallel Execution
62(1)
Parallelism and Exadata
62(1)
Data Guard
63(4)
What Is Data Guard?
63(1)
How Can Data Guard Be Implemented?
63(3)
Data Guard and Exadata
66(1)
Compression
67(2)
What Types of Compression Does Oracle Support?
67(1)
SecureFiles
68(1)
Benefits of Compression
68(1)
Database Resource Manager
69(4)
What Is Database Resource Manager?
69(1)
How Does Database Resource Manager Work?
70(1)
What Can Database Resource Manager Affect?
71(1)
Other Factors
72(1)
How Does Database Resource Manager Work with Exadata?
72(1)
Analysis Capabilities
73(1)
Analytic Functions
73(1)
Data Mining
73(1)
Enterprise Manager
74(3)
Data Movement
77(2)
Utilities
77(1)
Features
78(1)
Operating Systems
79(1)
Solaris Support
79(1)
Oracle Linux
80(1)
Other Oracle Database 11g Features
80(4)
Materialized Views
81(1)
Oracle OLAP
82(1)
Star Transformation
82(2)
Encryption
84(1)
Summary
84(3)
3 Exadata Software Features
87(38)
Smart Scan
89(7)
How Standard Queries Work
89(1)
How Smart Scan Queries Work
90(1)
Individual Tables
90(2)
Join Filtering
92(2)
Monitoring Savings from Smart Scan
94(2)
Other Offloaded Processing
96(3)
Fast File Creation
96(1)
Incremental Backup
97(1)
Data Mining Scoring
98(1)
Encryption
98(1)
Exadata Hybrid Columnar Compression
99(5)
What Is Exadata Hybrid Columnar Compression?
100(1)
How It Works
100(2)
Compression Options
102(1)
Decompression
102(1)
Advantages
103(1)
ILM and Oracle Compression
104(1)
Storage Indexes
104(3)
How Storage Indexes Work
105(1)
Storage Indexes at Work
106(1)
Exadata Smart Flash Cache
107(5)
What Is the Exadata Smart Flash Cache?
107(1)
How Can You Use the Exadata Smart Flash Cache?
108(1)
How Does Exadata Smart Flash Cache Determine What Is Cached?
109(2)
Exadata Smart Flash Cache Statistics
111(1)
Benefits from Exadata Smart Flash Cache
112(1)
I/O Resource Manager
112(6)
Benefits from I/O Resource Manager
113(1)
Architecture of an IORM Plan
113(2)
IORM at Work
115(3)
Interacting, with Exadata Storage Server Software
118(5)
Management Software Components
118(1)
Command Interfaces
119(1)
CellCLI
119(1)
dcli
120(1)
ADRCI
120(1)
CellCLI Command Overview
120(3)
Summary
123(2)
4 Oracle Exadata Database Machine Platform Hardware Components
125(24)
Latency and Balance
126(4)
Processor Speeds, Memory Capacity, and Storage
127(2)
How Hardware Components Work Together
129(1)
Oracle Exadata Database Machine Packaging Basics
130(7)
Installation and Initial Deployment Considerations
137(3)
Upgrade Choices for Existing Systems
140(1)
Connecting to the Database Machine
141(2)
Highly Available Hardware Considerations
143(1)
Summary
144(5)
Part II Best Practices
5 Managing the Exadata Database Machine
149(60)
Exadata Storage Server Architecture
151(11)
Database Server Software Components
151(2)
Exadata Storage Server Software Components
153(9)
Exadata Storage Server Administration
162(17)
Using CellCLI
163(2)
Exadata Storage Server OS Users and Privileges
165(1)
Using dcli
166(2)
Exadata Storage Server Setup
168(7)
Exadata Storage Server Security Configuration
175(4)
Exadata Storage Server Monitoring
179(28)
Monitoring with Metrics and Alerts
179(12)
Monitoring Active Requests
191(1)
Monitor Using the Oracle Database
192(4)
Monitoring with Oracle Enterprise Manager
196(9)
Oracle Integrated Lights Out Manager
205(2)
Summary
207(2)
6 High Availability and Backup Strategies
209(52)
Exadata Maximum Availability Architecture (MAA)
210(28)
High Availability with Oracle Data Guard
212(6)
Using Oracle GoldenGate with Database Machine
218(6)
Database Machine Patches and Upgrades
224(6)
Exadata Storage Server High Availability
230(2)
Preventing Data Corruption
232(6)
Exadata Database Machine Backup and Recovery Best Practices
238(21)
Backup Tools Best Practices
240(6)
Oracle Database Backup Strategy
246(11)
Database Recovery Best Practices
257(2)
Summary
259(2)
7 Deploying Data Warehouses on the Oracle Exadata Database Machine
261(32)
Data Warehousing Basics
263(5)
Generic Oracle Query Optimization
268(3)
Embedded Analytics in Oracle
271(4)
SQL Aggregation and Analytics Extensions
271(1)
OLAP
271(3)
Data Mining
274(1)
Unique Exadata Features for Optimal Query Response
275(3)
Data Warehousing Compression Techniques
278(1)
The Typical Life of a Query
279(1)
Best Practices for Data Loading
280(2)
Partitioning, Backups, and High Availability in Data Warehouses
282(1)
Data Models, Business Intelligence Tools, and Security
283(4)
Data Models
284(1)
Business Intelligence Tools
285(2)
Security Considerations
287(1)
Sizing the Platform for Data Warehousing and Justifying Purchase
287(3)
Summary
290(3)
8 Exadata and OLTP
293(22)
OLTP Workloads and Exadata Features
294(2)
Exadata Hardware and OLTP
296(5)
General Hardware and Infrastructure Considerations
296(1)
Exadata Smart Flash Cache
297(4)
Oracle 11g and OLTP
301(9)
Classic Oracle Features
301(4)
Oracle and Linux
305(1)
Quality of Service Management
306(4)
Exadata Software and OLTP
310(1)
Exadata Nodes and OLTP
311(1)
Exadata as a Complete System
312(1)
Summary
313(2)
9 Consolidating Databases with the Oracle Exadata Database Machine
315(28)
Why Consolidate?
316(1)
How the Oracle Exadata Database Machine Helps Consolidation
317(1)
Database Server Consolidation
318(7)
CPU Sizing Considerations
318(2)
Memory Sizing
320(1)
I/O Sizing
321(2)
System Sizing
323(1)
Storage Consolidation
324(1)
Network Consolidation
324(1)
Workload Consolidation and Isolation
325(4)
Services
326(1)
Database Server Pools
326(2)
Workload Management
328(1)
Meeting and Exceeding SLAs
329(9)
Instance Caging
329(4)
I/O Resource Manager (IORM)
333(5)
Quality of Service Management
338(1)
Consolidation Design
338(4)
RAC Considerations
338(1)
Workload-Based Consolidation
339(1)
Time Zone-Based Consolidation
340(1)
Over-provisioning Consolidation
340(1)
Tight SLA Provisioning
341(1)
Testing
341(1)
Summary
342(1)
10 Migrating to the Exadata Database Machine
343(42)
Premigration Steps
345(19)
Discovering the Current Environment
346(9)
Database Machine Capacity Planning and Sizing
355(5)
Choosing a Migration Strategy
360(4)
Migration Steps for Non-Oracle Databases
364(10)
Database Schema Migration
364(1)
Server-side Scripts Migration
365(1)
Data Migration and Synchronization
365(4)
Using Automated Tools for Migration
369(5)
Migration Steps for Oracle Databases
374(10)
Migrating Using Physical Methods
375(6)
Migrating Using Logical Methods
381(3)
Summary
384(1)
A Exadata Capacity and Performance Specifications 385(4)
Exadata Database Machine Storage Capacity
386(1)
Exadata Storage Server Performance
387(2)
Index 389
Rick Greenwald, has been active in the computer industry for more than 25 years. He is currently Director, Oracle Partner Enablement at Oracle where he has worked for more than 10 years. He is also the author or coauthor of more than 15 books, including the best selling Oracle Essentials for OReilly & Associates, now in its fourth edition, Beginning Oracle Application Express from Wiley, and Oracle Data Warehousing and Business Intelligence Solutions from Wiley.





Robert (Bob) Stackowiak, VP, Enterprise Solutions, Oracle, has worked for over 20 years in the IT industry. His roles that have included software development, management of software development, systems engineering, sales and sales consulting, and business development. Bob has spoken at numerous computer related conferences and has conducted briefings with companies based around the world. He has coauthored several book including Oracle Essentials: Oracle Database 11g (4th Edition) by OReilly and Oracle Data Warehousing and Business Intelligence Solutions by Wiley. Additionally, his papers regarding data warehousing and computer and software technology have appeared in publications such as The Data Warehousing Institute's Journal of Data Warehousing and Data Warehousing Trends and Applications.





Maqsood Alam is a Director of Product Management at Oracle and has over 17 years of experience in architecting, building and evangelizing enterprise and system software. Maqsood is a pure technologist at heart and has a wide range of expertise, ranging from parallel and distributed systems to high performance database applications and Big Data. His current initiatives at Oracle are focused on Oracle NoSQL Database, Oracle Exadata, Oracle Database 12c and the Oracle Big Data Appliance. He is the coauthor on the book Achieving Extreme Performance with Oracle Exadata published by McGraw-Hill, and also of several whitepapers and best practices dealing with various Oracle technologies. He is an Oracle Certified Professional and holds a Masters and a Bachelors degree in Computer Science.





Mans Bhuller, Senior Director, Enterprise Solutions, Oracle, has worked at the forefront of emerging technologies at Oracle Corporation for the last 13 years. He currently runs the Database, Grid and Systems Management architecture practice within Oracle's Enterprise Solutions Group. In this role he has been paving the way for the Sun Oracle database machine and other foundational technologies such as Real Application Clusters (RAC), Private Cloud and GRID.