Index

A

Active Session History
- report
  - activity over time 11.3.8
  - load profile 11.3.2
  - top events 11.3.1
  - top files 11.3.7
  - top Java 11.3.5
  - top latches 11.3.7
  - top objects 11.3.7
  - top PL/SQL 11.3.4
  - top sessions 11.3.6
  - Top SQL 11.3.3
  - using 11.3
- reports 11.2
ADDM
- enabling in a PDB 7.1.3.1
allocation of memory 13.1
applications
- deploying 2.7
- design principles 2.5
- development trends 2.5.7
- implementing 2.5.6
Automatic Database Diagnostic Monitor
- actions and rationales of recommendations 7.1.5
- analysis results example 7.1.6
- and DB time 7.1.1
- example report 7.1.6
- findings 7.1.5
- results 7.1.5
- setups 7.2
- types of problems considered 7.1.1
- types of recommendations 7.1.5
automatic database diagnostic monitoring 1.2.1
automatic memory management 13.2.2
automatic segment-space management 4.1.4, 12.3.2, 19.2.6.2
Automatic shared memory management 14.2
automatic SQL tuning 1.2.1
automatic undo management 4.1.2
Automatic Workload Repository 1.2.1
- Active Data Guard support 6.2.8
- AWR data storage and retrieval in a multitenant environment 6.2.7.2
- categorization of AWR statistics in a multitenant environment 6.2.7.1
- compare periods report
  - about 10.1
  - advisory statistics 10.3.2.8, 10.3.2.16
  - details 10.3.2
  - dictionary cache statistics 10.3.2.14
  - I/O statistics 10.3.2.7
  - instance activity statistics 10.3.2.6
  - latch statistics 10.3.2.11
  - library cache statistics 10.3.2.15
  - operating system statistics 10.3.2.2
  - segment statistics 10.3.2.12, 10.3.2.13
  - service statistics 10.3.2.4
  - SQL statistics 10.3.2.5
  - summary 10.3.1
  - supplemental information 10.3.3
  - time model statistics 10.3.2.1
  - undo statistics 10.3.2.10
  - using 10.3
  - wait events 10.3.2.3
  - wait statistics 10.3.2.9
- configuring 6.2.1
- default settings 6.1.4
- factors affecting space usage 6.1.4
- minimizing space usage 6.1.4
- modifying snapshot settings 6.2.2.4
- multitenant environment support 6.2.7
- overview 6.1.1
- recommendations for retention period 6.1.4
- remote databases 6.2.9
- reports 6.3.2.1
- retention period 6.1.4
- space usage 6.1.4
- statistics collected 6.1.1
- turning off automatic snapshot collection 6.1.4
- unusual percentages in reports 6.3
- Viewing AWR data in a multitenant environment 6.2.7.3
- views for accessing data 6.2.6
Autonomous Data Warehouse
- ADW 14.3
Autonomous Transaction Processing
- ATP 14.3
awrrpt.sql
- Automatic Workload Repository report 6.3.2.1

B

baselines 1.1.2.2, 6.1.3
- performance 6.1
benchmarking workloads 2.6.2
big bang rollout strategy 2.7.1
bitmap indexes 2.5.3.2
block cleanout 12.2.4
block size
- choosing 19.2.6
- optimal 19.2.6
bottlenecks
- elimination 1.1.2.4.2
- fixing 3.1
- identifying 3.1
- memory 13.1
- resource 12.3.19
B-tree indexes 2.5.3.2
buffer busy wait events 12.3.2
- actions 12.3.2
buffer cache
- contention 12.3.3, 12.3.4, 12.3.11
- hit ratio 15.2.2
buffer pools
- multiple 15.3
buffer waits
- about 10.3.2.9.1
business logic 2.4.1.2, 2.5.6

C

chained rows 12.2.4
classes
- wait events 5.1.3, 12.1.3.2
client/server applications 20.4.1.2
Cloud Control 1.2
column order
- indexes 2.5.3.5
components
- hardware 2.4.1.1
- software 2.4.1.2
conceptual modeling 3.1.2
consistency
- read 12.2.4
consistent gets from cache statistic 15.2.2
contention
- library cache latch 12.3.11
- memory 12, 13.1
- shared pool 12.3.11
- tuning 12
- wait events 12.3.11
context switches 20.4.1.4.2
CONTROL_FILES initialization parameter 4.1.1
CPUs 2.4.1.1
- statistics 12.1.2.1.3
- utilization 20.4.1
CREATE INDEX statement
- PARALLEL clause 4.2.3
CURSOR_SHARING initialization parameter 16.2.1
CURSOR_SPACE_FOR_TIME initialization parameter 16.3.2
cursors
- accessing 16.2.6
- sharing 16.2.6

