Skip Headers

Oracle9i Database Performance Planning
Release 2 (9.2)

Part Number A96532-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

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

Go to previous page
Oracle
Copyright © 2000, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback