Skip to content

Oracle Database Performance and Scalability A Quantitative Approach

Best in textbook rentals since 2012!

ISBN-10: 111805699X

ISBN-13: 9781118056998

Edition: 2012

Authors: Henry H. Liu

List price: $86.95
Shipping box This item qualifies for FREE shipping.
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!


This book teaches software developers and students how to effectively deal with Oracle performance and scalability issues throughout the entire life cycle of developing Oracle-based applications. It fills the existing gap between CS student textbooks and practitioner-oriented reference books by including supportive, quantitative, real-world case studies throughout. While Oracle is not the only database product on the market, it has the most elaborate concepts and architectures and sets high bars in performance and scalability. The book instructs the basic beginner and the seasoned expert. The Oracle Advanced Features and Options, Top 10 Oracle Performance and Scalability Features, and…    
Customers also bought

Book details

List price: $86.95
Copyright year: 2012
Publisher: John Wiley & Sons, Limited
Publication date: 12/23/2011
Binding: Hardcover
Pages: 728
Size: 6.50" wide x 9.50" long x 1.50" tall
Weight: 2.486

Why This Book
Who This Book is For
How This Book is Organized
Software and Hardware
How to Use This Book
How to Reach The Author
Features of Oracle
Performance versus Scalability
Getting Started with Oracle
Basic Concepts
Standard versus Flavored SQLS
Relational versus Object-Oriented Databases
An Instance versus a Database
Recommended Reading
Installing Oracle Software
Installing Oracle 11g Server Software
Configuring a Listener
Creating an Oracle Database
Installing Oracle 11g Client Software
Oracle Grid Control versus DB Control
Recommended Reading
Options for Accessing an Oracle Server
A Command Line Interface (CLI) versus a GUI-Based Console
The Oracle Enterprise Manager Java Console (OEMJC)
Using the SQLPlus Tool
Oracle Enterprise Manager DBConsole
Other Tools for Developers
Case Study: Creating ER Diagrams with Visio via ODBC
Case Study: Accessing Oracle in Java via JDBC
Recommended Reading
A Quick Tour of an Oracle Server
New Oracle Schemas Beyond "Scott"
Oracle Users versus Schemas
Tablespaces, Segments, Extents, and Data Blocks
Tables, Indexes and Index Types for Structured Data
Domain and LOB Index Types for Unstructured Data
Views, Materialized Views, and Synonyms
Stored Procedures, Functions, and Triggers
Referential Integrity with Foreign Keys
Recommended Reading
Oracle Architecture From Performance and Scalability Perspectives
Understanding Oracle Architecture
The Version History of Oracle
Oracle Processes
Oracle Memory Areas
Dedicated versus Shared Oracle Server Architecture
Performance Sensitive Initialization Parameters
Oracle Static Data Dictionary Views
Oracle Dynamic Performance (V$) Views
Recommended Reading
Oracle 10g Memory Management
SGA Sub-Areas
SGA Sizing: Automatic Shared Memory Management (ASMM)
Recommended Reading
Oracle 11g Memory Management
Automatic Memory Management (AMM)
Memory Sizing Options Configurable at Database Creation Time
Checking Memory Management and Usage Distribution at Run Time
Recommended Reading
Oracle Storage Structure
Managing Tablespaces
Managing Data Files
Managing Redo Logs
Recommended Reading
Oracle Wait Interface (OWI)
Ratio-based versus OWI-based Oracle Performance Tuning Methodologies
Wait Event�The Core Concept of OWI
Classification of Wait Events from OWI
The Other Part (CPU Time) of the Equation Elapsed Time� CPU Time � Wait Time
AWR as a Compass to Tuning Oracle Performance and Scalability
Oracle Data Consistency and Concurrency
Select� for Update Statement
ACID Properties of Transactions
Read Phenomena and Data Inconsistencies
Oracle Isolation Levels
Multi-Version Concurrency Control (MVCC) and Read Consistency
Oracle Locks
Lock Escalations versus Conversions
Oracle Latches
Oracle Enqueues
Taking Advantage of Oracle�s Scalable Concurrency Model
Case Study: A JDBC Example
Importance of Performance Statistics
AWR Report Header
Report Summary
Cache Sizes
Load Profile
Instance Efficiency Percentages (Target 100%)
Shared Pool Statistics
Top Five Timed Events
Main Report
Wait Events Statistics
Time Model Statistics
Wait Class
Wait Events
Background Wait Events
Operating System Statistics
Service Statistics
Service Wait Class Stats
SQL Statistics
SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text
Instance Activity Statistics
Instance Activity Stats
Instance Activity Stats�Absolute Values
Instance Activity Stats�Thread Activity
Java Pool Advisory