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 9.3.8

    • load profile 9.3.2

    • top events 9.3.1

    • top files 9.3.7

    • top Java 9.3.5

    • top latches 9.3.7

    • top objects 9.3.7

    • top PL/SQL 9.3.4

    • top sessions 9.3.6

    • Top SQL 9.3.3

    • using 9.3

  • reports 9.2

• ADDM

  • enabling in a PDB 7.1.3.1

• allocation of memory 11.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 segment-space management 4.1.4, 10.3.2, 17.2.6.2

• Automatic shared memory management 12.1

• 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 8.1

    • advisory statistics 8.3.2.8, 8.3.2.16

    • details 8.3.2

    • dictionary cache statistics 8.3.2.14

    • I/O statistics 8.3.2.7

    • instance activity statistics 8.3.2.6

    • latch statistics 8.3.2.11

    • library cache statistics 8.3.2.15

    • operating system statistics 8.3.2.2

    • segment statistics 8.3.2.12, 8.3.2.13

    • service statistics 8.3.2.4

    • SQL statistics 8.3.2.5

    • summary 8.3.1

    • supplemental information 8.3.3

    • time model statistics 8.3.2.1

    • undo statistics 8.3.2.10

    • using 8.3

    • wait events 8.3.2.3

    • wait statistics 8.3.2.9

  • 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 12.2

• Autonomous Transaction Processing

  • ATP 12.2

• 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 10.2.4

• block size

  • choosing 17.2.6

  • optimal 17.2.6

• bottlenecks

  • elimination 1.1.2.4.2

  • fixing 3.1

  • identifying 3.1

  • memory 11.1

  • resource 10.3.19

• B-tree indexes 2.5.3.2

• buffer busy wait events 10.3.2

  • actions 10.3.2

• buffer cache

  • contention 10.3.3, 10.3.4, 10.3.11

  • hit ratio 13.2.2

• buffer pools

  • multiple 13.3

• buffer waits

  • about 8.3.2.9.1

• business logic 2.4.1.2, 2.5.6

---

C

• chained rows 10.2.4

• classes

  • wait events 5.1.3, 10.1.3.2

• client/server applications 18.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 10.2.4

• consistent gets from cache statistic 13.2.2

• contention

  • library cache latch 10.3.11

  • memory 10, 11.1

  • shared pool 10.3.11

  • tuning 10

  • wait events 10.3.11

• context switches 18.4.1.4.2

• CONTROL_FILES initialization parameter 4.1.1

• CPUs 2.4.1.1

  • statistics 10.1.2.1.3

  • utilization 18.4.1

• CREATE INDEX statement

  • PARALLEL clause 4.2.3

• CURSOR_SHARING initialization parameter 14.2.1

• CURSOR_SPACE_FOR_TIME initialization parameter 14.3.2

• cursors

  • accessing 14.2.6

  • sharing 14.2.6

---

D

• data

  • and transactions 2.4.1.2

  • cache 18.1.1

  • gathering 5.1

  • modeling 2.5.2

  • queries 2.4.2

  • searches 2.4.2

• database caching modes

  • configuring 13.5

  • default database caching mode 13.5.1

  • determining which mode to use 13.5.3

  • force full database caching mode

    • about 13.5.2

  • verifying 13.5.4

• database monitoring 1.2.1

  • diagnostic 7.1

• database performance

  • comparing 8.1

  • degradation over time 8.1

• Database Resource Manager 10.1.2.1.3, 18.1.3, 18.4.2

• databases

  • diagnosing and monitoring 7.1

  • size 2.4.2

  • statistics 5.1

• database tuning

  • performance degradation over time 8.1

  • transient performance problems 9.1

• DB_BLOCK_SIZE initialization parameter 17.2.1.2

• DB_DOMAIN initialization parameter 4.1.1

• DB_NAME initialization parameter 4.1.1

• DBA_OBJECTS view 13.3.5.2

• db block gets from cache statistic 13.2.2

• db file scattered read wait events 10.3.3

  • actions 10.3.3, 10.3.4

• db file sequential read wait events 10.3.3, 10.3.4

  • actions 10.3.4

