Oracle9i Database Performance Methods
Release 1 (9.0.1)

Part Number A87504-02
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-26
design principles, 1-13
development trends, 1-22
implementing, 1-19
performance, 2-8

B

baselines, 2-7
benchmarking workloads, 1-24
big bang rollout strategy, 1-26
bit-mapped indexes, 1-16
bottlenecks
fixing, 2-9
identifying, 2-9
BSTAT/ESTAT scripts, 2-6
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-7
gathering, 2-6
historical, 2-7
modeling, 1-14
queries, 1-12
searches, 1-12
database statistics, 2-4
databases
size, 1-13
debugging designs, 1-25
deploying applications, 1-26
design principles, 1-13
designs
debugging, 1-25
testing, 1-25
validating, 1-25
development environments, 1-19
disk statistics, 2-3

E

EM (Enterprise Manager), 2-6
emergencies
performance, 3-1
Emergency Performance Method, 3-2
Enterprise Manager, 2-6
estimating workloads, 1-23
benchmarking, 1-24
extrapolating, 1-23
extrapolating workloads, 1-23

F

functional indexes, 1-16

G

gathering data, 2-6

H

hardware components, 1-7
historical data, 2-7
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-16
design, 1-15
functional, 1-16
partitioned, 1-16
reverse key, 1-16
sequences in, 1-17
serializing in, 1-17
index-organized tables, 1-15
Internet scalability, 1-4
IOT (index-organized table), 1-15

L

linear scalability, 1-6

M

managing the user interface, 1-9
memory, 1-8
modeling
conceptual, 2-12
data, 1-14
workloads, 1-24

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-10

P

partitioned indexes, 1-16
performance emergencies, 3-1
performance improvement method, 2-9
steps, 2-10
programming languages, 1-19

Q

queries
data, 1-12

R

resource allocation, 1-9, 1-20
response time, 1-12
reverse key indexes, 1-16
rollout strategies
big bang approach, 1-26
trickle approach, 1-26

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-6
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-14
testing designs, 1-25
transactions and data, 1-10
trickle rollout strategy, 1-26

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-17
virtual memory statistics, 2-3

W

workloads
estimating, 1-23
benchmarking, 1-24
extrapolating, 1-23
modeling, 1-24
testing, 1-25

Go to previous page
Oracle
Copyright © 1996-2001, 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