ISBN
0-9759135-1-4 |
Library of Congress
Number: xxx |
225 pages
Perfect Bind
9x6 |
Publication Date
TBD |
|
Shelving:
Databases/Oracle |
Easy Oracle Series # xx |
|
|
Easy Oracle
Scalability
Practical Examples
of Data Warehouse
Success
Steve Karam
Retail Price $27.95
/ £17.95
- Order now and get 30% off
the retail price!
Only $19.95
 |
|
This unique book is targeted at those who administer growing
Oracle databases and need to know how to keep it manageable and
running fast.
Packed with examples, this book shows real-world problems and
issues with managing an expanding Oracle database.
Complete with examples and a downloadable code depot, this
unique book covers all basic aspects of Oracle's data management
capabilities including instance tuning, tablespace management,
partitioning, and materialized views, without confusion or
complex explanations.
The book also includes a high level overview of how to develop
trend analysis reports using Oracle's built in tools for
capacity planning to measure the future growth of your Oracle
database, allowing you to make intelligent decisions for the
future. |
|
* Get started
fast with Oracle capacity planning.
* See tips for creating scalable Oracle schemas.
* Understand
how materialized view can pre-join Oracle tables.
* Learn how to
hypercharge queries with Oracle parallel query.
* See how
partitioning allows for massive data volumes.
|
About the Author:
 |
Steve Karam
is one of less than 20 DBA's worldwide to achieve the
coveted Oracle 10g Certified Master
status. A former senior instructor for Oracle
University, Steve has a proven track record in
performance and troubleshooting on dozens of high
profile Oracle systems, and complex Oracle 10g RAC
environments. |
Table of Contents:
Chapter 1 - Scaling Oracle
Planning for growth
Scalability features
Summary of scaling features
Chapter 2 -
Managing large data volumes
Storage Planning
Server growth planning
Benchmarking for breakpoints
Chapter 3 -
Managing large user volumes
Dedicated vs. shared
server
Planning PGA storage
Extending PGA for batch jobs
Chapter 4 - Using
materialized views
Pre-aggregations
(sum, avg)
Pre-joining tables
Automatic query rewrite
|
Chapter 5 - Using Oracle partitioning
Partitioning types
Partition-wise queries
Indexing partitions
Chapter 6 -
Using Oracle parallel query
Divide and conquer
Parallel query slaves
Parallel DML
Parallel aggregation and rollups
Chapter 7 -
Oracle capacity planning
Storage Planning
Server growth planning
Benchmarking for breakpoints
Chapter 8 -
Oracle data warehousing
OLAP
Discoverer
|
|
|