D

data
- and transactions 2.4.1.2
- cache 20.1.1
- gathering 5.1
- modeling 2.5.2
- queries 2.4.2
- searches 2.4.2
database caching modes
- configuring 15.5
- default database caching mode 15.5.1
- determining which mode to use 15.5.3
- force full database caching mode
  - about 15.5.2
- verifying 15.5.4
database monitoring 1.2.1
- diagnostic 7.1
database performance
- comparing 10.1
- degradation over time 10.1
Database Resource Manager 12.1.2.1.3, 20.1.3, 20.4.2
databases
- diagnosing and monitoring 7.1
- size 2.4.2
- statistics 5.1
database tuning
- performance degradation over time 10.1
- transient performance problems 11.1
DB_BLOCK_SIZE initialization parameter 19.2.1.2
DB_DOMAIN initialization parameter 4.1.1
DB_NAME initialization parameter 4.1.1
DBA_OBJECTS view 15.3.5.2
db block gets from cache statistic 15.2.2
db file scattered read wait events 12.3.3
- actions 12.3.3, 12.3.4
db file sequential read wait events 12.3.3, 12.3.4
- actions 12.3.4
DBMS_ADVISOR package
- setting DBIO_EXPECTED 7.2
- setups for ADDM 7.2
DBMS_SHARED_POOL package
- managing the shared pool 16.3.5
DB time
- metric 7.1.1
- statistic 5.1.1
debugging designs 2.6.4
deploying applications 2.7
design principles 2.5
designs
- debugging 2.6.4
- testing 2.6.4
- validating 2.6.4
development environments 2.5.6
diagnostic monitoring 1.2.1, 7.1
dictionary cache 10.3.2.14
direct path
- read events 12.3.5
- read events actions 12.3.5
- read events causes 12.3.5
- wait events 12.3.6
- write events actions 12.3.6
- write events causes 12.3.6
disks
- monitoring operating system file activity 12.1.2.2

E

emergencies
- performance 3.2
Emergency Performance Method 3.2.1
End to End Application Tracing
- action and module names 2.5.6
enqueue
- about 10.3.2.9.2
enqueue wait events 12.3.7
- actions 12.3.7
- statistics 12.1.3.4
estimating workloads 2.6.2
- benchmarking 2.6.2
- extrapolating 2.6.2
extrapolating workloads 2.6.2

F

FAILED_AUTO_TASKS_REPORT Function 7.3.5.1
FAST_START_MTTR_TARGET
- and tuning instance recovery 12.4.3
fast ingest 14.7.2, 14.7.2.1
fast lookup 14.7.3.1
- disabling for a table 14.7.3.4
Fast-Start checkpointing architecture 12.4.2
Fast-Start Fault Recovery 12.4, 12.4.2
free buffer wait events 12.3.9
free lists 12.3.2
function-based indexes 2.5.3.2

H

hard parsing 2.5.5
hardware
- components 2.4.1.1
- limitations of components 2.3.3
- sizing of components 2.3.3
HOLD_CURSOR clause 16.2.6.2
hours of service 2.4.2

I

I/O
- and SQL statements 12.3.3
- contention 12.1.2.2.1, 12.1.3.2, 12.3.3, 12.3.15
- excessive I/O waits 12.3.3
- monitoring 12.1.2.2
- objects causing I/O waits 12.3.3
idle wait events 12.3.10
- SQL*Net message from client 12.3.19
indexes
- adding columns 2.5.3.1
- appending columns 2.5.3.1
- bitmap 2.5.3.2
- B-tree 2.5.3.2
- column order 2.5.3.5
- costs 2.5.3.3
- creating 4.2.3
- design 2.5.3
- function-based 2.5.3.2
- partitioned 2.5.3.2
- placement on disk 19.2.2
- reducing I/O 2.5.3.5
- reverse key 2.5.3.2
- selectivity 2.5.3.5
- sequences in 2.5.3.4
- serializing in 2.5.3.4
initialization parameters
- CONTROL_FILES 4.1.1
- DB_DOMAIN 4.1.1
- DB_NAME 4.1.1
- OPEN_CURSORS 4.1.1
- STREAMS_POOL_SIZE 14.4
instance activity
- comparing 10.3.2.6
instance caging 20.4
instance configuration
- initialization files 4.1.1
- performance considerations 4.1
instance recovery
- Fast-Start Fault Recovery 12.4.2
- performance tuning 12.4
Internet scalability 2.3.2

L

LARGE_POOL_SIZE initialization parameter 16.4.3
latch contention
- library cache latches 12.2.1
- shared pool latches 12.2.1
latches 11.3.7.3
- tuning 1.1.2.3, 12.3.11
latch free wait events
- actions 12.3.11
latch wait events 12.3.11
library cache 10.3.2.15
- latch contention 12.3.11
- latch wait events 12.3.11
- lock 12.3.14
- pin 12.3.13
linear scalability 2.3.3
locks and lock holders
- finding 12.3.7
log buffer
- space wait events 12.3.15
log file
- parallel write wait events 12.3.12
- switch wait events 12.3.16
- sync wait events 12.3.17
log writer processes
- tuning 19.2.3.2
LRU
- aging policy 15.3
- latch contention 12.3.11

M

MAXOPENCURSORS clause 16.2.6.2
max session memory statistic 16.4.3
MEMOPTIMIZE_POOL_SIZE initialization parameter 14.7.3.2
MEMOPTIMIZE_WRITE hint 14.7.2.3
Memoptimized Rowstore
- about 14.7.1
- fast ingest
  - about 14.7.2
  - disabling 14.7.2.4
  - enabling 14.7.2.2
  - prerequisites 14.7.2.1
  - using 14.7.2.3
- fast lookup
  - about 14.7.3
  - enabling for a table 14.7.3.3
  - prerequisites 14.7.3.1
- memoptimize pool 14.7.3.2
MEMOPTIMIZE FOR WRITE clause 14.7.2.2
memoptimize pool 14.7.3.2
memory
- hardware component 2.4.1.1
- PGA statistics 10.3.2.8
- statistics 10.3.2.16
memory allocation
- importance 13.1
- tuning 14.4.5
memory management
- automatic shared 13.2.2
metrics 6.1
migrated rows 12.2.4
mirroring
- redo logs 19.2.3.3
modeling
- conceptual 3.1.2
- data 2.5.2
- workloads 2.6.3
monitoring
- diagnostic 1.2.1
multiple buffer pools 15.3

N

NAMESPACE column
- V$LIBRARYCACHE view 16.3.1.1.1
network
- hardware component 2.4.1.1
- speed 2.4.2
network communication wait events 12.3.19
- db file scattered read wait events 12.3.3
- db file sequential read wait events 12.3.3, 12.3.4
- SQL*Net message from Dblink 12.3.19
- SQL*Net more data to client 12.3.19

O

object-orientation 2.5.7
OPEN_CURSORS initialization parameter 4.1.1
operating system
- data cache 20.1.1
- monitoring disk I/O 12.1.2.2
optimization
- described 1.1.3.1
optimizer
- introduction 1.1.3.1
- query 1.1.3.1
Oracle CPU statistics 12.1.2.1.3
Oracle Enterprise Manager Cloud Control 1.2
- advisors 1.2.1
- Performance page 1.2.1
Oracle Forms
- control of parsing and private SQL areas 16.2.6.5
Oracle Managed Files 19.2.5
Oracle Orion
- calibration tool parameters 19.4.4
- command-line options 19.4.4
Oracle performance improvement method 3.1
- steps 3.1.1

P

