Index
A
- ADDM
- enabling in a PDB 7.1.3.1
- allocation of memory 9.1
- applications
- Automatic Database Diagnostic Monitor
- 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
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
- 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
D
- data
- database caching modes
- database monitoring 1.2.1
- diagnostic 7.1
- Database Resource Manager 16.1.3, 16.4.2
- databases
- 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
- DBMS_SHARED_POOL package
- managing the shared pool 12.3.5
- DB time
- debugging designs 2.6.4
- deploying applications 2.7
- design principles 2.5
- designs
- development environments 2.5.6
- diagnostic monitoring 1.2.1, 7.1
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
- instance caging 16.4
- instance configuration
- Internet scalability 2.3.2
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
- MEMOPTIMIZE FOR WRITE clause 10.7.2.2
- memoptimize pool 10.7.3.2
- memory
- hardware component 2.4.1.1
- memory allocation
- memory management
- automatic shared 9.2.2
- metrics 6.1
- mirroring
- redo logs 15.2.3.3
- modeling
- monitoring
- diagnostic 1.2.1
- multiple buffer pools 11.3
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
- Oracle Enterprise Manager Cloud Control 1.2
- Oracle Forms
- control of parsing and private SQL areas 12.2.6.5
- Oracle Managed Files 15.2.5
- Oracle Orion
- 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
- parsing
- partitioned indexes 2.5.3.2
- performance
- Performance Hub active reports
- 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
R
S
- scalability 2.3.1
- 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
- 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
- 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
- System Global Area tuning 10.4.4.2
T
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
- validating designs 2.6.4
- views 2.5.4
- vmstat UNIX command 16.4.1.1.1