Index
A
B
C
D
E
F
H
I
K
L
M
N
O
P
Q
R
S
T
U
V
W
A
- Active Session History, 5.1.2

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

- 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.4

- analysis results example, 7.1.5

- and DB time, 7.1.1

- CONTROL_MANAGEMENT_PACK_ACCESS parameter, 7.2

- DBIO_EXPECTED, 7.2

- example report, 7.1.5

- findings, 7.1.4

- overview, 7.1

- results, 7.1.4

- setups, 7.2

- STATISTICS_LEVEL parameter, 7.2

- types of problems considered, 7.1.1

- types of recommendations, 7.1.4

- automatic database diagnostic monitoring, 1.2.1

- automatic segment-space management, 4.1.4.1
, 10.3.2.2.1
, 17.2.6.2
- Automatic shared memory management, 12.1

- automatic SQL tuning, 1.2.1

- automatic undo management, 4.1.2
, 4.1.2
- Automatic Workload Repository, 1.2.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

- instance activity statistics, 8.3.2.6

- I/O statistics, 8.3.2.7

- 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

- DBMS_WORKLOAD_REPOSITORY package, 6.2.2.1
, 6.2.3.1
, 6.2.4.1
- default settings, 6.1.4

- factors affecting space usage, 6.1.4

- managing with APIs, 6.2.2.1
, 6.2.3.1
, 6.2.4.1
- minimizing space usage, 6.1.4

- overview, 6.1.1

- recommendations for retention period, 6.1.4

- reports, 6.3.2.1

- retention period, 6.1.4

- settings in DBA_HIST_WR_CONTROL view, 6.2.2.4.1

- space usage, 6.1.4

- statistics collected, 6.1.1

- turning off automatic snapshot collection, 6.1.4

- unusual percentages in reports, 6.3

- views for accessing data, 6.2.6

- 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.2

- big bang rollout strategy, 2.7.1

- bitmap indexes, 2.5.3.2.2

- block cleanout, 10.2.4.2

- 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.1.2

- B-tree indexes, 2.5.3.2.1

- buffer busy wait events, 10.2.3
, 10.3.2
-
- actions, 10.3.2.2

- buffer cache
-
- contention, 10.3.3
, 10.3.4
, 10.3.11.2
- hit ratio, 13.2.2

- buffer pools
-
- default cache, 13.3.1.1

- KEEP, 13.3.6

- KEEP cache, 13.3.1.1

- multiple, 13.3

- RECYCLE cache, 13.3.1.1

- buffer waits
-
- about, 8.3.2.9.1

- business logic, 2.4.1.2.2
, 2.5.6
C
- chained rows, 10.2.4.3

- classes
-
- wait events, 5.1.3
, 10.1.3.2
- client/server applications, 18.4.1.2

- column order
-
- indexes, 2.5.3.5

- COMPATIBLE initialization parameter, 4.1.1

- components
-
- hardware, 2.4.1.1

- software, 2.4.1.2

- conceptual modeling, 3.1.2

- consistency
-
- read, 10.2.4.2

- consistent gets from cache statistic, 13.2.2

- contention
-
- library cache latch, 10.3.11.3

- memory, 10
, 11.1
- shared pool, 10.3.11.3

- tuning, 10

- wait events, 10.3.11

- context switches, 18.4.1.4.2

- CONTROL_FILES initialization parameter, 4.1.1

- CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter
-
- enabling automatic database diagnostic monitoring, 7.2

- CPUs, 2.4.1.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.4

- 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.1.3
, 18.4.2
- database tuning
-
- performance degradation over time, 8.1

- transient performance problems, 9.1

- databases
-
- diagnosing and monitoring, 7.1

- size, 2.4.2

- statistics, 5.1

- db block gets from cache statistic, 13.2.2

- db file scattered read wait events, 10.2.3
, 10.3.3
, 10.3.3
-
- actions, 10.3.3.1
, 10.3.4.1
- db file sequential read wait events, 10.2.3
, 10.3.3
, 10.3.4
-
- actions, 10.3.4.1

- DB time
-
- metric, 7.1.1

- statistic, 5.1.1

- DB_BLOCK_SIZE initialization parameter, 4.1.1
, 17.2.1.2
- DB_CACHE_ADVICE parameter, 13.2.4

- DB_CACHE_SIZE initialization parameter, 13.3

- DB_DOMAIN initialization parameter, 4.1.1

- DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 10.3.3
, 17.2.1.1
, 17.2.1.2
, 17.2.1.3
- DB_KEEP_CACHE_SIZE
-
- initialization parameter, 13.3.6

- DB_NAME initialization parameter, 4.1.1

- DB_nK_CACHE_SIZE initialization parameter, 13.2.4

- DB_RECYCLE_CACHE_SIZE
-
- initialization parameter, 13.3.7

- DB_WRITER_PROCESSES initialization parameter, 10.3.9.3.1

- DBA_HIST views, 6.2.6

- DBA_HIST_WR_CONTROL view
-
- Automatic Workload Repository settings, 6.2.2.4.1

- DBA_OBJECTS view, 13.3.5.2

- DBIO_EXPECTED parameter, 7.2

- DBMS_ADDM package
-
- Automatic Database Diagnostic Monitor, 7.3

- DBMS_ADVISOR package
-
- setting DBIO_EXPECTED, 7.2

- setups for ADDM, 7.2
, 7.2
- DBMS_RESULT_CACHE, 15.2.1.2

- DBMS_SHARED_POOL package
-
- managing the shared pool, 14.3.5

- DBMS_WORKLOAD_REPOSITORY package
-
- managing the Automatic Workload Repository, 6.2.2.1
, 6.2.3.1
, 6.2.4.1
- debugging designs, 2.6.4

- default cache, 13.3.1.1

- 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
-
- introduction, 7.1

- dictionary cache, 8.3.2.14

- direct path
-
- read events, 10.3.5

- read events actions, 10.3.5.2

- read events causes, 10.3.5.1

- wait events, 10.3.6

- write events actions, 10.3.6.2

- write events causes, 10.3.6.1

- 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.2.3
, 10.3.7
-
- actions, 10.3.7.2

- statistics, 10.1.3.4.5

- estimating workloads, 2.6.2

-
- benchmarking, 2.6.2.2

- extrapolating, 2.6.2.1

- EXTENT MANAGEMENT LOCAL
-
- creating temporary tablespaces, 4.1.4.2

- extrapolating workloads, 2.6.2.1

F
- FAST_START_MTTR_TARGET
-
- and tuning instance recovery, 10.4.3

- Fast-Start checkpointing architecture, 10.4.2

- Fast-Start Fault Recovery, 10.4
, 10.4.2
- FILESYSTEMIO_OPTIONS initialization parameter, 18.1.1.2

- free buffer wait events, 10.2.3
, 10.3.9
- free lists, 10.3.2.2.1

- full table scans, 10.3.5.2.2

- function-based indexes, 2.5.3.2.3

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

- HW enqueue
-
- contention, 10.3.7.2.2

I
- idle wait events, 10.3.10

-
- SQL*Net message from client, 10.3.19.1

- implementing business logic, 2.4.1.2.2

- indexes
-
- adding columns, 2.5.3.1

- appending columns, 2.5.3.1

- bitmap, 2.5.3.2.2

- B-tree, 2.5.3.2.1

- 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.3

- partitioned, 2.5.3.2.4

- placement on disk, 17.2.2

- reducing I/O, 2.5.3.5

- reverse key, 2.5.3.2.5

- 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_BLOCK_SIZE, 4.1.1

- DB_DOMAIN, 4.1.1

- DB_NAME, 4.1.1

- OPEN_CURSORS, 4.1.1

- PGA_AGGREGATE_TARGET, 4.2.3.1

- PROCESSES, 4.1.1

- SESSIONS, 4.1.1

- STREAMS_POOL_SIZE, 4.1.1
, 12.2
- In-Memory Column Store
-
- about, 12.4.1

- configuring, 12.4

- estimating required size, 12.4.3

- performance benefits, 12.4.2

- sizing, 12.4.4

- In-Memory Column Store (IM column store), Preface

- 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

- I/O
-
- and SQL statements, 10.3.3.4

- contention, 10.1.2.2.1
, 10.1.3.2
, 10.3.3.2
, 10.3.15
- excessive I/O waits, 10.3.3.2

- monitoring, 10.1.2.2

- objects causing I/O waits, 10.3.3.5

K
- KEEP buffer pool, 13.3.6

- KEEP cache, 13.3.1.1

L
- LARGE_POOL_SIZE initialization parameter, 14.4.3

- latch contention
-
- library cache latches, 10.2.1.2

- shared pool latches, 10.2.1.2

- latch free wait events, 10.2.3

-
- actions, 10.3.11.1

- latch wait events, 10.3.11