page table 20.4.1.1.2
paging 20.4.1.2
- reducing 14.4.4.1
PARALLEL clause
- CREATE INDEX statement 4.2.3
parameter
- RESULT_CACHE_MAX_TEMP_RESULT 17.2.3
- RESULT_CACHE_MAX_TEMP_SIZE 17.2.3
- RESULT_CACHE_MODE 17.2.3
parameters
- initialization 10.3.3.1
parsing
- hard 2.5.5
- Oracle Forms 16.2.6.5
- Oracle precompilers 16.2.6.2
- reducing unnecessary calls 16.2.6
- soft 2.5.5
partitioned indexes 2.5.3.2
performance
- emergencies 3.2
- improvement method 3.1
- improvement method steps 3.1.1
- mainframe 20.2.3
- monitoring memory on Windows 20.4.1.1.1
- tools for diagnosing and tuning 1.2
- tools for performance tuning 1.2
- UNIX-based systems 20.2.1
- Windows 20.2.2
Performance Hub active reports
- about 9.1
- generating 9, 9.3
performance problems
- transient 11.1
performance tuning
- Fast-Start Fault Recovery 12.4
- instance recovery 12.4
  - FAST_START_MTTR_TARGET 12.4.2
  - setting FAST_START_MTTR_TARGET 12.4.3
  - using V$INSTANCE_RECOVERY 12.4.2.3
per-session PGA memory limit
- PGA 18.3.2
PGA_AGGREGATE_TARGET initialization parameter 4.1.1
physical reads from cache statistic 15.2.2
proactive monitoring 1.1.2.4.1
processes
- scheduling 20.4.1.4.1
Program Global Area
- PGA 14.3
program global area (PGA)
- direct path read 12.3.5
- direct path write 12.3.6
- shared servers 16.4.1
programming languages 2.5.6

Q

queries
- data 2.4.2
query optimizer 1.1.3.1
- See: optimizer

R

rdbms ipc reply wait events 12.3.18
read consistency 12.2.4
read wait events
- direct path 12.3.5
- scattered 12.3.3
redo logs 4.1.3
- buffer size 12.3.15
- mirroring 19.2.3.3
- placement on disk 19.2.3.2
- sizing 4.1.3
reducing
- contention with dispatchers 4.3.1
- paging and swapping 14.4.4.1
REEXECUTE_FAILED_AUTO_TASKS Procedure 7.3.5.2
RELEASE_CURSOR clause 16.2.6.2
Remote Management Framework (RMF) 6.2.10
resources
- allocation 2.4.1.2, 2.5.6
- bottlenecks 12.3.19
- wait events 12.3.4
response time 2.4.2
reverse key indexes 2.5.3.2
RMF 6.2.10
rollout strategies
- big bang approach 2.7.1
- trickle approach 2.7.1

S

scalability 2.3.1
- factors preventing 2.3.3
- Internet 2.3.2
- linear 2.3.3
scattered read wait events 12.3.3
- actions 12.3.3
segment-level statistics 12.1.3.5
selectivity
- ordering columns in an index 2.5.3.5
sequential read wait events
- actions 12.3.4
service hours 2.4.2
session memory statistic 16.4.3
SGA_TARGET initialization parameter
- automatic memory management 14.2
SHARED_POOL_SIZE initialization parameter 16.3.1.4, 16.3.1.5
shared pool contention 12.3.11
shared server
- performance issues 4.3
- reducing contention 4.3
- tuning 4.3
- tuning memory 16.4.1
SHOW SGA statement 14.4.4.2.1
sizing redo logs 4.1.3
snapshots
- about 6.1.2
soft parsing 2.5.5
software
- components 2.4.1.2
sort areas
- tuning 18.1.1
SQL*Net
- message from client idle events 12.3.19
- message from dblink wait events 12.3.19
- more data to client wait events 12.3.19
SQL statements
- waiting for I/O 12.3.3
SQL Tuning Advisor 1.2.1
statistics
- baselines 6.1
- consistent gets from cache 15.2.2
- databases 5.1
- db block gets from cache 15.2.2
- dictionary cache 10.3.2.14
- gathering 5.1
- I/O 10.3.2.7
- instance activity 10.3.2.6
- latch 10.3.2.11
- library cache 10.3.2.15
- max session memory 16.4.3
- memory 10.3.2.16
- operating system
  - comparing 10.3.2.2
- PGA memory 10.3.2.8
- physical reads from cache 15.2.2
- segment 10.3.2.12, 10.3.2.13
- segment-level 12.1.3.5
- service 10.3.2.4
- session memory 16.4.3
- shared server processes 4.3.2
- SQL 10.3.2.5
- time model 5.1.1, 10.3.2.1
- undo 10.3.2.10
- waits 10.3.2.9
STREAMS_POOL_SIZE initialization parameter 14.4
striping
- manual 19.2.2
swapping 20.4.1.1.1, 20.4.1.2
- reducing 14.4.4.1
switching processes 20.4.1.4.1
system architecture 2.4
- configuration 2.4.2
- hardware components 2.4.1.1
  - CPUs 2.4.1.1
  - I/O subsystems 2.4.1.1
  - memory 2.4.1.1
  - networks 2.4.1.1
