Index

A B C D E F H I L M N O P Q R S T U V W

A

Active Session History
- report
  - activity over time 1
  - load profile 1
  - top events 1
  - top files 1
  - top Java 1
  - top latches 1
  - top objects 1
  - top PL/SQL 1
  - top sessions 1
  - Top SQL 1
  - using 1
- reports 1
allocation of memory 1
applications
- deploying 1
- design principles 1
- development trends 1
- implementing 1
Automatic Database Diagnostic Monitor
- actions and rationales of recommendations 1
- analysis results example 1
- and DB time 1
- example report 1
- findings 1
- results 1
- setups 1
- types of problems considered 1
- types of recommendations 1
automatic database diagnostic monitoring 1
automatic segment-space management 1 , 2 , 3
Automatic shared memory management 1
automatic SQL tuning 1
automatic undo management 1
Automatic Workload Repository
- Active Data Guard support 1
- AWR data storage and retrieval in a multitenant environment 1
- categorization of AWR statistics in a multitenant environment 1
- compare periods report
  - about 1
  - advisory statistics 1 , 2
  - details 1
  - dictionary cache statistics 1
  - I/O statistics 1
  - instance activity statistics 1
  - latch statistics 1
  - library cache statistics 1
  - operating system statistics 1
  - segment statistics 1 , 2
  - service statistics 1
  - SQL statistics 1
  - summary 1
  - supplemental information 1
  - time model statistics 1
  - undo statistics 1
  - using 1
  - wait events 1
  - wait statistics 1
- configuring 1
- default settings 1
- factors affecting space usage 1
- managing snapshots in ADG standby databases 1
- minimizing space usage 1
- multitenant environment support 1
- overview 1
- recommendations for retention period 1
- reports 1
- retention period 1
- space usage 1
- statistics collected 1
- turning off automatic snapshot collection 1
- unusual percentages in reports 1
- Viewing AWR data in a multitenant environment 1
- viewing remote snapshots for ADG standby databases 1
- views for accessing data 1
awrrpt.sql
- Automatic Workload Repository report 1

B

baselines
- performance 1
benchmarking workloads 1
big bang rollout strategy 1
bitmap indexes 1
block cleanout 1
block size
- choosing 1
- optimal 1
bottlenecks
- elimination 1
- fixing 1
- identifying 1
- memory 1
- resource 1
B-tree indexes 1
buffer busy wait events
- actions 1
buffer cache
- contention 1 , 2 , 3
- hit ratio 1
buffer pools
- multiple 1
buffer waits
- about 1
business logic 1 , 3

C

chained rows 1
classes
- wait events 1 , 2
client/server applications 1
Cloud Control 1
column order
- indexes 1
components
- hardware 1
- software 1
conceptual modeling 1
consistency
- read 1
consistent gets from cache statistic 1
contention
- library cache latch 1
- memory 1 , 2
- shared pool 1
- tuning 1
- wait events 1
context switches 1
CONTROL_FILES initialization parameter 1
CPUs
- statistics 1
- utilization 1
CREATE INDEX statement
- PARALLEL clause 1
CURSOR_SHARING initialization parameter 1
CURSOR_SPACE_FOR_TIME initialization parameter 1
cursors
- accessing 1
- sharing 1

D

data
- and transactions 1
- cache 1
- gathering 1
- modeling 1
- queries 1
- searches 1
database caching modes
- configuring 1
- default database caching mode 1
- determining which mode to use 1
- force full database caching mode
  - about 1
- verifying 1
database monitoring
- diagnostic 1
database performance
- comparing 1
- degradation over time 1
Database Resource Manager 1 , 2 , 3
databases
- diagnosing and monitoring 1
- size 1
- statistics 1
database tuning
- performance degradation over time 1
- transient performance problems 1
DB_BLOCK_SIZE initialization parameter 1
DB_DOMAIN initialization parameter 1
DB_NAME initialization parameter 1
DBA_OBJECTS view 1
db block gets from cache statistic 1
db file scattered read wait events
- actions 1 , 2
db file sequential read wait events
- actions 1
DBMS_ADVISOR package
- setting DBIO_EXPECTED 1
- setups for ADDM 1
DBMS_SHARED_POOL package
- managing the shared pool 1
DB time
- metric 1
- statistic 1
debugging designs 1
deploying applications 1
design principles 1
designs
- debugging 1
- testing 1
- validating 1
development environments 1
diagnostic monitoring 1 , 2
dictionary cache 1
direct path
- read events 1
- read events actions 1
- read events causes 1
- wait events 1
- write events actions 1
- write events causes 1
disks
- monitoring operating system file activity 1

E

