Sale!

Expert Oracle Exadata 1st Edition by Kerry Osborne, Randy Johnson, Tanel Poder ISBN 1430233923 9781430233923

Original price was: $50.00.Current price is: $35.00.

Expert Oracle Exadata 1st Edition Kerry Osborne Digital Instant Download

Author(s): Kerry Osborne, Randy Johnson, Tanel Põder
ISBN(s): 9781430233923, 1430233923
Edition: 1
File Details: PDF, 13.09 MB
Year: 2011
Language: english
SKU: EB-2480320 Category: Tags: , ,

Expert Oracle Exadata 1st Edition by Kerry Osborne, Randy Johnson, Tanel Poder – Ebook PDF Instant Download/Delivery: 1430233923, 9781430233923
Full download Expert Oracle Exadata 1st Edition after payment

Product details:

ISBN 10: 1430233923 
ISBN 13: 9781430233923
Author: Kerry Osborne, Randy Johnson, Tanel Poder

Throughout history, advances in technology have come in spurts. A single great idea can often spur rapid change as the idea takes hold and is propagated, often in totally unexpected directions. Exadata embodies such a change in how we think about and manage relational databases. The key change lies in the concept of offloading SQL processing to the storage layer. That concept is a huge win, and its implementation in the form of Exadata is truly a game changer. Expert Oracle Exadata will give you a look under the covers at how the combination of hardware and software that comprise Exadata actually work. Authors Kerry Osborne, Randy Johnson, and Tanel Põder share their real-world experience, gained through multiple Exadata implementations with the goal of opening up the internals of the Exadata platform. This book is intended for readers who want to understand what makes the platform tick and for whom—”how” it does what it is does is as important as what it does. By being exposed to the features that are unique to Exadata, you will gain an understanding of the mechanics that will allow you to fully benefit from the advantages that the platform provides. Changes the way you think about managing SQL performance and processing Provides a roadmap to laying out the Exadata platform to best support your existing systems Dives deeply into the internals, removing the “black box” mystique and showing how Exadata actually works

