Muutke küpsiste eelistusi

E-raamat: Running Applications on Oracle Exadata: Tuning Tips & Techniques

4.14/5 (7 hinnangut Goodreads-ist)
  • Formaat: 448 pages
  • Sari: Tips & Technique
  • Ilmumisaeg: 05-Jan-2015
  • Kirjastus: McGraw-Hill Professional
  • Keel: eng
  • ISBN-13: 9780071833134
Teised raamatud teemal:
  • Formaat - PDF+DRM
  • Hind: 86,11 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Running Applications on Oracle Exadata: Tuning Tips & TechniquesSuurem pilt
  • Formaat: 448 pages
  • Sari: Tips & Technique
  • Ilmumisaeg: 05-Jan-2015
  • Kirjastus: McGraw-Hill Professional
  • Keel: eng
  • ISBN-13: 9780071833134
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality,  authenticity, or access to any online entitlements included with the product.

Maximize Application Performance on Oracle ExadataWritten by an enterprise architect specializing in applications on Oracle's engineered systems, Running Applications on Oracle Exadata: Tuning Tips & Techniques reveals proven methods for configuring and tuning Oracle Exadata to achieve peak results from applications. You'll get complete details on application migration, consolidation, and administration. Deliverunparalleled enterprise application performance on Oracle Exadata using the best practices provided in this Oracle Press guide.





Understand Oracle Exadata architecture, hardware components, and software features Achieve peak performance from online transaction processing (OLTP) systems Size Oracle Exadata for applications using comparative and predictive methods Migrate and consolidate applications to Oracle Exadata Monitor, manage, and administer all Oracle Exadata components to ensure high availability and performance Develop and implement a backup and recovery strategy Learn best practices for running applications on Oracle Exadata