emergencies
- performance 1
Emergency Performance Method 1
End to End Application Tracing
- action and module names 1
enqueue
- about 1
enqueue wait events
- actions 1
- statistics 1
estimating workloads
- benchmarking 1
- extrapolating 1
extrapolating workloads 1

F

FAST_START_MTTR_TARGET
- and tuning instance recovery 1
Fast-Start checkpointing architecture 1
Fast-Start Fault Recovery 1 , 2
free buffer wait events 1
free lists 1
function-based indexes 1

H

hard parsing 1
hardware
- components 1
- limitations of components 1
- sizing of components 1
HOLD_CURSOR clause 1
hours of service 1

I

I/O
- and SQL statements 1
- contention 1 , 2 , 3 , 4
- excessive I/O waits 1
- monitoring 1
- objects causing I/O waits 1
idle wait events
- SQL*Net message from client 1
indexes
- adding columns 1
- appending columns 1
- bitmap 1
- B-tree 1
- column order 1
- costs 1
- creating 1
- design 1
- function-based 1
- partitioned 1
- placement on disk 1
- reducing I/O 1
- reverse key 1
- selectivity 1
- sequences in 1
- serializing in 1
initialization parameters
- CONTROL_FILES 1
- DB_DOMAIN 1
- DB_NAME 1
- OPEN_CURSORS 1
- STREAMS_POOL_SIZE 1
instance activity
- comparing 1
instance caging 1
instance configuration
- initialization files 1
- performance considerations 1
instance recovery
- Fast-Start Fault Recovery 1
- performance tuning 1
Internet scalability 1

L

LARGE_POOL_SIZE initialization parameter 1
latch contention
- library cache latches 1
- shared pool latches 1
latches
- tuning 1 , 2
latch free wait events
- actions 1
latch wait events 1
library cache
- latch contention 1
- latch wait events 1
- lock 1
- pin 1
linear scalability 1
locks and lock holders
- finding 1
log buffer
- space wait events 1
log file
- parallel write wait events 1
- switch wait events 1
- sync wait events 1
log writer processes
- tuning 1
LRU
- aging policy 1
- latch contention 1

M

MAXOPENCURSORS clause 1
max session memory statistic 1
memory
- hardware component 1
- PGA statistics 1
- statistics 1
memory allocation
- importance 1
- tuning 1
metrics 1
migrated rows 1
mirroring
- redo logs 1
modeling
- conceptual 1
- data 1
- workloads 1
monitoring
- diagnostic 1
multiple buffer pools 1

N

NAMESPACE column
- V$LIBRARYCACHE view 1
network
- hardware component 1
- speed 1
network communication wait events
- db file scattered read wait events 1
- db file sequential read wait events 1 , 2
- SQL*Net message from Dblink 1
- SQL*Net more data to client 1

O

object-orientation 1
OPEN_CURSORS initialization parameter 1
operating system
- data cache 1
- monitoring disk I/O 1
optimization
- described 1
optimizer
- introduction 1
- query 1
Oracle CPU statistics 1
Oracle Enterprise Manager Cloud Control
- advisors 1
- Performance page 1
Oracle Forms
- control of parsing and private SQL areas 1
Oracle Managed Files 1
Oracle Orion
- calibration tool parameters 1
- command-line options 1
Oracle performance improvement method
- steps 1

P

page table 1
paging
- reducing 1
PARALLEL clause
- CREATE INDEX statement 1
parameter
- RESULT_CACHE_MODE 1
parameters
- initialization 1
parsing
- hard 1
- Oracle Forms 1
- Oracle precompilers 1
- reducing unnecessary calls 1
- soft 1
partitioned indexes 1
performance
- emergencies 1
- improvement method 1
- improvement method steps 1
- mainframe 1
- monitoring memory on Windows 1
- tools for diagnosing and tuning 1
- tools for performance tuning 1
- UNIX-based systems 1
- Windows 1
Performance Hub active reports
- about 1
- generating 1 , 2
performance problems
- transient 1
performance tuning
- Fast-Start Fault Recovery 1
- instance recovery
  - FAST_START_MTTR_TARGET 1
  - setting FAST_START_MTTR_TARGET 1
  - using V$INSTANCE_RECOVERY 1
per-session PGA memory limit
- PGA 1
PGA_AGGREGATE_TARGET initialization parameter 1
physical reads from cache statistic 1
proactive monitoring 1
processes
- scheduling 1
program global area (PGA)
- direct path read 1
- direct path write 1
- shared servers 1
programming languages 1

Q

queries
- data 1
query optimizer 1
- See: optimizer

R

