Index
A B C D E F G H I J L M N O P Q R S T U V W
A
- Active/Active configurations
- and Real Application Clusters, 1-3
- adding nodes, 2-8
- administration
- aspects of scalability in Real Application Clusters, 2-8
- advanced queuing
- and queue table cache transfers, 3-6
- and queue table instance affinity, 3-6
- in Real Application Clusters, performance, 3-5
- affinity
- of data in Real Application Clusters, 2-4
- tables and advanced queuing, 3-6
- ALLOCATE EXTENT
- DATAFILE clause, B-8
- exclusive mode, B-8
- in exclusive mode, B-8
- INSTANCE clause, B-8
- SIZE clause, B-8
- allocation
- automatic, B-9
- Cache Fusion resources, A-7
- extents, dynamic, A-10
- of Cache Fusion resources, A-7
- ALTER CLUSTER statement
- ALLOCATE EXTENT clause, B-7
- ALTER DATABASE statement
- DATAFILE RESIZE, A-5
- ALTER SEQUENCE statement
- increasing cache size with, 4-11
- ALTER SESSION statement
- SET INSTANCE clause, B-6
- ALTER TABLE statement
- ALLOCATE EXTENT, B-7
- application workloads
- from Statspack statistics, 4-7
- asynchronous I/O
- for writing large amounts of data, 3-5
- AUTOEXTEND clause, A-5
- automatic segment-space management, 1-2, 3-2
- automatic undo management, 1-2
B
- bandwidth
- interconnect, 4-3
- block mode conversions
- statistics for, 4-6
- block size
- increasing for query performance, 3-5
- block transfers
- analyzing, 4-8
- buffer cache
- adjusting size for Real Application Clusters, 4-3
- as a statistics source, 4-6
- buffer sizes
- IPC, adjusting for Real Application Clusters, 4-3
C
- cache
- sequence numbers, 3-3
- size and sequence number use, 3-3
- size, default and sequence numbers, 3-3
- sizing, 4-15
- transfer of queue table blocks in AQ, 3-6
- Cache Fusion
- and e-commerce applications, 2-2
- resources, exclusive, A-6
- resources, shared, A-6
- resources, specifying, A-5
- sources of performance statistics for, 4-6
- capacity limitations
- identified through stress testing, 2-8
- CATCLUST.SQL script
- using to create views for Real Application Clusters, 4-5
- charts
- Performance Manager, 5-2
- checkpoints, 4-3
- infrequency, 4-15
- cluster file systems
- in Real Application Clusters, 1-2
- CLUSTER_INTERCONNECTS
- parameter, 4-4
- clustered tables
- with free lists and free list groups, B-5
- clusters
- free list groups, B-8
- free lists, B-5
- hash cluster, B-5
- parallel execution tuning, A-10
- communication protocols
- verifying settings for, 4-3
- compatibility
- shared and exclusive modes, B-8
- composite partitioned objects
- for hot block performance issues, 3-3
- concurrency
- inserts and updates, B-4
- configurations
- full active, 1-3
- connection load balancing, 1-5
- control files
- datafiles, B-8
- cost-based optimizer, 2-5
- CREATE CLUSTER statement, B-5
- FREELIST GROUPS clause, B-4
- FREELISTS clause, B-4
- CREATE statement
- setting FREELISTS and FREELIST GROUPS, B-3
- CREATE TABLE statement
- clustered tables, B-5
- FREELISTS clause, B-4
- initial storage, B-9
- cyclic redundancy check (CRC) errors, 4-10
D
- data affinity, 2-4
- data blocks
- cache transfers in advanced queuing, 3-6
- data dictionary
- querying views, 4-5
- Data Guard, 1-4
- data locality
- in Real Application Clusters, 2-4
- data warehouse
- deploying applications for in Real Application Clusters, 2-3
- Database Configuration Assistant (DBCA)
- creating views for Real Application Clusters, 4-5
- database resources
- dynamic migration, 2-3
- database writer processes
- and checkpoints, 4-3
- improving performance of, 3-5
- datafiles
- allocating extents, B-8
- multiple files for each table, B-9
- DB_BLOCK_SIZE
- parameter, 3-5
- DB_FILE_MULTIBLOCK_READ_COUNT
- increasing for full table scans, 3-5
- parameter, 3-5
- DBA_QUEUE_TABLES
- analyzing table and instance affinity in advanced queuing, 3-6
- DBWRn processes
- and checkpoints, 4-3
- improving performance of, 3-5
- DC_SEQUENCES
- parameter, 3-3
- dedicated server
- and connection load balancing, 1-5
- degree of parallelism (DOP), 2-4
- disk affinities
- and parallel query, 2-7
- disk writes
- reasons for, 4-14
- dynamic performance views
- creating, 4-5
- for performance monitoring, 4-4
E
- e-commerce
- applications in Real Application Clusters, 2-2
- enqueue
- Global Enqueue Service (GES) statistics, 4-10
- error messages
- storage options, B-4
- exclusive mode
- free lists, B-4, B-8
- extent management, 3-2
- extents
- allocating to instance, B-6
- initial allocation, B-9
- not allocated to instance, B-9
- preallocating, B-7
- preallocating to free list groups, B-9
- size, B-8
- specifying a file, B-8
F
- failover
- and Real Application Clusters, 1-3
- false forced writes, A-14
- false pings, A-3
- FAST_START_MTTR_TARGET, 4-3
- parameter, 4-3
- features
- taking advantage of, 1-2
- File I/O Rate By Instance chart, 5-4
- File I/O Rate By Object chart, 5-4
- File I/O Rate chart, 5-4, 5-10
- files
- allocating extents, B-8
- forced disk writes, A-15
- false, A-14
- reasons for, 4-14
- free list groups
- assigning to session, B-6
- for concurrent inserts, B-2
- setting !blocks, A-5
- free lists
- cluster, B-5
- creating for clustered tables, B-5
- creating for indexes, B-6
- examples, B-5
- hash cluster, B-5
- in exclusive mode, B-3, B-8
- number of lists, B-4
- FREELIST GROUPS clause, B-4
- determining reorganization needs, B-3
- parameter, use, B-4
- parameter, use with indexes, B-6
- FREELISTS clause, B-4
- creating for clustered tables, B-5
- creating for indexes, B-6
- examples of use, B-5
- maximum value, B-4
- parameter, use, B-4
- parameter, use with indexes, B-6
- STORAGE clause, B-4
- full active configurations, 1-3
- function shipping, 2-4
- fusion write, 4-14
G
- GC_FILES_TO_LOCKS parameter, A-6, A-10
- examples, A-5
- reducing false pings, A-15
- setting, A-4
- syntax, A-4
- global cache blocks corrupt, 4-11
- global cache blocks lost, 4-11
- Global Cache Convert By Instance chart, 5-4
- Global Cache Convert chart, 5-4, 5-8, 5-11
- global cache cr request, 4-12
- Global Cache CR Request By Instance chart, 5-4
- Global Cache CR Request chart, 5-4, 5-7
- Global Cache Current Block Request By Instance chart, 5-4
- Global Cache Current Block Request chart, 5-4, 5-9, 5-11
- global cache null to s, 4-12
- global cache null to x, 4-12
- global cache open s, 4-12
- global cache open x, 4-12
- Global Cache Service (GCS)
- analyzing the interconnect, 4-10
- and logical reads, 4-13
- as a statistics source, 4-6
- message traffic and interconnect, 4-3
- resources, A-11
- resources, acquisition, 3-6
- statistics for, 4-9
- global cache wait events, 4-9
- global cache waits, 4-12
- Global Enqueue Service (GES)
- message traffic and interconnect, 4-3
- statistics, 4-10
- statistics for, 4-9
- GLOBAL hint, 4-4
- global V$ view tables, 5-2
H
- hash clusters, B-5
- hash partitioned objects
- for hot block performance issues, 3-3
- high availability
- and Real Application Clusters, 1-3
- full active configurations, 1-3
- hot blocks
- objects, 4-14
- resolving performance issues for, 3-2
I
- identifiers
- for resources, A-16
- incremental growth, B-9
- index leaf blocks
- performance of, 4-10
- indexes
- block splits, 3-3
- using with free lists and free list groups, B-6
- INITIAL storage parameter
- minimum value, B-9
- initialization parameters
- CLUSTER_INTERCONNECTS, 4-4
- DB_BLOCK_SIZE, 3-5
- DB_FILE_MULTIBLOCK_READ_COUNT, 3-5
- DC_SEQUENCES, 3-3
- FAST_START_MTTR_TARGET, 4-3
- INITRANS, 4-11
- INSTANCE_GROUPS, 2-6
- INSTANCE_ROLL, 1-5
- LOG_CHECKPOINT_INTERVAL, 4-3
- LOG_CHECKPOINT_TIMEOUT, 4-3
- MAXTRANS, 4-11
- PARALLEL_INSTANCE_GROUP, 2-6
- PARALLEL_MAX_SERVERS, 4-4, 4-5
- PCTINCREASE, B-8
- STATISTICS_LEVEL, 4-6
- TIMED_STATISTICS, 4-6
- INITRANS
- parameter, 4-11
- INSERTS
- concurrent, B-4
- free space unavailable, B-8
- inserts
- space management, 3-2
- INST_ID column, 4-4
- INSTANCE clause
- SET INSTANCE statement, B-6
- INSTANCE_GROUPS
- initialization parameter, 2-6
- INSTANCE_NUMBER parameter
- initialization parameters
- INSTANCE_NUMBER, B-6
- INSTANCE_ROLE
- use of in secondary instance connections, 1-5
- instances
- adding instances, B-9
- associated with datafile, B-9
- associated with extent, B-6
- associating with free list groups, B-6
- free list, B-8
- number, B-6
- interconnect
- and performance, 4-3
- bandwidth, 4-3
- identifying with SQL*Plus, 4-4
- latency, analyzing Global Cache Service (GCS) timings, 4-10
- protocols for Real Application Clusters, 4-3
- verifying settings for, 4-3
- intranode parallelism, 2-5
- IPCs
- and Cache Fusion, 4-2
- buffer sizes, adjusting, 4-3
J
- JDBC OCI, 1-5
L
- leaf blocks
- indexes, performance issues for, 4-10
- Library Cache Lock By Instance chart, 5-4
- Library Cache Lock chart, 5-4, 5-8, 5-11
- load balancing, 2-5
- load processing capabilities, 2-7
- locally managed table spaces, 3-2
- locks
- deciding whether to use by setting GC_FILES_TO_LOCKS, A-2
- setting with GC_FILES_TO_LOCKS, A-2
- when to use locks, A-3
- LOG_CHECKPOINT_INTERVAL, 4-3
- parameter, 4-3
- LOG_CHECKPOINT_TIMEOUT, 4-3
- parameter, 4-3
- logical reads
- and the Global Cache Service (GCS), 4-13
M
- mapping blocks to Cache Fusion resources, A-6
- MAXEXTENTS storage parameter
- automatic allocations, B-9
- MAXTRANS
- parameter, 4-11
- memory-mapped IPCs
- and Cache Fusion, 4-2
- message request counters, 4-6
- migration
- returning to exclusive mode, B-8
- MINEXTENTS storage parameter
- automatic allocations, B-9
- default, B-9
- monitoring
- procedures for, 4-8
- statistics for Real Application Clusters, 4-5
N
- nodes
- adding, 2-8, B-9
O
- objects
- creation of and effect on performance, 3-2
- hot blocks, 4-14
- identifying performance issues for, 4-9
- partitioning for hot blocks, 3-2
- OCI library, 1-5
- online transaction processing
- in Real Application Clusters, 2-2
- operating system
- striping for performance, 3-5
- Oracle
- compatibility, B-8
- Oracle Net
- OCI libraries, 1-5
- Oracle Performance Manager
- displaying charts, 5-2
- overview, 5-2
- oradebug
- ipc, 4-4
- setmypid, 4-4
P
- packets
- dropped, 4-10
- parallel execution
- and load balancing, 2-5
- clusters, A-10
- processes, 4-5
- server processes and data affinity, 2-4
- parallel instance groups, 2-6
- PARALLEL_INSTANCE_GROUP
- parameter, 2-6
- PARALLEL_MAX_SERVERS
- parameter, 4-4, 4-5
- parallelism
- in Real Application Clusters, 2-4
- parallel-aware query optimization, 2-5
- Past Images (PI)
- as used in recovery, 4-3
- PCTINCREASE parameter
- table extents, B-8
- performance
- issues in applications in Real Application Clusters, 3-4
- maintaining history of, 4-6
- primary components affecting, 4-3
- testing, 2-7
- using Statspack, 4-7
- wait events, analyzing, 4-12
- Performance Manager
- charts, hierarchies, 5-4
- PL/SQL
- in Real Application Clusters, 1-6
- packages and TAF, 1-5
- preallocating
- extents, B-7
- extents to free list groups, B-9
- Primary/Secondary Instance configurations
- and Real Application Clusters, 1-3
- and TAF, 1-5
- processes
- parallel execution, 4-5
- protocols
- interconnect, 4-2
Q
- queries
- tuning tips, 3-4
R
- raw devices, 1-2
- Real Application Clusters
- and e-commerce, 2-2
- disk affinities, 2-7
- parallel execution, A-10
- tablespace use, 3-2
- Real Application Clusters Database Health Overview chart, 5-4, 5-11, 5-12
- Real Application Clusters Guard I, 1-4
- Real Application Clusters Guard II, 1-3
- Real Application Clusters Top Sessions chart, 5-4, 5-10
- resources
- acquisition and the GCS, 3-6
- dynamic migration, 2-3
- identifier, A-16
- name format, A-16
- response times
- analyzing, 4-12
- retransmits, 4-10
- RMAN
- in Real Application Clusters, 1-6
- Row Cache Lock By Instance chart, 5-4
- Row Cache Lock chart, 5-4, 5-9, 5-11
S
- scalability tests, 2-7
- segments
- header, A-17
- sequence numbers
- and global conflicts, 3-3
- caching, suppressing with ordering, 3-3
- generation and tablespace use, 3-2
- generation with database tables, 3-4
- using, 3-3
- server parameter file, 1-2
- server processes
- and parallel execution, 2-4
- Sessions chart, 5-4, 5-10
- setting locks, A-2
- shared disk architectures
- and data affinity, 2-4
- shared nothing systems
- and data affinity, 2-4
- shared pool
- adjusting size for Real Application Clusters, 4-3
- shared resource system, B-9
- shared server
- and connection load balancing, 1-4
- in Real Application Clusters, 1-4
- space
- allocating extents, B-9
- not allocated to instance, B-9
- unavailable in exclusive mode, B-8
- SQ Enqueue
- from V$ENQUEUE_STATS, 4-11
- standby databases, 1-4
- statistics
- contents of, 4-6
- maintaining records of, 4-6
- monitoring for Real Application Clusters, 4-5
- where maintained, 4-6
- where Oracle collects from, 4-6
- STATISTICS_LEVEL
- parameter, 4-6
- Statspack
- using in Real Application Clusters, 4-7
- storage, 1-2
- options, clustered tables, B-4
- options, extent size, B-8, B-9
- options, table, B-4
- striping
- and disk affinity, 2-7
- System Global Area (SGA)
- for statistics maintenance, 4-6
T
- tables
- affinity and advanced queuing, 3-6
- cluster, B-5
- free space unavailable, B-8
- initial storage, B-9
- multiple files, B-9
- with high insert rates, 3-3
- tablespaces
- locally managed for automatic segment-space management, 3-2
- use in Real Application Clusters, 3-2
- timed statistics, 4-6
- TIMED_STATISTICS
- parameter, 4-6
- Total Transfer chart, 5-4, 5-6, 5-11
- hierarchy for lower-level charts, 5-5
- traffic generators, 2-7
- transaction monitor, 1-4
- Transfer By File chart, 5-4, 5-7
- Transfer By File Per Instance chart, 5-4
- Transfer By Instance chart, 5-4
- Transfer By Instance Per File chart, 5-4
- Transfer By Instance Per Object chart, 5-4
- Transfer By Object Per File chart, 5-4
- transparent application failover (TAF), 1-5
- TX Enqueue
- from V$ENQUEUE_STATS, 4-11
U
- user sessions
- associating with free list groups, B-6
- USER_QUEUE_TABLES
- analyzing table and instance affinity in advanced queuing, 3-6
- user-mode IPCs
- and Cache Fusion, 4-2
- Users By Instance chart, 5-4
- Users chart, 5-4, 5-10
V
- V$BH
- identifying contended objects with, 4-15
- V$CACHE
- identifying contended objects with, 4-15
- V$CACHE_TRANSFER
- identifying contended objects with, 4-15
- versions, Oracle
- compatibility, B-8
- VIA
- interconnect protocol, 4-2
- views
- creating for Real Application Clusters, 4-5
- for performance monitoring, 4-4
W
- wait events
- analyzing, 4-12
- workloads
- distribution for data warehouse applications, 2-5
- from Statspack statistics, 4-7