Code examples in the book are available for download at OraclePressBooks.com
Acknowledgments xiii
Introduction xv
1 Exadata Architecture
1(24)
A Brief History
2(3)
Oracle Database Machine V1
3(1)
Oracle Database Machine V2
3(1)
Oracle Exadata Database Machine X2
4(1)
Oracle Exadata Database Machine X3
4(1)
Oracle Exadata Database Machine X4
5(1)
Exadata Architecture
5(10)
Database Servers
5(6)
Exadata Storage Servers or Storage Cells
11(3)
InfiniBand
14(1)
Exadata Configurations
15(4)
Xn-2 Full Rack
15(1)
Xn-2 Half Rack
16(1)
Xn-2 Quarter Rack
16(1)
Xn-2 Eighth Rack
16(1)
Xn-8 Full Rack
17(2)
Exadata Storage Expansion Rack
19(1)
Advantages of Exadata
20(2)
Platinum Services for Exadata
22(2)
Summary
24(1)
2 Exadata Hardware Features
25(22)
Database Servers
26(7)
X4-2 Servers
26(4)
X4-8 Servers
30(3)
Storage Servers
33(3)
Exadata Storage Server X4-2
33(3)
InfiniBand
36(4)
Ethernet Network
40(1)
Power Distribution Units
40(2)
For X4-2 Machines
40(1)
For X4-8 Machines
41(1)
Environment Information
42(4)
X4-2 High-Capacity Disks
43(1)
Exadata X4-2 High-Performance Disk
44(1)
Exadata X4-8 High-Performance and High-Capacity Drive
45(1)
Summary
46(1)
3 Exadata Software Features
47(48)
Hybrid Columnar Compression (HCC)
48(12)
Warehouse Compression
53(1)
Online Archival Compression
53(1)
Implementing HCC
54(5)
Export/Import of HCC Tables
59(1)
Restoring an Exadata HCC Table
59(1)
Smart Scans
60(19)
Smart Scan SQL Operations
64(5)
Considerations that Affect Smart Scan
69(1)
Querying for Smart Scan
70(5)
Smart Scan Metrics
75(1)
Queries to Capture Smart Scan
76(3)
Exadata Smart Flash Cache
79(14)
Exadata Smart Flash Cache and Read Operations
80(2)
Exadata Smart Flash Cache and Write Operations
82(1)
CELL_FLASH_CACHE Setting and Cache Hint
83(1)
Pinning Objects in Flash Cache
84(1)
Exadata Smart Flash Cache and Flash Grid Disks
85(6)
Monitoring Flash Usage
91(2)
More Exadata Smart Flash Cache Features
93(1)
Resource Manager
93(1)
Summary
94(1)
4 Leveraging Exadata Features for Applications
95(24)
Characteristics of an OLTP System
96(2)
Exadata Features
98(20)
Write-Back Flash Cache
98(2)
Smart Flash Logging
100(5)
Flash Cache Compression
105(3)
Database Links Over InfiniBand
108(5)
Exalogic-Exadata Connectivity Using InfiniBand
113(1)
Configuring HugePages
114(4)
Summary
118(1)
5 Sizing Exadata for Applications
119(30)
Comparative Sizing
121(14)
Server Models
122(3)
Memory
125(9)
Comparative Sizing Attributes to Consider
134(1)
Predictive Sizing
135(7)
Users
135(1)
Functionalities
136(1)
Application Services
136(1)
Batch Jobs
137(1)
Reporting
137(1)
Geography
138(1)
Application Growth
138(1)
Special Throughput Needs
138(1)
Predictive Sizing Attributes to Consider
139(1)
Predictive Sizing Questionnaire Examples
140(2)
Disaster Recovery Environment Sizing
142(1)
Nonproduction Environment Sizing
143(1)
Production Support/QA Environment
143(1)
Development, Unit Test Environment
144(1)
Comparative Sizing Case Study
144(2)
Summary
146(3)
6 Migrating Applications to Exadata
149(48)
Planning and Preparing for Migration
151(2)
Migration Paths
153(39)
Migration Using RMAN
153(6)
Migration Using Data Pump Export and Import
159(4)
Migration Using Transportable Database (TDB)
163(5)
Migration Using TTS or XTTS
168(14)
Migration Using Oracle Data Guard
182(5)
Migration Using GoldenGate
187(5)
Summary
192(5)
Addendum 6.1 get_bfile.sql
193(1)
Addendum 6.2 get_bfile_dir.sql
194(3)
7 Application Consolidation in Exadata
197(40)
Advantages of Server Consolidation
199(1)
How to Consolidate in Exadata
200(7)
Using Consolidation Planner
200(7)
Managing Resources in Exadata After Consolidation
207(29)
Instance Caging
207(3)
Database Resource Manager (DBRM)
210(13)
I/O Resource Manager (IORM)
223(9)
Other Considerations/Recommendations for Consolidation
232(4)
Summary
236(1)
8 Monitoring Exadata
237(32)
Monitoring Using Enterprise Manager
238(21)
Monitoring Compute Nodes
240(7)
Monitoring ILOM
247(1)
Monitoring Storage Cells
248(4)
Monitoring InfiniBand
252(1)
Monitoring the Cisco Ethernet Switch, KVM, and PDUs
253(1)
Monitoring the Databases
254(2)
Monitoring SQL
256(3)
Monitoring from the Servers Directly
259(4)
OS System Log
259(1)
CPU Utilization
259(1)
Memory Utilization
260(1)
ILOM Events
260(1)
Storage Cell Metric
261(2)
Exachk
263(5)
Summary
268(1)
9 Managing Exadata
269(38)
Starting and Stopping Exadata Machine
270(2)
Shut Down the Machine
270(1)
Start Up the Machine
271(1)
Operational Commands
272(13)
Commands Related to Power Off/Reboot
272(1)
Commands Related to InfiniBand
273(3)
Tools and Commands for Managing the Grid Infrastructure, ASM, and Database
276(9)
Administering Storage Cells
285(13)
CellCLI
286(4)
Managing Disks
290(2)
Managing Flash
292(2)
Monitoring Using CellCLI
294(2)
Distributed Command Line Interface (DCLI)
296(2)
Summary t
298(9)
Addendum 9.1 Flash Cache Metrics and Descriptions
299(4)
Addendum 9.2 Exadata Smart Flash Log Metrics and Descriptions
303(1)
Addendum 9.3 Sample Commands Related to CellCLI
304(1)
Sample Commands Related to ALTER
304(1)
Sample Commands Related to CREATE
304(1)
Sample Commands Related to DROP
305(1)
Sample Commands Related to LIST
305(2)
10 Exadata Backup and Recovery
307(26)
Database Backup
308(9)
Fast Recovery Area (FRA)
309(1)
Physical Storage Options for Backups
310(2)
Recovery Manager (RMAN)
312(5)
Storage Cells Backup
317(3)
Compute Nodes Backup
320(9)
Snapshot-Based Backup
321(2)
Recovering Compute Nodes with Non-customized Partitions
323(2)
Recovering Oracle Linux Database Server with Customized Partitions
325(4)
InfiniBand Switch Backup
329(3)
Restore an InfiniBand Switch
331(1)
Summary
332(1)
Index 333
Joyjeet Banerjee is currently principal consultant with Oracle Consulting, based out of California, USA. He has over nine years of experience as an Oracle DBA and Oracle Apps DBA. He specializes in Oracle DBMS (Ver 10g/9i/ 8.1.7/ 8.0.5) and Oracle Applications Database Administration (R12/ 11.5.10/ 11.5.9/ 11.5.8/ 11.5.6/ 11.0.3). He has rich experience in supporting multiple production and development databases under various Unix and Windows NT environments. He has also authored a book, Oracle Applications DBA - covers 11i and R12, published by McGraw-Hill Education.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97800718331342e.html
Märksõnad: