Compaq ProLiant 6500 DSS Sizing and Tuning of Oracle8 for Windows NT on Compaq - Page 3
Appendix A: TPC-D Schema, Appendix B: TPC-D Query Definitions, Appendix C: TPC-D Queries SQL Code
View all Compaq ProLiant 6500 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 3 highlights
Table of Contents Introduction ...2 TPC Benchmark D (TPC-D) ...2 DSS vs. OLTP...2 Oracle Overview ...2 Architecture ...2 New Features in Oracle8 Version 8.0 6 Basic Tuning...7 Installation Issues...7 Tuning Goals ...13 I/O Tuning ...13 Disk Layout...13 Partitioning ...14 Parallelism ...15 Availability vs. Performance...17 Array Controllers ...18 I/O Limits ...18 System Processor Scalability ...19 Memory Tuning ...21 System Global Area (SGA) Size ...21 Program Global Area (PGA) Size 21 Processes ...22 Windows NT...22 Total Memory ...22 Conclusion ...25 Appendix A: TPC-D Schema ...27 Appendix B: TPC-D Query Definitions 31 Appendix C: TPC-D Queries (SQL Code 35 © 1998 Compaq Computer Corporation, All Rights Reserved Doc No ECG156/0398
1998 Compaq Computer Corporation, All Rights Reserved
Doc No ECG156/0398
Table of Contents
Introduction
.........................................................................................................................................
2
TPC Benchmark D (TPC-D)
................................................................................................................
2
DSS vs. OLTP
......................................................................................................................................
2
Oracle Overview
..................................................................................................................................
2
Architecture
..................................................................................................................................
2
New Features in Oracle8 Version 8.0
...................................................................................................
6
Basic Tuning
........................................................................................................................................
7
Installation Issues
..........................................................................................................................
7
Tuning Goals
.......................................................................................................................................
13
I/O Tuning
...........................................................................................................................................
13
Disk Layout
...................................................................................................................................
13
Partitioning
...................................................................................................................................
14
Parallelism
....................................................................................................................................
15
Availability vs. Performance
..........................................................................................................
17
Array Controllers
..........................................................................................................................
18
I/O Limits
.....................................................................................................................................
18
System Processor Scalability
................................................................................................................
19
Memory Tuning
...................................................................................................................................
21
System Global Area (SGA) Size
....................................................................................................
21
Program Global Area (PGA) Size
..................................................................................................
21
Processes
.......................................................................................................................................
22
Windows NT
.................................................................................................................................
22
Total Memory
...............................................................................................................................
22
Conclusion
...........................................................................................................................................
25
Appendix A: TPC-D Schema
................................................................................................................
27
Appendix B: TPC-D Query Definitions
.................................................................................................
31
Appendix C: TPC-D Queries (SQL Code)
.............................................................................................
35