Oracle9i Performance Tuning Tips & Techniques
Richard J. Niemiec
- 出版商: McGraw-Hill Education
- 出版日期: 2003-05-12
- 售價: $2,210
- 貴賓價: 9.5 折 $2,100
- 語言: 英文
- 頁數: 864
- 裝訂: Paperback
- ISBN: 0072224738
- ISBN-13: 9780072224733
-
相關分類:
Oracle
海外代購書籍(需單獨結帳)
買這商品的人也買了...
-
$1,120$1,098 -
$1,200$1,176 -
$580$493 -
$680$578 -
$1,068Software Engineering, 6/e
-
$350$298 -
$980$833 -
$920$782 -
$1,029Operating System Concepts, 6/e (Windows XP Update)
-
$690$587 -
$780$741 -
$650$553 -
$760$600 -
$590$466 -
$750$585 -
$690$538 -
$420$357 -
$720$562 -
$780$663 -
$720$612 -
$880$792 -
$750$638 -
$720$569 -
$560$476 -
$660$561
相關主題
商品描述
Get Undocumented, Insider Advice
Maintain a high-performance Oracle9i environment using the proven tuning methods presented in this authoritative resource. Written by the experts at TUSC and developed through years of successful Oracle consulting experience, this book offers hundreds of essential tips guaranteed to enhance system performance. Real-world examples illustrate insider best practices and in-depth details throughout the book highlight the new tuning options available in Oracle9i.
- Select the best indexing options for a variety of situations
- Distribute key data files across available hardware disks
- Tune crucial init.ora parameters for peak database performance
- Take full advantage of Oracle Enterprise Manager
- Use EXPLAIN, TRACE, TKPROF, STORED OUTLINES, and other tools
- Specify hints to override the optimizer as necessary
- Automate queries using PL/SQL stored procedures
- Use the Parallel Executions Option (PEO) for enhanced performance
- Monitor and tune the database with STATSPACK
- Query the V$ views and X$ tables
Contents
1: Oracle9i-An Introduction to Oracle9i New
Features (DBA & Developer)
2: Basic Index Principles
(Beginner Developer and Beginner DBA)
3: Disk I/O and
Fragmentation (DBA)
4: Tuning the Database with
Initialization Parameters (DBA)
5: Enterprise Manager
and Tuning Pack (DBA and Developer)
6: Using EXPLAIN,
TRACE, TKPROF, and STORED OUTLINES (Developer & DBA)
7: Basic Hint Syntax (Developer and DBA)
8: Query Tuning
(Developer and Beginner DBA)
9: Table Joins and Other
Advanced Tuning
10: Using PL/SQL to Enhance Performance
(Developer and DBA)
11: Using Parallel Features to
Improve Performance (DBA)
12: The V$ Views (Developer
& DBA)
13: The X$ Tables (Advanced
DBA)
14: Using STATSPACK to Tune Waits and Latches
(Advanced DBA)
15: Performing a Quick System Review
(DBA)
16: Monitoring the System Using UNIX Utilities
(DBA)
A: Key init.ora Parameters
(DBA)
B: The V$ Views (DBA and
Developer)
C: The X$ Tables
(DBA)