rdbms ipc reply wait events 1
read consistency 1
read wait events
- direct path 1
- scattered 1
redo logs
- buffer size 1
- mirroring 1
- placement on disk 1
- sizing 1
reducing
- contention with dispatchers 1
- paging and swapping 1
RELEASE_CURSOR clause 1
Remote Management Framework (RMF) 1
resources
- allocation 1 , 2
- bottlenecks 1
- wait events 1
response time 1
reverse key indexes 1
RMF 1
rollout strategies
- big bang approach 1
- trickle approach 1

S

scalability
- factors preventing 1
- Internet 1
- linear 1
scattered read wait events
- actions 1
segment-level statistics 1
selectivity
- ordering columns in an index 1
sequential read wait events
- actions 1
service hours 1
session memory statistic 1
SGA_TARGET initialization parameter
- automatic memory management 1
SHARED_POOL_SIZE initialization parameter 1 , 2
shared pool contention 1
shared server
- performance issues 1
- reducing contention 1
- tuning 1
- tuning memory 1
SHOW SGA statement 1
sizing redo logs 1
snapshots
- about 1
soft parsing 1
software
- components 1
sort areas
- tuning 1
SQL*Net
- message from client idle events 1
- message from dblink wait events 1
- more data to client wait events 1
SQL statements
- waiting for I/O 1
SQL Tuning Advisor 1
statistics
- baselines 1
- consistent gets from cache 1
- databases 1
- db block gets from cache 1
- dictionary cache 1
- gathering 1
- I/O 1
- instance activity 1
- latch 1
- library cache 1
- max session memory 1
- memory 1
- operating system
  - comparing 1
- PGA memory 1
- physical reads from cache 1
- segment 1 , 2
- segment-level 1
- service 1
- session memory 1
- shared server processes 1
- SQL 1
- time model 1 , 2
- undo 1
- waits 1
STREAMS_POOL_SIZE initialization parameter 1
striping
- manual 1
swapping
- reducing 1
switching processes 1
system architecture
- configuration 1
- hardware components
  - CPUs 1
  - I/O subsystems 1
  - memory 1
  - networks 1
- software components
  - business logic 1
  - data and transactions 1
  - resources for managing user requests 1
  - user interface 1
System Global Area tuning 1

T

tables
- creating 1
- design 1
- placement on disk 1
- setting storage options 1
tablespaces
- creating 1
- temporary 1
temporary tablespaces
- creating 1
testing designs 1
thrashing 1
time model statistics
- comparing 1
Top Java
- Active Session History report 1
top PL/SQL
- Active Session History report 1
Top Sessions
- Active Session History report 1
Top SQL
- Active Session History report 1
transactions and data 1
trickle rollout strategy 1
tuning
- and bottleneck elimination 1
- and proactive monitoring 1
- latches 1 , 2
- resource contention 1
- shared server 1
- sorts 1
- System Global Area (SGA) 1

U

undo management, automatic mode 1
UNIX system performance 1
user global area (UGA)
- shared servers 1 , 2
user interface 1
users
- interaction method 1
- interfaces 1
- location 1
- network speed 1
- number of 1
- requests 1
- response time 1

V

V$ACTIVE_SESSION_HISTORY view 1
V$BUFFER_POOL_STATISTICS view 1
V$DB_CACHE_ADVICE view 1
V$EVENT_HISTOGRAM view 1
V$FILE_HISTOGRAM view 1
V$JAVA_LIBRARY_CACHE_MEMORY view 1
V$JAVA_POOL_ADVICE view 1
V$LIBRARY_CACHE_MEMORY view 1
V$LIBRARYCACHE view
- NAMESPACE column 1
V$QUEUE view 1
V$ROWCACHE view
- performance statistics 1
V$SESSION_EVENT view 1
V$SESSION_WAIT_CLASS view 1
V$SESSION_WAIT_HISTORY view 1
V$SESSION_WAIT view 1
V$SESSION view 1 , 2
V$SESSTAT view 1
V$SHARED_POOL_ADVICE view 1
V$SHARED_POOL_RESERVED view 1
V$SYSSTAT view
- redo buffer allocation 1
- using 1
V$SYSTEM_EVENT view 1
V$SYSTEM_WAIT_CLASS view 1
V$TEMP_HISTOGRAM view 1
V$WAITSTAT view 1
validating designs 1
views 1
vmstat UNIX command 1

W

wait events
- buffer busy waits 1
- classes 1 , 2
- comparing 1
- direct path 1
- enqueue 1
- free buffer waits 1
- idle wait events 1
- latch 1
- library cache latch 1
- log buffer space 1
- log file parallel write 1
- log file switch 1
- log file sync 1
- network communication wait events 1
- rdbms ipc reply 1
- resource wait events 1
Windows performance 1
workloads 1 , 4 , 5