• DBMS_ADVISOR package

  • setting DBIO_EXPECTED 7.2

  • setups for ADDM 7.2

• DBMS_SHARED_POOL package

  • managing the shared pool 14.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 8.3.2.14

• direct path

  • read events 10.3.5

  • read events actions 10.3.5

  • read events causes 10.3.5

  • wait events 10.3.6

  • write events actions 10.3.6

  • write events causes 10.3.6

• disks

  • monitoring operating system file activity 10.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 8.3.2.9.2

• enqueue wait events 10.3.7

  • actions 10.3.7

  • statistics 10.1.3.4

• estimating workloads 2.6.2

  • benchmarking 2.6.2

  • extrapolating 2.6.2

• extrapolating workloads 2.6.2

---

F

• FAST_START_MTTR_TARGET

  • and tuning instance recovery 10.4.3

• fast ingest 12.6.2, 12.6.2.1

• fast lookup

  • disabling for a table 12.6.3.3

• Fast-Start checkpointing architecture 10.4.2

• Fast-Start Fault Recovery 10.4, 10.4.2

• free buffer wait events 10.3.9

• free lists 10.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 14.2.6.2

• hours of service 2.4.2

---

I

• I/O

  • and SQL statements 10.3.3

  • contention 10.1.2.2.1, 10.1.3.2, 10.3.3, 10.3.15

  • excessive I/O waits 10.3.3

  • monitoring 10.1.2.2

  • objects causing I/O waits 10.3.3

• idle wait events 10.3.10

  • SQL*Net message from client 10.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 17.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 12.3

• instance activity

  • comparing 8.3.2.6

• instance caging 18.4

• instance configuration

  • initialization files 4.1.1

  • performance considerations 4.1

• instance recovery

  • Fast-Start Fault Recovery 10.4.2

  • performance tuning 10.4

• Internet scalability 2.3.2

---

L

• LARGE_POOL_SIZE initialization parameter 14.4.3

• latch contention

  • library cache latches 10.2.1

  • shared pool latches 10.2.1

• latches 9.3.7.3

  • tuning 1.1.2.3, 10.3.11

• latch free wait events

  • actions 10.3.11

• latch wait events 10.3.11

• library cache 8.3.2.15

  • latch contention 10.3.11

  • latch wait events 10.3.11

  • lock 10.3.14

  • pin 10.3.13

• linear scalability 2.3.3

• locks and lock holders

  • finding 10.3.7

• log buffer

  • space wait events 10.3.15

• log file

  • parallel write wait events 10.3.12

  • switch wait events 10.3.16

  • sync wait events 10.3.17

• log writer processes

  • tuning 17.2.3.2

• LRU

  • aging policy 13.3

  • latch contention 10.3.11

---

M

• MAXOPENCURSORS clause 14.2.6.2

• max session memory statistic 14.4.3

• MEMOPTIMIZE_POOL_SIZE initialization parameter 12.6.3.1

• MEMOPTIMIZE_WRITE hint 12.6.2.3

• Memoptimized Rowstore

  • about 12.6.1

  • fast ingest

    • about 12.6.2

    • disabling 12.6.2.4

    • enabling 12.6.2.2

    • prerequisites 12.6.2.1

    • using 12.6.2.3

  • fast lookup

    • about 12.6.3

    • enabling for a table 12.6.3.2

  • memoptimize pool 12.6.3.1

• MEMOPTIMIZE FOR WRITE clause 12.6.2.2

• memoptimize pool 12.6.3.1

• memory

  • hardware component 2.4.1.1

  • PGA statistics 8.3.2.8

  • statistics 8.3.2.16

• memory allocation

  • importance 11.1

  • tuning 12.3.5

• metrics 6.1

• migrated rows 10.2.4

• mirroring

  • redo logs 17.2.3.3

• modeling

  • conceptual 3.1.2

  • data 2.5.2

  • workloads 2.6.3

• monitoring

  • diagnostic 1.2.1

• multiple buffer pools 13.3

---

N

• NAMESPACE column

  • V$LIBRARYCACHE view 14.3.1.1.1

• network

  • hardware component 2.4.1.1

  • speed 2.4.2

