Index

A

ADDM
- enabling in a PDB 7.1.3.1
allocation of memory 9.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 9.2.2
automatic segment-space management 4.1.4, 15.2.6.2
Automatic shared memory management 10.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
- configuring 6.2.1
- default settings 6.1.4
- factors affecting space usage 6.1.4
- managing snapshots in ADG standby databases 6.2.8.2
- 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
- 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
- viewing remote snapshots for ADG standby databases 6.2.8.3
- views for accessing data 6.2.6
Autonomous Data Warehouse
- ADW 10.3
Autonomous Transaction Processing
- ATP 10.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 size
- choosing 15.2.6
- optimal 15.2.6
bottlenecks
- elimination 1.1.2.4.2
- fixing 3.1
- identifying 3.1
- memory 9.1
B-tree indexes 2.5.3.2
buffer cache
- hit ratio 11.2.2
buffer pools
- multiple 11.3
business logic 2.4.1.2, 2.5.6

C

classes
- wait events 5.1.3
client/server applications 16.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
consistent gets from cache statistic 11.2.2
contention
- memory 9.1
context switches 16.4.1.4.2
CONTROL_FILES initialization parameter 4.1.1
CPUs 2.4.1.1
- utilization 16.4.1
CREATE INDEX statement
- PARALLEL clause 4.2.3
CURSOR_SHARING initialization parameter 12.2.1
CURSOR_SPACE_FOR_TIME initialization parameter 12.3.2
cursors
- accessing 12.2.6
- sharing 12.2.6

D

data
- and transactions 2.4.1.2
- cache 16.1.1
- gathering 5.1
- modeling 2.5.2
- queries 2.4.2
- searches 2.4.2
database caching modes
- configuring 11.5
- default database caching mode 11.5.1
- determining which mode to use 11.5.3
- force full database caching mode
  - about 11.5.2
- verifying 11.5.4
database monitoring 1.2.1
- diagnostic 7.1
Database Resource Manager 16.1.3, 16.4.2
databases
- diagnosing and monitoring 7.1
- size 2.4.2
- statistics 5.1
DB_BLOCK_SIZE initialization parameter 15.2.1.2
DB_DOMAIN initialization parameter 4.1.1
DB_NAME initialization parameter 4.1.1
DBA_OBJECTS view 11.3.5.2
db block gets from cache statistic 11.2.2
DBMS_ADVISOR package
- setting DBIO_EXPECTED 7.2
- setups for ADDM 7.2
DBMS_SHARED_POOL package
- managing the shared pool 12.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

E

emergencies
- performance 3.2
Emergency Performance Method 3.2.1
End to End Application Tracing
- action and module names 2.5.6
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 ingest 10.7.2, 10.7.2.1
fast lookup 10.7.3.1
- disabling for a table 10.7.3.4
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 12.2.6.2
hours of service 2.4.2

I

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 15.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 10.4
instance caging 16.4
instance configuration
- initialization files 4.1.1
- performance considerations 4.1
Internet scalability 2.3.2

L

LARGE_POOL_SIZE initialization parameter 12.4.3
latches
- tuning 1.1.2.3
linear scalability 2.3.3
log writer processes
- tuning 15.2.3.2
LRU
- aging policy 11.3

M

MAXOPENCURSORS clause 12.2.6.2
max session memory statistic 12.4.3
MEMOPTIMIZE_POOL_SIZE initialization parameter 10.7.3.2
MEMOPTIMIZE_WRITE hint 10.7.2.3
Memoptimized Rowstore
- about 10.7.1
- fast ingest
  - about 10.7.2
  - disabling 10.7.2.4
  - enabling 10.7.2.2
  - prerequisites 10.7.2.1
  - using 10.7.2.3
- fast lookup
  - about 10.7.3
  - enabling for a table 10.7.3.3
  - prerequisites 10.7.3.1
- memoptimize pool 10.7.3.2
MEMOPTIMIZE FOR WRITE clause 10.7.2.2
memoptimize pool 10.7.3.2
memory
- hardware component 2.4.1.1
memory allocation
- importance 9.1
- tuning 10.4.5
memory management
- automatic shared 9.2.2
metrics 6.1
mirroring
- redo logs 15.2.3.3
modeling
- conceptual 3.1.2
- data 2.5.2
- workloads 2.6.3
monitoring
- diagnostic 1.2.1
multiple buffer pools 11.3

N

NAMESPACE column
- V$LIBRARYCACHE view 12.3.1.1.1
network
- hardware component 2.4.1.1
- speed 2.4.2

O

object-orientation 2.5.7
OPEN_CURSORS initialization parameter 4.1.1
operating system
- data cache 16.1.1
optimization
- described 1.1.3.1
optimizer
- introduction 1.1.3.1
- query 1.1.3.1
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 12.2.6.5
Oracle Managed Files 15.2.5
Oracle Orion
- calibration tool parameters 15.4.4
- command-line options 15.4.4
Oracle performance improvement method 3.1
- steps 3.1.1

P

page table 16.4.1.1.2
paging 16.4.1.2
- reducing 10.4.4.1
PARALLEL clause
- CREATE INDEX statement 4.2.3
parameter
- RESULT_CACHE_MAX_TEMP_RESULT 13.2.3
- RESULT_CACHE_MAX_TEMP_SIZE 13.2.3
- RESULT_CACHE_MODE 13.2.3
parsing
- hard 2.5.5
- Oracle Forms 12.2.6.5
- Oracle precompilers 12.2.6.2
- reducing unnecessary calls 12.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 16.2.3
- monitoring memory on Windows 16.4.1.1.1
- tools for diagnosing and tuning 1.2
- tools for performance tuning 1.2
- UNIX-based systems 16.2.1
- Windows 16.2.2
Performance Hub active reports
- about 6.4.1
- generating 6.4, 6.4.3
per-session PGA memory limit
- PGA 14.3.2
PGA_AGGREGATE_TARGET initialization parameter 4.1.1
physical reads from cache statistic 11.2.2
proactive monitoring 1.1.2.4.1
processes
- scheduling 16.4.1.4.1
Program Global Area
- PGA 10.3
program global area (PGA)
- shared servers 12.4.1
programming languages 2.5.6

Q

queries
- data 2.4.2
query optimizer 1.1.3.1
- See: optimizer

R

redo logs 4.1.3
- mirroring 15.2.3.3
- placement on disk 15.2.3.2
- sizing 4.1.3
reducing
- contention with dispatchers 4.3.1
- paging and swapping 10.4.4.1
REEXECUTE_FAILED_AUTO_TASKS Procedure 7.3.5.2
RELEASE_CURSOR clause 12.2.6.2
Remote Management Framework (RMF) 6.2.8.1
resources
- allocation 2.4.1.2, 2.5.6
response time 2.4.2
reverse key indexes 2.5.3.2
RMF 6.2.8.1
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
selectivity
- ordering columns in an index 2.5.3.5
service hours 2.4.2
session memory statistic 12.4.3
SGA_TARGET initialization parameter
- automatic memory management 10.2
SHARED_POOL_SIZE initialization parameter 12.3.1.4, 12.3.1.5
shared server
- performance issues 4.3
- reducing contention 4.3
- tuning 4.3
- tuning memory 12.4.1
SHOW SGA statement 10.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 14.1.1
SQL Tuning Advisor 1.2.1
statistics
- baselines 6.1
- consistent gets from cache 11.2.2
- databases 5.1
- db block gets from cache 11.2.2
- gathering 5.1
- max session memory 12.4.3
- physical reads from cache 11.2.2
- session memory 12.4.3
- shared server processes 4.3.2
- time model 5.1.1
STREAMS_POOL_SIZE initialization parameter 10.4
striping
- manual 15.2.2
swapping 16.4.1.1.1, 16.4.1.2
- reducing 10.4.4.1
switching processes 16.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 10.4.4.2

T

tables
- creating 4.2
- design 2.5.3
- placement on disk 15.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 16.4.1.2
time model statistics 5.1.1
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
- shared server 4.3
- sorts 14.1.1
- System Global Area (SGA) 10.4.4.2

U

undo management, automatic mode 4.1.2
Unified Memory 10.1
UNIX system performance 16.2.1
user global area (UGA)
- shared servers 4.3, 12.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$BUFFER_POOL_STATISTICS view 11.3.4
V$DB_CACHE_ADVICE view 11.2.1
V$JAVA_LIBRARY_CACHE_MEMORY view 12.3.1.2.3
V$JAVA_POOL_ADVICE view 12.3.1.2.3
V$LIBRARY_CACHE_MEMORY view 12.3.1.2.2
V$LIBRARYCACHE view
- NAMESPACE column 12.3.1.1.1
V$QUEUE view 4.3.2
V$ROWCACHE view
- performance statistics 12.3.1.3
V$SESSTAT view 12.4.3
V$SHARED_POOL_ADVICE view 12.3.1.2.1
V$SHARED_POOL_RESERVED view 12.3.6.1
V$SYSSTAT view
- redo buffer allocation 11.4.2
- using 11.2.2
validating designs 2.6.4
views 2.5.4
vmstat UNIX command 16.4.1.1.1

W

wait events 5.1.3
- classes 5.1.3
Windows performance 16.2.2
workloads 2.6.2, 2.6.3, 2.6.4