Index
A  B  C  D  E  F  G  H  I  L  M  N  O  P  Q  R  S  T  U  V  W  
A
- applications 
- deploying, 1-27
 
- design principles, 1-14
 
- development trends, 1-22
 
- implementing, 1-20
 
- performance, 2-8
 
 
 
B
- baselines, 2-8
 
- benchmarking workloads, 1-24
 
- big bang rollout strategy, 1-27
 
- bit-mapped indexes, 1-16
 
- bottlenecks 
- fixing, 2-9
 
- identifying, 2-9
 
 
- BSTAT/ESTAT scripts, 2-7
 
- B-tree indexes, 1-16
 
- buffer caches, 2-4
 
- business logic, 1-9, 1-20
 
 
C
- column order, 1-17
 
- conceptual modeling, 2-12
 
- CPUs, 1-8 
- statistics, 2-2
 
 
 
D
- data 
- and transactions, 1-10
 
- baselines, 2-8
 
- gathering, 2-6
 
- historical, 2-8
 
- modeling, 1-14
 
- queries, 1-12
 
- searches, 1-12
 
 
- database statistics, 2-4
 
- databases 
- size, 1-13
 
 
- debugging designs, 1-25
 
- deploying applications, 1-27
 
- design principles, 1-14
 
- designs 
- debugging, 1-25
 
- testing, 1-25
 
- validating, 1-25
 
 
- development environments, 1-20
 
- disk statistics, 2-3
 
 
E
- EM (Enterprise Manager), 2-6
 
- emergencies 
- performance, 3-2
 
 
- Emergency Performance Method, 3-2
 
- Enterprise Manager, 2-6
 
- estimating workloads, 1-23 
- benchmarking, 1-24
 
- extrapolating, 1-24
 
 
- extrapolating workloads, 1-24
 
 
F
- function-based indexes, 1-16
 
 
G
- gathering data, 2-6
 
 
H
- hardware components, 1-7
 
- historical data, 2-8
 
- hours of service, 1-13
 
 
I
- implementing business logic, 1-9
 
- indexes 
- adding columns, 1-15
 
- appending columns, 1-15
 
- bit-mapped, 1-16
 
- B-tree, 1-16
 
- column order, 1-17
 
- costs, 1-17
 
- design, 1-15
 
- function-based, 1-16
 
- partitioned, 1-16
 
- reverse key, 1-17
 
- sequences in, 1-17
 
- serializing in, 1-17
 
 
- index-organized tables, 1-16
 
- Internet scalability, 1-4
 
- IOT (index-organized table), 1-16
 
 
L
- linear scalability, 1-6
 
 
M
- managing the user interface, 1-9
 
- memory, 1-8
 
- modeling 
- conceptual, 2-12
 
- data, 1-14
 
- workloads, 1-25
 
 
 
N
- network speed, 1-12
 
- network statistics, 2-3
 
- networks, 1-8
 
 
O
- object-orientation, 1-22
 
- operating system statistics, 2-2
 
- operating systems 
- checking, 2-12
 
- collecting symptoms, 2-12
 
 
- Oracle performance improvement method, 2-9 
- steps, 2-11
 
 
 
P
- partitioned indexes, 1-16
 
- performance emergencies, 3-2
 
- performance improvement method, 2-9 
- steps, 2-11
 
 
- programming languages, 1-20
 
 
Q
- queries 
- data, 1-12
 
 
 
R
- resource allocation, 1-9, 1-20
 
- response time, 1-12
 
- reverse key indexes, 1-17
 
- rollout strategies 
- big bang approach, 1-27
 
- trickle approach, 1-27
 
 
 
S
- scalability, 1-3 
- factors preventing, 1-6
 
- Internet, 1-4
 
- linear, 1-6
 
 
- service hours, 1-13
 
- shared pool, 2-4
 
- software components, 1-8
 
- statistics 
- correlation with application workload, 2-8
 
- databases, 2-4 
- buffer caches, 2-4
 
- shared pool, 2-4
 
 
- gathering tools, 2-6 
- BSTAT/ESTAT scripts, 2-7
 
- database data, 2-6
 
- Oracle Enterprise Manager, 2-6
 
- Statspack, 2-6
 
 
- operating systems, 2-2 
- CPU statistics, 2-2
 
- disk statistics, 2-3
 
- network statistics, 2-3
 
- virtual memory statistics, 2-3
 
 
 
- Statspack, 2-6
 
- system architecture, 1-7 
- configuration, 1-10
 
- hardware components, 1-7 
- CPUs, 1-8
 
- I/O subsystems, 1-8
 
- memory, 1-8
 
- networks, 1-8
 
 
- software components, 1-8 
- data and transactions, 1-10
 
- implementing business logic, 1-9
 
- managing the user interface, 1-9
 
- user requests and resource allocation, 1-9
 
 
 
 
T
- tables 
- design, 1-15
 
 
- testing designs, 1-25
 
- transactions and data, 1-10
 
- trickle rollout strategy, 1-27
 
 
U
- user requests, 1-9
 
- users 
- interaction method, 1-12
 
- interfaces, 1-20
 
- location, 1-12
 
- network speed, 1-12
 
- number of, 1-11
 
- requests, 1-20
 
- response time, 1-12
 
 
 
V
- validating designs, 1-25
 
- views, 1-18
 
- virtual memory statistics, 2-3
 
 
W
- workloads 
- estimating, 1-23 
- benchmarking, 1-24
 
- extrapolating, 1-24
 
 
- modeling, 1-25
 
- testing, 1-25