- latches, 9.3.7.3

-
- tuning, 1.1.2.3
, 10.3.11.3
- library cache, 8.3.2.15

-
- latch contention, 10.3.11.3

- latch wait events, 10.3.11.1

- lock, 10.3.14

- pin, 10.3.13

- linear scalability, 2.3.3

- locks and lock holders
-
- finding, 10.3.7.1

- log buffer
-
- space wait events, 10.2.3
, 10.3.15
- log file
-
- parallel write wait events, 10.3.12

- switch wait events, 10.3.16

- sync wait events, 10.2.3
, 10.3.17
- log writer processes
-
- tuning, 17.2.3.2

- LOG_BUFFER initialization parameter, 13.4.1

- LRU
-
- aging policy, 13.3

- latch contention, 10.3.11.3.4

M
- managing the user interface, 2.4.1.2.1

- max session memory statistic, 14.4.3

- MAX_DISPATCHERS initialization parameter, 4.3.1.1

- MAXOPENCURSORS clause, 14.2.6.2

- memory
-
- hardware component, 2.4.1.1.2

- PGA statistics, 8.3.2.8

- statistics, 8.3.2.16

- memory allocation
-
- importance, 11.1

- tuning, 12.2.5

- metrics, 6.1

- migrated rows, 10.2.4.3

- 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.4

- 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.2

- SQL*Net more data to client, 10.3.19.3

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
- optimizer
-
- introduction, 1.1.3.1

- query, 1.1.3.1

- Oracle CPU statistics, 10.1.2.1.3

- Oracle Enterprise Manager
-
- 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

-
- tuning, 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
- package
-
- DBMS_RESULT_CACHE, 15.2.1.2

- page table, 18.4.1.1.2

- paging, 18.4.1.2

-
- reducing, 12.2.4.1

- PARALLEL clause
-
- CREATE INDEX statement, 4.2.3

- parameter
-
- RESULT_CACHE_MAX_SIZE, 15.2.1.1

- 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.4

- PCTFREE parameter, 4.2
, 10.2.4.3
- PCTUSED parameter, 10.2.4.3
, 10.2.4.3
- 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

- 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

- PGA_AGGREGATE_TARGET initialization parameter, 4.1.1
, 4.2.3.1
, 16.2.1
, 18.1.2.2
- physical reads from cache statistic, 13.2.2

- PRIVATE_SGA variable, 14.4.4

- proactive monitoring, 1.1.2.4.1

- processes
-
- scheduling, 18.4.1.4.1

- PROCESSES initialization parameter, 4.1.1

- 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.2

- read wait events
-
- direct path, 10.3.5

- scattered, 10.3.3

- RECYCLE cache, 13.3.1.1

- REDO BUFFER ALLOCATION RETRIES statistic, 13.4.2

- 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

- space requests, 10.2.4.1

- reducing
-
- contention with dispatchers, 4.3.1.1

- paging and swapping, 12.2.4.1

- RELEASE_CURSOR clause, 14.2.6.2

- resources
-
- allocation, 2.4.1.2.3
, 2.5.6
- bottlenecks, 10.3.19.1.2

- wait events, 10.3.4

- response time, 2.4.2

- reverse key indexes, 2.5.3.2.5

- rollout strategies
-
- big bang approach, 2.7.1

- trickle approach, 2.7.1

- row cache objects, 10.3.11.3.6

S
- sar UNIX command, 18.4.1.1.1

- scalability, 2.3.1

-
- factors preventing, 2.3.3
, 2.3.3
- Internet, 2.3.2

- linear, 2.3.3

- scattered read wait events, 10.3.3

-
- actions, 10.3.3.1

- 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.1

- service hours, 2.4.2

- session memory statistic, 14.4.3

- SESSIONS initialization parameter, 4.1.1

- SGA_TARGET initialization parameter, 4.1.1

-
- and Automatic Shared Memory Management, 12.1.2.1

- automatic memory management, 12.1

- shared pool contention, 10.3.11.3

- shared server
-
- performance issues, 4.3

- reducing contention, 4.3

- tuning, 4.3

- tuning memory, 14.4.1

- SHARED_POOL_SIZE initialization parameter, 14.3.1.4
, 14.3.1.5
- SHOW SGA statement, 12.2.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 statements
-
- waiting for I/O, 10.3.3.4

- SQL Tuning Advisor, 1.2.1

- SQL*Net
-
- message from client idle events, 10.3.19.1

- message from dblink wait events, 10.3.19.2