Expert Oracle Exadata 1st Table of contents:

  1. Contents at a Glance
  2. Table of Contents
  3. About the Author
  4. About the Technical Reviewer
  5. Acknowledgments
  6. Introduction
  7. The Intended Audience
  8. How We Came to Write This Book
  9. A Moving Target
  10. Thanks to the Unofficial Editors
  11. Who Wrote That?
  12. Online Resources
  13. A Note on “Kevin Says”
  14. How We Tested
  15. Schemas and Tables
  16. Good Luck
  17. CHAPTER 1 What Is Exadata?
  18. An Overview of Exadata
  19. History of Exadata
  20. Alternative Views of What Exadata Is
  21. Data Warehouse Appliance
  22. OLTP Machine
  23. Consolidation Platform
  24. Configuration Options
  25. Exadata Database Machine X2-2
  26. Exadata Database Machine X2-8
  27. Upgrades
  28. Hardware Components
  29. Operating Systems
  30. Database Servers’
  31. InfiniBand
  32. Flash Cache
  33. Disks
  34. Bits and Pieces
  35. Software Components
  36. Database Server Software
  37. Storage Server Software
  38. Software Architecture
  39. Summary
  40. CHAPTER 2 Offloading / Smart Scan
  41. Why Offloading Is Important
  42. What Offloading Includes
  43. Column Projection
  44. Predicate Filtering
  45. Storage Indexes
  46. Simple Joins (Bloom Filters)
  47. Function Offloading
  48. Compression/Decompression
  49. Encryption/Decryption
  50. Virtual Columns
  51. Data Mining Model Scoring
  52. Non-Smart Scan Offloading
  53. Smart File Creation
  54. RMAN Incremental Backups
  55. RMAN Restores
  56. Smart Scan Prerequisites
  57. Full Scans
  58. Direct Path Reads
  59. Exadata Storage
  60. Smart Scan Disablers
  61. Simply Unavailable
  62. Reverting to Block Shipping
  63. Skipping Some Offloading
  64. How to Verify That Smart Scan is Happening
  65. 10046 Trace
  66. Performance Statistics (v$sessstat)
  67. Offload Eligible Bytes
  68. SQL Monitoring
  69. Parameters
  70. Summary
  71. CHAPTER 3 Hybrid Columnar Compression
  72. Oracle Storage Review
  73. Oracle Compression Mechanisms
  74. BASIC
  75. OLTP
  76. HCC
  77. HCC Mechanics
  78. HCC Performance
  79. Load Performance
  80. Query Performance
  81. DML Performance
  82. Expected Compression Ratios
  83. Compression Advisor
  84. Real World Examples
  85. Custom Application Data
  86. Telecom Call Detail Data
  87. Financial Data
  88. Retail Sales Data
  89. Summary of the Real World Examples
  90. Restrictions/Challenges
  91. Moving Data to a non-Exadata Platform
  92. Disabling Serial Direct Path Reads
  93. Locking Issues
  94. Single Row Access
  95. Common Usage Scenarios
  96. Summary
  97. CHAPTER 4 Storage Indexes
  98. Structure
  99. Monitoring Storage Indexes
  100. Database Statistics
  101. Tracing
  102. Monitoring Wrap Up
  103. Controlling Storage Indexes
  104. _kcfis_storageidx_disabled
  105. _kcfis_storageidx_diag_mode
  106. _cell_storidx_mode
  107. Storage Software Parameters
  108. Behavior
  109. Performance
  110. Special Optimization for Nulls
  111. Physical Distribution of Values
  112. Potential Issues
  113. Incorrect Results
  114. Moving Target
  115. Partition Size
  116. Incompatible Coding Techniques
  117. Summary
  118. CHAPTER 5 Exadata Smart Flash Cache
  119. Hardware
  120. Cache vs. Flash Disk
  121. Using Flash Memory as Cache
  122. How ESFC is Created
  123. Controlling ESFC Usage
  124. Monitoring
  125. At the Storage Layer
  126. At the Database Layer
  127. Performance
  128. Summary
  129. CHAPTER 6 Exadata Parallel Operations
  130. Parameters
  131. Parallelization at the Storage Tier
  132. Auto DOP
  133. Operation and Configuration
  134. I/O Calibration
  135. Auto DOP Wrap Up
  136. Parallel Statement Queuing
  137. The Old Way
  138. The New Way
  139. Controlling Parallel Queuing
  140. Controlling Queuing with Parameters
  141. Controlling Queuing with Hints
  142. Controlling Queuing with Resource Manager
  143. Parallel Statement Queuing Wrap Up
  144. In-Memory Parallel Execution
  145. Summary
  146. CHAPTER 7 Resource Management
  147. Database Resource Manager
  148. Consumer Groups
  149. Consumer Group Mapping Rules
  150. Plan Directives
  151. Resource Plan
  152. The Pending Area
  153. Resource Manager Views
  154. The Wait Event: resmgr: cpu quantum
  155. DBRM Example
  156. Step 1: Create Resource Groups
  157. Step 2: Create Consumer Group Mapping Rules
  158. Step 3: Set Resource Group Mapping Priorities
  159. Step 4: Create the Resource Plan and Plan Directives
  160. Step 5: Create the Night-Time Plan
  161. Step 6: Activate the Resource Plan
  162. Testing a Resource Plan
  163. Test Outline
  164. Step 1: Deactivate DBRM
  165. Step 2: Log In as RJOHNSON
  166. Step 3: Start Load Test
  167. Step 4: Check Consumer Group Assignments
  168. Step 5: Start 10046 Session Trace for the interactive RJOHNSON Session
  169. Step 6: Execute a Query from the RJOHNSON Session
  170. Step 7: Examine the Session Trace File
  171. Srep 8: Activate Resource Manager
  172. Step 9: Check Consumer Group Assignments
  173. Step 10: Examine the Session Trace File
  174. Step 11: Check DBRM Metrics
  175. Instance Caging
  176. Configuring and Testing Instance Caging
  177. Over-Provisioning
  178. I/O Resource Manager
  179. How IORM Works
  180. IORM Architecture
  181. Limiting Excess I/O Utilization
  182. Workload Optimization
  183. Methods for Managing I/O on Exadata
  184. Interdatabase I/O Resource Management
  185. Configuring Interdatabase IORM
  186. Category IORM
  187. Configuring Category IORM
  188. Intradatabase IORM
  189. Configuring Intradatabase IORM
  190. Bringing It All Together
  191. IORM Monitoring and Metrics
  192. Understanding IORM Metrics
  193. Workload Management
  194. Background Processes
  195. Mining the Metrics
  196. Reporting IORM Database Metrics
  197. Reporting IORM Category Metrics
  198. Reporting IORM Consumer Group Metrics
  199. Testing IORM Plans
  200. Test Outline
  201. Step 1: Activate Resource Manager
  202. Step 2: Start Load Test
  203. Step 3: Dump IORM Metrics to a File.
  204. Analyzing the Results
  205. Category Metrics
  206. Database Metrics
  207. Consumer Group Metrics
  208. Other Processes Managed by IORM
  209. Fast File Creation
  210. Recovery Manager
  211. Summary
  212. CHAPTER 8 Configuring Exadata
  213. Exadata Network Components
  214. The Management Network
  215. ILOM
  216. KVM
  217. The Client Access Network
  218. The Private Network
  219. About the Configuration Process
  220. Configuring Exadata
  221. Step 1: The Configuration Worksheet
  222. Exadata Configuration Parameters
  223. Oracle Environment Parameters
  224. Network Settings
  225. Cell Alert Notification Parameters
  226. Step 2: The DBM Configurator
  227. Step 3: Upload Parameter and Deployment Files
  228. Step 4: CheckIP (Checkip.sh)
  229. Step 5: Firstboot
  230. ApplyConfig
  231. Step 6: Staging the Installation Media
  232. Step 7: Running OneCommand
  233. Upgrading Exadata
  234. Creating a New RAC Cluster
  235. Upgrading the Existing Cluster
  236. Configuring Database Servers
  237. Configuring Storage Cells
  238. Summary
  239. CHAPTER 9 Recovering Exadata
  240. Exadata Diagnostic Tools
  241. Sun Diagnostics: sundiag.sh
  242. sundiag.sh Output
  243. HealthCheck
  244. CellCLI
  245. Cell Metrics
  246. Cell Alerts
  247. Backing Up Exadata
  248. Backing Up the Database Servers
  249. System Backup Using LVM Snapshots
  250. Backing Up the Storage Cell
  251. CELLBOOT USB Flash Drive
  252. External USB Drive
  253. Active and Inactive System Volumes
  254. In-Partition Patches
  255. Out-of-Partition Upgrades
  256. Backing Up the Database
  257. Disk-Based Backups
  258. Tape-Based Backups
  259. Backup from Standby Database
  260. Exadata Optimizations for RMAN
  261. Wait Events
  262. Recovering Exadata
  263. Restoring the Database Server
  264. Recovery Using LVM Snapshot-Based Backup Images
  265. Reimaging a Database Server
  266. Recovering the Storage Cell
  267. System Volume Failure
  268. Cell Rescue Options
  269. Rolling Back a Failed Patch
  270. Cell Disk Failure
  271. Simulated Disk Failure
  272. When to Replace a Cell Disk
  273. Predictive Failure
  274. Poor Performance
  275. Cell Flash Cache Failure
  276. Cell Failure
  277. Temporary Cell Failure
  278. Permanent Cell Failure
  279. Summary
  280. CHAPTER 10 Exadata Wait Events
  281. Events Specific to Exadata
  282. The “cell” Events
  283. Plan Steps That Trigger Events
  284. Exadata Wait Events in the User I/O Class
  285. cell smart table scan
  286. Event Meaning
  287. Parameters
  288. cell smart index scan
  289. Event Meaning
  290. Parameters
  291. cell single block physical read
  292. Event Meaning
  293. Parameters
  294. cell multiblock physical read
  295. Event Meaning
  296. Parameters
  297. cell list of blocks physical read
  298. Event Meaning
  299. Parameters
  300. cell smart file creation
  301. Event Meaning
  302. Parameters
  303. cell statistics gather
  304. Event Meaning
  305. Parameters
  306. Exadata Wait Events in the System I/O Class
  307. cell smart incremental backup
  308. Event Meaning
  309. Parameters
  310. cell smart restore from backup
  311. Event Meaning
  312. Parameters
  313. Exadata Wait Events in the Other and Idle Classes
  314. cell smart flash unkeep
  315. Event Meaning
  316. Parameters
  317. Old Events
  318. direct path read
  319. Event Meaning
  320. Parameters
  321. enq: KO—fast object checkpoint
  322. Event Meaning
  323. Parameters
  324. reliable message
  325. Event Meaning
  326. Parameters
  327. Resource Manager Events
  328. resmgr:cpu quantum
  329. Event Meaning
  330. Parameters
  331. resmgr:pq queued
  332. Event Meaning
  333. Parameters
  334. Summary
  335. CHAPTER 11 Understanding Exadata Performance Metrics
  336. Measuring Exadata’s Performance Metrics
  337. Revisiting the Prerequisites for Exadata Smart Scans
  338. Exadata Smart Scan Performance
  339. Understanding Exadata Smart Scan Metrics and Performance Counters
  340. Exadata Dynamic Performance Counters
  341. When and How to Use Performance Counters
  342. The Meaning and Explanation of Exadata Performance Counters
  343. Exadata Performance Counter Reference
  344. cell blocks helped by commit cache
  345. cell blocks helped by minscn optimization
  346. cell blocks processed by cache layer

People also search for Expert Oracle Exadata 1st:

    
oracle exadata vs oracle database
    
oracle exadata vs oracle
    
oracle exadata version
    
oracle exadata tde
    
oracle exadata support

Tags: Kerry Osborne, Randy Johnson, Tanel Poder, Oracle Exadata