Sold Out
Book Categories |
Preface | ||
1 | Introduction | 3 |
2 | Architectures for Parallel Processing | 23 |
Hardware Architectures | 23 | |
High-Speed Interconnect | 31 | |
Software Architectures of Parallel Database Systems | 32 | |
Oracle's Parallel Processing Architecture | 36 | |
3 | Parallel Execution Concepts | 41 |
What Is Parallel SQL? | 41 | |
How Parallel Execution Works | 46 | |
4 | Using Parallel Execution | 54 |
Parallel Query | 54 | |
Parallel DML | 58 | |
Parallel DDL | 64 | |
Parallel Data Loading | 65 | |
Parallel Recovery | 69 | |
Parallel Replication Propagation | 70 | |
5 | Monitoring and Tuning Parallel Execution | 72 |
Tuning Overview | 72 | |
Dynamic Performance Views | 73 | |
Using EXPLAIN PLAN to View Parallel Execution | 84 | |
Tuning Tips for Parallel Execution | 87 | |
Automatic Tuning of Parallel Execution in Oracle8i | 89 | |
6 | Oracle Parallel Server Architecture | 95 |
OPS and Oracle Instances | 95 | |
Synchronization Between Instances | 100 | |
OPS Impact on Database Files | 102 | |
Integrated Distributed Look Manager | 105 | |
Group Membership Service | 108 | |
Rollback Segments in OPS | 109 | |
7 | Administering an OPS Database | 112 |
Creating an OPS Database | 112 | |
Starting and Stopping an OPS Database | 120 | |
Managing Instance Groups | 123 | |
Backing UP an OPS Database | 124 | |
Recovering an OPS Database | 130 | |
8 | Locking Mechanisms in OPS | 134 |
Cache Coherency | 134 | |
Lock Types in OPS | 135 | |
Lock Modes | 137 | |
Parallel Cache Management | 139 | |
PCM Lock Types | 148 | |
PCM Lock Allocation Parameters and Verification | 152 | |
PCM Lock Allocation Guidelines | 158 | |
Non-PCM Locks | 163 | |
9 | Storage Management in OPS | 165 |
Using Free Lists and Free List Groups | 165 | |
The PCTFREE Parameter: Reserving Free Space | 174 | |
Using Reverse Key Indexes | 175 | |
10 | Monitoring and Turning OPS | 176 |
OPS Performance Views | 176 | |
Dynamic Performance Views | 177 | |
Monitoring PCM Locking | 178 | |
Monitoring Overall Statistics | 189 | |
Monitoring and Tuning IDLM | 195 | |
Oracle Performance Manager | 198 | |
11 | Partitioning for OPS | 200 |
When Is Partitioning Needed? | 200 | |
Partitioning Techniques | 201 | |
Changing Your Partitioning Scheme | 211 | |
12 | Application Failover | 213 |
Maintaining a Failover Database | 214 | |
Planning for a Failover with OPS | 219 | |
Failover Complexity | 222 | |
Failover Methods | 224 | |
13 | Parallel Execution in OPS | 233 |
How Parallel Execution Works with OPS | 233 | |
Disk Affinity | 234 | |
Instance Groups for Parallel Execution | 236 | |
App.: Case Studies | 239 | |
Index | 255 |
Login|Complaints|Blog|Games|Digital Media|Souls|Obituary|Contact Us|FAQ
CAN'T FIND WHAT YOU'RE LOOKING FOR? CLICK HERE!!! X
You must be logged in to add to WishlistX
This item is in your Wish ListX
This item is in your CollectionOracle Parallel Processing
X
This Item is in Your InventoryOracle Parallel Processing
X
You must be logged in to review the productsX
X
X
Add Oracle Parallel Processing, Parallel processing is becoming increasingly important to database computing. Databases often grow to enormous sizes and are accessed by huge numbers of users. This growth strains the ability of single-processor and single-computer systems to handle the l, Oracle Parallel Processing to the inventory that you are selling on WonderClubX
X
Add Oracle Parallel Processing, Parallel processing is becoming increasingly important to database computing. Databases often grow to enormous sizes and are accessed by huge numbers of users. This growth strains the ability of single-processor and single-computer systems to handle the l, Oracle Parallel Processing to your collection on WonderClub |