Oracle Core: Essential Internals for DBAs and Developers (Paperback)

Jonathan Lewis

  • 出版商: Apress
  • 出版日期: 2011-12-06
  • 售價: $2,510
  • 貴賓價: 9.5$2,385
  • 語言: 英文
  • 頁數: 280
  • 裝訂: Paperback
  • ISBN: 1430239549
  • ISBN-13: 9781430239543
  • 相關分類: Oracle
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting—no more, no less.

Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data.

Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book.

  • Provides proven content from a world-renowned performance and troubleshooting expert
  • Emphasizes the significance of internals knowledge to rapid identification of database performance problems
  • Covers the core essentials and does not waste your time with esoterica

What you’ll learn

  • Oracle's core architectural foundations
  • How much overhead is reasonable
  • How to recognize when you're doing too much work
  • How to predict bottlenecks and why they will happen
  • How to minimise contention and locking
  • Why concurrency can slow things down significantly

Who this book is for

Oracle Core: Essential Internals for DBAs and Developers is aimed at database administrators ready to move beyond the beginning stage of doing work by rote towards the mastery stage, in which knowledge of what needs to be done comes not from a set of recipe-style instructions, but rather from the intimate knowledge and understanding of the system to be managed. Experienced database administrators will also find the book useful in solidifying their knowledge and filling in any missing pieces of the Oracle Database puzzle.

Table of Contents

  1. Getting Started...
  2. Redo and Undo
  3. Transactions and Consistency
  4. Locks and Latches
  5. Caches and Copies
  6. Writing and Recovery
  7. Parsing and Optimizing
  8. RAC and Ruin

商品描述(中文翻譯)

《Oracle Core: Essential Internals for DBAs and Developers》是由Jonathan Lewis撰寫的一本書,提供了關於Oracle數據庫內部的基本信息,這對於每個數據庫管理員在故障排除時都是必需的,沒有多餘的內容。

Oracle數據庫表面上看起來很複雜。然而,它的廣泛功能集實際上是建立在一個核心基礎架構之上的,這個基礎架構是由早期的堅實架構決策所建立的,經得起時間的考驗。這個核心基礎架構管理事務和提交和回滾更改的能力,保護數據庫的完整性,實現備份和恢復,並允許成千上萬的用戶同時訪問相同的數據。

大多數數據庫管理員每天面臨的性能、備份和恢復問題可以通過理解Lewis在本書中描述的Oracle數據庫核心架構來輕鬆識別。

本書提供了世界知名的性能和故障排除專家的經驗證實內容,強調了內部知識對於快速識別數據庫性能問題的重要性,涵蓋了核心要點,不浪費您的時間。

本書的重點內容包括:
- Oracle的核心架構基礎
- 合理的開銷量是多少
- 如何識別您正在做太多的工作
- 如何預測瓶頸以及為什麼它們會發生
- 如何最小化競爭和鎖定
- 為什麼並發可能會顯著降低速度

本書適合準備從機械式工作階段向掌握階段邁進的數據庫管理員,這些管理員的工作知識不是來自一套食譜式的指令,而是來自對系統的深入了解和理解。有經驗的數據庫管理員也會發現本書對於鞏固他們的知識和填補Oracle數據庫拼圖中的任何缺失部分都很有用。

本書的目錄包括:
1. 入門
2. 重做和撤銷
3. 事務和一致性
4. 鎖定和閂鎖
5. 緩存和副本
6. 寫入和恢復
7. 解析和優化
8. RAC和毀滅