- software components 2.4.1.2
  - business logic 2.4.1.2
  - data and transactions 2.4.1.2
  - resources for managing user requests 2.4.1.2
  - user interface 2.4.1.2
System Global Area tuning 14.4.4.2

T

tables
- creating 4.2
- design 2.5.3
- placement on disk 19.2.2
- setting storage options 4.2
tablespaces 4.1.4
- creating 4.1.4
- temporary 4.1.4
temporary tablespaces 4.1.4
- creating 4.1.4
testing designs 2.6.4
thrashing 20.4.1.2
time model statistics 5.1.1
- comparing 10.3.2.1
Top Java
- Active Session History report 11.3.5
top PL/SQL
- Active Session History report 11.3.4
Top Sessions
- Active Session History report 11.3.6
Top SQL
- Active Session History report 11.3.3
transactions and data 2.4.1.2
trickle rollout strategy 2.7.1
tuning
- and bottleneck elimination 1.1.2.4.2
- and proactive monitoring 1.1.2.4.1
- latches 1.1.2.3, 12.3.11
- resource contention 12
- shared server 4.3
- sorts 18.1.1
- System Global Area (SGA) 14.4.4.2

U

undo management, automatic mode 4.1.2
Unified Memory 14.1
UNIX system performance 20.2.1
user global area (UGA)
- shared servers 4.3, 16.4.1
user interface 2.4.1.2
users
- interaction method 2.4.2
- interfaces 2.5.6
- ___location 2.4.2
- network speed 2.4.2
- number of 2.4.2
- requests 2.5.6
- response time 2.4.2

V

V$ACTIVE_SESSION_HISTORY view 12.1.3.3
V$BUFFER_POOL_STATISTICS view 15.3.4
V$DB_CACHE_ADVICE view 15.2.1
V$EVENT_HISTOGRAM view 12.1.3.3
V$FILE_HISTOGRAM view 12.1.3.3
V$JAVA_LIBRARY_CACHE_MEMORY view 16.3.1.2.3
V$JAVA_POOL_ADVICE view 16.3.1.2.3
V$LIBRARY_CACHE_MEMORY view 16.3.1.2.2
V$LIBRARYCACHE view
- NAMESPACE column 16.3.1.1.1
V$QUEUE view 4.3.2
V$ROWCACHE view
- performance statistics 16.3.1.3
V$SESSION_EVENT view 12.1.3.3
V$SESSION_WAIT_CLASS view 12.1.3.3
V$SESSION_WAIT_HISTORY view 12.1.3.3
V$SESSION_WAIT view 12.1.3.3
V$SESSION view 12.1.3.3, 12.1.3.4
V$SESSTAT view 16.4.3
V$SHARED_POOL_ADVICE view 16.3.1.2.1
V$SHARED_POOL_RESERVED view 16.3.6.1
V$SYSSTAT view
- redo buffer allocation 15.4.2
- using 15.2.2
V$SYSTEM_EVENT view 12.1.3.3
V$SYSTEM_WAIT_CLASS view 12.1.3.3
V$TEMP_HISTOGRAM view 12.1.3.3
V$WAITSTAT view 12.1.3.4
validating designs 2.6.4
views 2.5.4
vmstat UNIX command 20.4.1.1.1

W

wait events 5.1.3
- buffer busy waits 12.3.2
- classes 5.1.3, 12.1.3.2
- comparing 10.3.2.3
- direct path 12.3.6
- enqueue 12.3.7
- free buffer waits 12.3.9
- idle wait events 12.3.10
- latch 12.3.11
- library cache latch 12.3.11
- log buffer space 12.3.15
- log file parallel write 12.3.12
- log file switch 12.3.16
- log file sync 12.3.17
- network communication wait events 12.3.19
- rdbms ipc reply 12.3.18
- resource wait events 12.3.4
Windows performance 20.2.2
workloads 2.6.2, 2.6.3, 2.6.4