• network communication wait events 10.3.19

  • db file scattered read wait events 10.3.3

  • db file sequential read wait events 10.3.3, 10.3.4

  • SQL*Net message from Dblink 10.3.19

  • SQL*Net more data to client 10.3.19

---

O

• object-orientation 2.5.7

• OPEN_CURSORS initialization parameter 4.1.1

• operating system

  • data cache 18.1.1

  • monitoring disk I/O 10.1.2.2

• optimization

  • described 1.1.3.1

• optimizer

  • introduction 1.1.3.1

  • query 1.1.3.1

• Oracle CPU statistics 10.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 14.2.6.5

• Oracle Managed Files 17.2.5

• Oracle Orion

  • calibration tool parameters 17.4.4

  • command-line options 17.4.4

• Oracle performance improvement method 3.1

  • steps 3.1.1

---

P

• page table 18.4.1.1.2

• paging 18.4.1.2

  • reducing 12.3.4.1

• PARALLEL clause

  • CREATE INDEX statement 4.2.3

• parameter

  • RESULT_CACHE_MODE 15.2.3

• parameters

  • initialization 8.3.3.1

• parsing

  • hard 2.5.5

  • Oracle Forms 14.2.6.5

  • Oracle precompilers 14.2.6.2

  • reducing unnecessary calls 14.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 18.2.3

  • monitoring memory on Windows 18.4.1.1.1

  • tools for diagnosing and tuning 1.2

  • tools for performance tuning 1.2

  • UNIX-based systems 18.2.1

  • Windows 18.2.2

• Performance Hub active reports

  • about 6.4.1

  • generating 6.4, 6.4.3

• performance problems

  • transient 9.1

• performance tuning

  • Fast-Start Fault Recovery 10.4

  • instance recovery 10.4

    • FAST_START_MTTR_TARGET 10.4.2

    • setting FAST_START_MTTR_TARGET 10.4.3

    • using V$INSTANCE_RECOVERY 10.4.2.3

• per-session PGA memory limit

  • PGA 16.3.2

• PGA_AGGREGATE_TARGET initialization parameter 4.1.1

• physical reads from cache statistic 13.2.2

• proactive monitoring 1.1.2.4.1

• processes

  • scheduling 18.4.1.4.1

• Program Global Area

  • PGA 12.2

• program global area (PGA)

  • direct path read 10.3.5

  • direct path write 10.3.6

  • shared servers 14.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 10.3.18

• read consistency 10.2.4

• read wait events

  • direct path 10.3.5

  • scattered 10.3.3

• redo logs 4.1.3

  • buffer size 10.3.15

  • mirroring 17.2.3.3

  • placement on disk 17.2.3.2

  • sizing 4.1.3

• reducing

  • contention with dispatchers 4.3.1

  • paging and swapping 12.3.4.1

• RELEASE_CURSOR clause 14.2.6.2

• Remote Management Framework (RMF) 6.2.8.1

• resources

  • allocation 2.4.1.2, 2.5.6

  • bottlenecks 10.3.19

  • wait events 10.3.4

• 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

• scattered read wait events 10.3.3

  • actions 10.3.3

• segment-level statistics 10.1.3.5

• selectivity

  • ordering columns in an index 2.5.3.5

• sequential read wait events

  • actions 10.3.4

• service hours 2.4.2

• session memory statistic 14.4.3

• SGA_TARGET initialization parameter

  • automatic memory management 12.1

• SHARED_POOL_SIZE initialization parameter 14.3.1.4, 14.3.1.5

• shared pool contention 10.3.11

• shared server

  • performance issues 4.3

  • reducing contention 4.3

  • tuning 4.3

  • tuning memory 14.4.1

• SHOW SGA statement 12.3.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 16.1.1

• SQL*Net

  • message from client idle events 10.3.19

  • message from dblink wait events 10.3.19

  • more data to client wait events 10.3.19

• SQL statements

  • waiting for I/O 10.3.3

• SQL Tuning Advisor 1.2.1

• statistics

  • baselines 6.1

  • consistent gets from cache 13.2.2

  • databases 5.1

  • db block gets from cache 13.2.2

  • dictionary cache 8.3.2.14

  • gathering 5.1

  • I/O 8.3.2.7

  • instance activity 8.3.2.6

  • latch 8.3.2.11

  • library cache 8.3.2.15

  • max session memory 14.4.3

  • memory 8.3.2.16

  • operating system

    • comparing 8.3.2.2

  • PGA memory 8.3.2.8

  • physical reads from cache 13.2.2

  • segment 8.3.2.12, 8.3.2.13

  • segment-level 10.1.3.5

  • service 8.3.2.4

  • session memory 14.4.3

  • shared server processes 4.3.2

  • SQL 8.3.2.5

  • time model 5.1.1, 8.3.2.1

  • undo 8.3.2.10

  • waits 8.3.2.9

• STREAMS_POOL_SIZE initialization parameter 12.3

• striping

  • manual 17.2.2

• swapping 18.4.1.1.1, 18.4.1.2

  • reducing 12.3.4.1

• switching processes 18.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 12.3.4.2

---

T

• tables

  • creating 4.2

  • design 2.5.3

  • placement on disk 17.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 18.4.1.2

• time model statistics 5.1.1

  • comparing 8.3.2.1

• Top Java

  • Active Session History report 9.3.5

• top PL/SQL

  • Active Session History report 9.3.4

• Top Sessions

  • Active Session History report 9.3.6

• Top SQL

  • Active Session History report 9.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, 10.3.11

  • resource contention 10

  • shared server 4.3

  • sorts 16.1.1

  • System Global Area (SGA) 12.3.4.2

---

U

• undo management, automatic mode 4.1.2

• UNIX system performance 18.2.1

• user global area (UGA)

  • shared servers 4.3, 14.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 10.1.3.3

• V$BUFFER_POOL_STATISTICS view 13.3.4

• V$DB_CACHE_ADVICE view 13.2.1

• V$EVENT_HISTOGRAM view 10.1.3.3

• V$FILE_HISTOGRAM view 10.1.3.3

• V$JAVA_LIBRARY_CACHE_MEMORY view 14.3.1.2.3

• V$JAVA_POOL_ADVICE view 14.3.1.2.3

• V$LIBRARY_CACHE_MEMORY view 14.3.1.2.2

• V$LIBRARYCACHE view

  • NAMESPACE column 14.3.1.1.1

• V$QUEUE view 4.3.2

• V$ROWCACHE view

  • performance statistics 14.3.1.3

• V$SESSION_EVENT view 10.1.3.3

• V$SESSION_WAIT_CLASS view 10.1.3.3

• V$SESSION_WAIT_HISTORY view 10.1.3.3

• V$SESSION_WAIT view 10.1.3.3

• V$SESSION view 10.1.3.3, 10.1.3.4

• V$SESSTAT view 14.4.3

• V$SHARED_POOL_ADVICE view 14.3.1.2.1

• V$SHARED_POOL_RESERVED view 14.3.6.1

• V$SYSSTAT view

  • redo buffer allocation 13.4.2

  • using 13.2.2

• V$SYSTEM_EVENT view 10.1.3.3

• V$SYSTEM_WAIT_CLASS view 10.1.3.3

• V$TEMP_HISTOGRAM view 10.1.3.3

• V$WAITSTAT view 10.1.3.4

• validating designs 2.6.4

• views 2.5.4

• vmstat UNIX command 18.4.1.1.1

---

W

• wait events 5.1.3

  • buffer busy waits 10.3.2

  • classes 5.1.3, 10.1.3.2

  • comparing 8.3.2.3

  • direct path 10.3.6

  • enqueue 10.3.7

  • free buffer waits 10.3.9

  • idle wait events 10.3.10

  • latch 10.3.11

  • library cache latch 10.3.11

  • log buffer space 10.3.15

  • log file parallel write 10.3.12

  • log file switch 10.3.16

  • log file sync 10.3.17

  • network communication wait events 10.3.19

  • rdbms ipc reply 10.3.18

  • resource wait events 10.3.4

• Windows performance 18.2.2

• workloads 2.6.2, 2.6.3, 2.6.4