- more data to client wait events, 10.3.19.3

- ST enqueue
-
- contention, 10.3.7.2.1

- statistics
-
- and STATISTICS_LEVEL initialization parameter, 1.2

- 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

- instance activity, 8.3.2.6

- I/O, 8.3.2.7

- 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

- STATISTICS_LEVEL initialization parameter, 5.2.2
, 10.1.3.1
-
- and Automatic Workload Repository, 6.2.1

- enabling automatic database diagnostic monitoring, 7.2

- settings for statistic gathering, 1.2

- STREAMS_POOL_SIZE initialization parameter, 4.1.1
, 12.2
- striping
-
- manual, 17.2.2

- swapping, 18.4.1.1.1
, 18.4.1.2
-
- reducing, 12.2.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.1

- I/O subsystems, 2.4.1.1.3

- memory, 2.4.1.1.2

- networks, 2.4.1.1.4

- software components, 2.4.1.2

-
- data and transactions, 2.4.1.2.4

- implementing business logic, 2.4.1.2.2

- managing the user interface, 2.4.1.2.1

- user requests and resource allocation, 2.4.1.2.3

- System Global Area tuning, 12.2.4.2

T
- tables
-
- creating, 4.2

- design, 2.5.3

- full scans, 10.3.5.2.2

- placement on disk, 17.2.2

- setting storage options, 4.2

- tablespaces, 4.1.4

-
- creating, 4.1.4
, 4.1.4.2
- temporary, 4.1.4
, 4.1.4.2
- temporary tablespaces, 4.1.4

-
- creating, 4.1.4.2

- testing designs, 2.6.4

- thrashing, 18.4.1.2

- time model statistics, 5.1.1

-
- comparing, 8.3.2.1

- TM enqueue contention, 10.3.7.2.3

- tools for performance tuning, 1.2

- 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.4

- 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.3
- resource contention, 10

- shared server, 4.3

- sorts, 16.1.1

- System Global Area (SGA), 12.2.4.2

- TX enqueue contention, 10.3.7.2.4

U
- undo management, automatic mode, 4.1.2

- UNDO TABLESPACE clause, 4.1.2

- UNDO_MANAGEMENT initialization parameter, 4.1.1
, 4.1.2
- UNDO_TABLESPACE initialization parameter, 4.1.1

- UNIX system performance, 18.2.1

- user global area (UGA)
-
- shared servers, 4.3
, 14.4.1
- user requests, 2.4.1.2.3

- 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

- UTLCHN1.SQL script, 10.2.4.3

V
- V$ACTIVE_SESSION_HISTORY view, 5.1.2
, 10.1.3.3
- V$BH view, 13.3.5

- V$BUFFER_POOL_STATISTICS view, 13.3.4

- V$DB_CACHE_ADVICE view, 13.2.1
, 13.2.2
, 13.2.4
, 13.2.5
, 13.3.3
- 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$RSRC_CONSUMER_GROUP view, 10.1.2.1.3

- V$SESS_TIME_MODEL view, 5.1.1
, 10.1.3.3
- V$SESSION view, 10.1.3.3
, 10.1.3.4
, 10.3
- V$SESSION_EVENT view, 10.1.3.3
, 10.3
- V$SESSION_WAIT view, 10.1.3.3
, 10.3
- V$SESSION_WAIT_CLASS view, 10.1.3.3

- V$SESSION_WAIT_HISTORY view, 10.1.3.3
, 10.1.3.3
, 10.3
- V$SESSTAT view, 10.1.2.1.3
, 14.4.3
- V$SHARED_POOL_ADVICE view, 14.3.1.2.1

- V$SHARED_POOL_RESERVED view, 14.3.6.1

- V$SYS_TIME_MODEL view, 5.1.1
, 10.1.3.3
- V$SYSSTAT view
-
- redo buffer allocation, 13.4.2

- using, 13.2.2

- V$SYSTEM_EVENT view, 10.1.3.3
, 10.3
- V$SYSTEM_WAIT_CLASS view, 10.1.3.3

- V$TEMP_HISTOGRAM view, 10.1.3.3

- V$UNDOSTAT view, 4.1.2

- V$WAITSTAT view, 10.1.3.4

- validating designs, 2.6.4

- views, 2.5.4

-
- DBA_HIST, 6.2.6

- 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

- contention wait events, 10.3.11

- 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.1

- 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.2.1
, 2.6.2.2
, 2.6.3
, 2.6.4