Index
A
Access control list (ACL), 487
Allocation units (AUs), 323
Alter griddisk command, 492, 493
ApplyConfig, 261
Automatic degree of parallelism (Auto DOP)
I/O calibration, 149, 151, 152
operation and configuration, 146–148
single DOP value, 146
Automatic storage management (ASM), 13
cell security
ASM-scoped security, 487, 489, 490
best practices, 489
cellkey.ora file, 488
database-scoped security, 487, 490–492
removing cell security, 493, 494
security key, 488
storage realm, 488
configuration options, 485
default policy, 474
Exadata disk architecture, 467, 468
fault resiliency, 467
grid disks
CellCLI command, 471
creation, 478
/dev/sda3 partition, 481
Exadata reports, 471
FlashDisk-based grid disks, 483, 484
I/O space allocation, 482
key attributes, 477
Linux O/S partitions, 472
list celldisk command, 481
naming, 478
non-Exadata system, 471
physical disks and flash cache modules, 471
RECO disk groups, 479, 480, 483
SATA disks, 482
SYSTEM_DG disk group, 479
I/O performance rating
default allocation policy, 475
interleaving policy, 477
isolating storage cell access, 485, 486
storage virtualization, 467, 468, 473
Avg Celldisk Reads (MB), 402
Avg Celldisk Small Read Latency (msec) chart, 402
B
Backup and restore strategy
block change tracking file, 455
full backup and restore, 452, 453
incremental backup, 454
Balanced DW/BI system, 529
Basic compression method, 68
Block change tracking (BCT), 295
Bulletins and Blogs
Expert Oracle Exadata Blog, 546
Kerry Osborne's Oracle Blog, 546
Tanel Poder's Blog, 546
C
CELLBOOT USB flash drive, 288
CellCLI, 535
assign key command, 492
cell alerts
alert severities, 282
cell disk read/write errors, 282
cell temperature, 282
Clear severity, 282
examinedBy attribute, 283
LIST METRICHISTORY DETAIL command, 282
software failures, 282
cell metrics
DESCRIBE METRICCURRENT command, 280
DESCRIBE METRICHISTORY command, 282
I/O metric abbreviations, 281
LIST METRICCURRENT command, 280
LIST METRICDEFINITION command, 279
LIST METRICHISTORY command, 282
metric name prefixes, 280
cell services
ALTER CELL command, 542
LIST CELL DETAIL command, 541
shut down and restart cell services, 541
shut down cell services, 540
start up cell services, 541
-e option, 540
flashcachecontent detail, 537
help interface, 536
keywords, 535
storage cell, configuring and managing, 540
Cell disk failure
disk repair timer, 304
disk replacement, 310
grid disks, removal, 303
LIST GRIDDISK command, 306
poor performance, 312
predictive failure, 311
SCRATCH_DG, 303
cellkey.ora files, 488, 489, 491, 493
Cell Offload Efficiency ratio, 387
checkip.sh script (CheckIP), 258
Client access network, 237, 238
Compression Advisor, 91
Compute node
considerations
CPU resources, 497
I/O performance and capacity, 498
memory resources, 498
patching and testing, 498
Exadata clusters
full-rack configuration, 508
leaf switch ports, 507
network configuration, 508
non-RAC configuration
architecture, 500
grid disks, 502
production cluster, 507
RAC clusters
cellip.ora file, 505
full rack configuration, 505
grace failover, 504
high availability, 504
resource allocation, 505
scalability, 504
UAT database, 507
Consumer groups
APPS, 178
high-priority business applications, 177
mapping rules
login attributes, 179
ORACLE_USER, 180
REPORTS, 181
runtime attributes, 179
session-to-consumer-group, 179, 180
OTHER_GROUPS, 178
SQL statement/query, 178
SYS_GROUP, 178
Cost Based Optimizer (CBO), 204
CPU-intensive processing, 523
create griddisk command, 478
D
Database backup, 293
backup architecture, 293
disk-based backups, 293
RMAN
block change tracking, 295
incremental backups, 295
wait events, 296
standby database, 294
tape-based backups, 293
Database File System (DBFS), 428
Database Machine configuration, 237
ApplyConfig, 261
CheckIP, 258
configuration process, 240
configuration worksheet, 242
Exadata configuration parameters, 242
network settings, 249
Oracle environment parameters, 247
DBM Configurator, 253
Firstboot process, 260
network components
client access network, 238
management network, 237
private network, 239
staging, 263
storage cell configuration, 272
upgrades, 268
upgrading Exadata
creating new RAC cluster, 268
upgrading the existing cluster, 270
upload parameters and deployment files, 254
Database Resource Manager (DBRM), 163
ad-hoc queries, 198
components, 177
consumer groups (see Consumer groups)
DBA_HIST_RSRC_CONSUMER_GROUP, 185
DBA_HIST_RSRC_PLAN, 185
DBA_RSRC_CATEGORIES, 184
DBA_RSRC_CONSUMER_GROUP_PRIVS, 184
DBA_RSRC_CONSUMER_GROUPS, 184
DBA_RSRC_GROUP_MAPPINGS, 184
DBA_RSRC_IO_CALIBRATE, 184
DBA_RSRC_MAPPING_PRIORITY, 184
DBA_RSRC_PLAN_DIRECTIVES, 184
DBA_RSRC_PLANS, 184
DBA_USERS, 185
IORM, 176
OLTP applications, 198
plan directives (see Plan directives)
resource plans (see Resource plan)
storage cells, 176
Unix renice command, 175
V$RSRC_CONSUMER_GROUP, 184
V$RSRC_PLAN, 184
V$RSRC_PLAN_HISTORY, 184
V$RSRC_SESSION_INFO, 184
V$SESSION, 184
wait event: resmgr: cpu quantum, 185
Database Smart Flash Cache (DBFC), 125
Database template (dbmDBTemplate), 258
Database Writer (DBWR), 19
DATA_CD_00_cell03 grid disks, 492
DATA_CD_01_cell03 grid disks, 492
Data migration strategy, 420
init.ora parameters, 464
logical migration (see Logical migration)
physical migration (see Physical migration)
VLDB migration downtime, 465
Data Pump
database migrating parameters
compression, 423
FLASHBACK_SCN, 424
FLASHBACK_TIME, 424
FULL, SCHEMAS, TABLES, 424
NETWORK_LINK, 424
PARALLEL parameter, 424
REMAP_DATAFILE, 425
REMAP_SCHEMA, 425
REMAP_TABLESPACE, 425
SCHEMAS, 425
SQLFILE, 425
TABLE_EXISTS_ACTION, 425
TABLES, 425
TRANSFORM, 425
expdp command, 422
impdp command, 423
lab configuration, 423
Oracle Advanced Compression, 427
usage time, 427
Data recovery
diagnostic tool (see Diagnostic tools)
database backup (see Database backup)
system backup (see System backup)
system recovery (see System recovery)
Data warehouse (DW)
appliance, 5
database, 420
systems, 528
DBM Configurator, 241
configuration process, 254
data-entry fields, 253
Exadata upgrade, 268
DBMS_SQLTUNE.REPORT_SQL_MONITOR package, 391, 392
db_recovery_file_dest database, 480
all_group, 544
cell_group, 544
dbs_group, 543
pmon processes, 543
SSH equivalency, 543
DECODE function, 524
Default allocation policy, 474, 475
Deploy112, 266
command-line options process, 267
DBM Configurator, 267
installation procedure, 267
Diagnostics and Tuning Pack licenses, 393
Diagnostic scripts, 547
as.sql, 547
calibrate_io.sql, 547
check_px.sql, 547
comp_ratio.sql, 547
create_display_raw.sql, 547
dba_tables.sql, 547
desc.sql, 547
display_raw.sql, 548
dplan.sql, 548
dump_block.sql, 548
esfc_hit_ratio.sql, 548
esfc_keep_tables.sql, 548
flush_pool.sql, 548
flush_sql.sql, 548
fs.sql, 548
fsx.sql, 548
fsxo.sql, 548
gather_table_stats.sql, 548
get_compression_ratio.sql, 549
get_compression_type.sql, 549
mystats.sql, 549
obj_by_hex.sql, 549
offload_percent.sql, 549
parmsd.sql, 549
parms.sql, 549
part_size2.sql, 549
pool_mem.sql, 549
queued_sql.sql, 549
report_sql_monitor.sql, 549
si.sql, 549
snapper.sql, 550
ss_off.sql, 550
ss_on.sql, 550
table_size.sql, 550
valid_events.sql, 550
whoami.sql, 550
Diagnostic tools
CellCLI (see CellCLI)
Healthcheck
ASM health check, 279
O/S health check, 279
Sun Diagnostics (see sundiag.sh output)
Disk-based backups, 293
Disk drive front panel, 307
DISKMON, 19
Disk status, 311
Disk tracks, 474
DW/BI workloads, 524
DW-oriented workloads
chained rows
IO_SAVED_% calculation, 522
pass-through mode, 518
query with offloading vs. without offloading, 520, 521
tkrprof, 520
compression, 528
data-flow dynamics, 511
EFSC, 526
ESFC, 528
hinted code, 526
indexes, 526
partitioning, 528
row-at-a-time processing, 526
Smart Scans, 511
coding techniques, 516
direct path read mechanism, 514
EXPLAIN PLAN type tool, 514
fsxo.sql script, 516
long-running statements, 514
offload_percent.sql script, 515, 516
online code repository, 515
optimizer, 514
very busy cells, 522
WHERE clauses
custom-written PL/SQL functions, 516
offloadable function, 517
storage indexes, 518
Dynamic performance counters
cell blockage
MinSCN optimization, 358
cell blocks processing
cache layer, 359
data layer, 360
index layer, 360
txn layer, 360
cell commit cache queries, 361
cell flash cache, 361
cell I/O uncompressed bytes, 362
cell index scans, 362
cell num fast response sessions, 362
switch to smart scan session, 363
using passthru mode, 364
cell physical I/O bytes
excessive CPU on cell, 365
interconnect bytes, 368
optimized file creation, 367
optimized RMAN file restore, 367
predicate offload, 365
sent directly to DB node to balance CPU usage, 367
storage index, 367
cell scans, 368
cell smart I/O session
cache hits, 369
cache lookups, 369
cell transactions in commit cache, 369
chained rows
processed by cell, 369
rejected by cell, 371
skipped by cell, 371
meaning and explanation, 354
Oracle counters, 351
Oracle Session Snapper, 352
physical read requests optimized, 372
physical read total bytes optimized, 373
PX slave sessions, 354
Statspack/AWR reports, 351
table fetch continued row, 373
table scans
direct read, 373
long tables, 373
troubleshooting performance, 351
E
Ejected disk drive, 307
Energy storage module (ESM), 126
Exadata, 1
architecture
ASM, 20
DBRM vs. IORM, 20
DISKMON, 19
LIBCELL, 20
RDS protocol, 20
System Global Area, 19
bits and pieces, 12
cell security, 488
consolidation platform, 6
database layer, 3
database machine
X2-2, 7
X2-8, 8
disks, 12
DW appliance, 5
flash cache, 12
hardware components, 9
history, 3
OLTP machine, 6
operating systems, 11
software components
database servers, 12
storage server, 16
storage cells, 487
storage layer, 3
storage servers, 11
X2-2 database servers, 11
X2-8 database servers, 11
Exadata configuration parameters, 242
backup method
external to Exadata, 245
internal to Exadata, 245
database machine name, 244
disk type, 245
Smart Flash Cache, 247
type of system, 244
workload type, 245
Exadata database machine, 523
X2-2, 7
X2-8, 8
Exadata Hybrid Columnar Compression (EHCC), 65, 420
Exadata Smart Flash Cache (ESFC), 512, 513
DBFC, 125
flash cache creation, 132, 133
flash disk, 127
hardware, 125
monitoring
database layer, 139
usage control, 134
Exadata V2, 487
Expert Oracle Exadata Blog, 546
Export and Import method
BUFFER parameter, 427
COMPRESSION, 426
direct-path load inserts, 427
HCC compression, 426
IGNORE parameter, 426
INDEXFILE parameter, 426
Oracle Advanced Compression, 427
parallelizing process, 426
REMAP_SCHEMA, 426
Transparent Data Encryption, 426
usage time, 427
External USB drive, recovery image
imageinfo command, 289
make_cellboot_usb command, 289
software installation
in-partition patches, 291
out-of-partition upgrades, 291
Extract, transform, and load (ETL) process, 233, 234
F
Fast recovery area (FRA), 293
Firstboot process, 260
First-in, first-out (FIFO), 206
Flash Cache, 483
Flash grid disks, 514
Flash recovery area (FRA), 480
Function shipping architecture, 13
G
11gR2 parallel features, 144
H
HCC, 528
HTML file, 392
Human resources (HR) database, 490, 492, 493
Hybrid Columnar Compression
challenges
disabling serial direct path reads, 101
locking issues, 101
moving data to a non-Exadata platform, 100
single row access, 102
compression ratios
Compression Advisor, 91
custom application data, 95
financial data, 97
real world applications, 99
retail sales data, 98
telecom call detail data, 96
compression types
ARCHIVE HIGH, 70
ARCHIVE LOW, 69
QUERY HIGH, 69
QUERY LOW, 69
compression units (CUs), 72
DML performance, 83
ILM strategies, 102
load performance, 73
query performance, 78
I, J
Index fast full scan (IFFS), 327
Index-Organized Table (IOT) segment, 349
Index trickery, 529
InfiniBand private network, 248
In-memory Parallel Execution
cluster-aware feature, 166
fsx.sql script output, 172
memory access, 166
parameter pertinent information, 167–170
In-memory parallel query, 523
Instance caging
configuring and testing
burn_cpu.sh script, 200
DEFAULT_PLAN resource allocation, 200
OTHER_GROUPS resource group, 200
RESOURCE_PLAN database parameter, 199
SCRATCH and SNIFF databases, 200, 201, 203
CPU affinity, 199
foreground and background processes, 198
LGWR, 199
multitenant database environments, 199
over-provisioning, 204
PMON, 199
Integrated Lights Out Manager (ILOM), 238
Intelligent Database protocol (iDB), 13, 204
Interleaving allocation policy, 476
I/O payload, 523
I/O Resource Manager (IORM), 176, 402, 534
APPS_CATEGORY and BATCH_CATEGORY, 211, 216
background processes, 224
cellsrv issues, 206
configuring category
CellCLI command list, 213
DBA_RSRC_CONSUMER_GROUPS view, 213
dbPlan field, 214
OTHER_GROUPS consumer group, 213, 217
REPORTS and MAINTENANCE resource groups, 212
storage cells, 211
FIFO, 206
iDB, 204
interdatabase
configuring interdatabase, 210, 211
highest-priority database, 210
I/O priorities, 205
I/O request, 205
storage cell and grid, 209
intradatabase
calculations, 219
configuring intradatabase, 214, 215
I/O allocation, 205
metrics
CellCLI command, 221
METRICCURRENT object, 220
METRICHISTORYDAYS attribute, 221
METRICHISTORY object, 221
SCRATCH and SNIFF databases, 219
storage cells, 219
workload management (see Workload management)
monitoring, 219
OLTP applications, 211
plan testing
activate resource manager, 227
cellsrv, 226
dump metrics to file, 228, 229
SCRATCH and SNIFF databases, 226
start load test, 227
resource allocation, 216
Rman, 234
utilization, 207
workload optimization
Auto, 209
Balanced, 208
DSS/OLTP workload, 208
high_throughput, 208
iormplan objective command, 209
low_latency, 208
small and large I/O requests, 208
IORM. See I/O Resource Manager (IORM)
I/O's per second (IOPS), 487
IPConf, 261
K
Kerry Osborne's Oracle Blog, 546
Keyboard, video, and mouse (KVM), 238
L
Limited parallel degree policy, 146
Linux operating system, 468, 481
Logical migration
data copying over database link, 427
APPEND hint, 429
CTAS usage, 442
Exadata Ethernet and InfiniBand ports, 429, 430
INSERT SELECT command, 428, 429
Oracle Net (SQL*Net), 428
parallelizing data load (see Parallelizing data load)
software configuration settings, 431
table copying, 442
TCP buffer sizes, 431, 433–435
extract and load method, 422
advantage, 422
Data Pump (see Data Pump)
Export and Import method
(see Export and Import method)
platform differences
database merging, 421
extent sizing, 421
HCC, 421
replication-based method (see Replication-Based migration)
selective migration, 421
staged migration, 421
Log Writer (LGWR) process, 19, 199
M
Management network, 237
ILOM, 238
KVM, 238
Management Server (MS), 16
Manual parallel degree policy, 146
Minimum Active SCN optimization, 358
Mixed workloads, 511
hints, 533
index, 529
optimizer
index-oriented plans, 530
scan-based plans, 530
storage platform, 530
Resource Manager, 533
system statistics, 530
MOS support notes, 545
My Oracle Support (MOS) note 888828.1, 262, 545
N
Network settings, 249
cell alert notification parameters, 252
channel bonding (NET1), 251
client access network (NET1), 251
management network (NET0), 251
Non-Oracle databases, 450
Normal redundancy, 479
O
OCR and voting file storage, 479, 480
Offloading optimizations, 323
OLTP-oriented workloads
flash cache, 511
latency issues, 511
scalability, 513
write-intensive OLTP workloads, 513
On-disk indexing technology, 529
checkip.sh script, 258
configuration steps, 264
database template, 258
My Oracle Support (MOS) note 888828.1, 263
network settings, 249
simplified and structured mechanism, 263
standardized configurations, 263
Online transaction processing (OLTP)
compression method
characteristics, 69
indirect path loads, 83
database, 420
machine, 6
Oracle
compression mechanisms
BASIC compression, 68
HCC compression, 69
OLTP compression, 68
database, 529
data storage
block format, 65
PCTFREE, 67
row format, 66
row migration, 67
environment parameters, 247
Oracle Clusterware, 237
Oracle 10gR1, 467
Oracle 10gR2, 394
Oracle Session Snapper, 346, 352
P, Q
PARALLEL_CLUSTER_CACHE_POLICY parameter, 147
PARALLEL_DEGREE_POLICY, 146
Parallelizing data load, 435
fully parallel network data transfer, 438, 440, 441
Parallel operations
auto DOP (see Automatic degree of parallelism)
parallel queuing functionality
CPU utilization, 152
mixed workload, 152
Oracle's parallel capabilities, 152
parallel adaptive multiuser, 153
PARALLEL_SERVERS_TARGET, 153, 155
storage layer, 145
Parallel queuing functionality
controlling mechanism
NO_STATEMENT_QUEUING hint, 161–163
Oracle's Database Resource Manager (DBRM), 163–165
PARALLEL_SERVERS_TARGET parameter, 157
PARALLEL_STATEMENT_QUEUING parameter, 158–161
STATEMENT_QUEUING hint, 161
CPU utilization, 152
mixed workload, 152
Oracle, 152
parallel adaptive multiuser, 153
PARALLEL_SERVERS_TARGET, 153, 155, 157
Passthrough, 366
Payroll (PAY) database, 490, 492, 493
PCTFREE
block free space control, 67
purposes, 67
row migration, 67
Performance metrics, 345
dynamic performance counters, 350
internals, 345
Oracle Session Snapper, 346
Smart Scan
metrics and performance counters, 350
performance, 346
V$SESSTAT, 346
Physical migration
backup and restore strategy
block change tracking file, 455
full backup and restore, 452, 453
incremental backup, 454
physical standby strategy, 458, 460
post-migration tasks, 463
source database version, 452
TTS (see Transportable tablespaces)
Plan directives
CREATE_PLAN_DIRECTIVE procedure, 177
management attributes, 182
Private network, 239
Process monitor (PMON), 199
R
Real-time SQL monitoring. See also SQL monitoring
DBMS_SQLTUNE, 391
execution plan rowsource
activity monitoring, 388
activity timeline, 389
Oracle execution plans, 389
PX RECEIVE rowsource, 389
table access and sorting, 390
manual query, 390
Recovery manager (Rman), 234
Redo Apply, 443
Reliable Datagram Sockets (RDS) protocol, 13
Replication-based migration
logical replication, 443
Oracle Streams and Golden Gate, 443–447
parallel load, 450
physical replication, 443
consolidation, 175
DBRM (see Database Resource Manager)
instance caging (see Instance caging)
IORM (see I/O Resource Manager)
Resource plans
activation, 189
after-hours plan, 183
consumer group mapping rules, 186, 187
myplan, 177
NIGHTTIME plan, 188
pending area, 183
and plan directives, 187
resource group mapping priorities, 187
resource groups creation, 185
RESOURCE_MANAGER_PLAN instance parameter, 177
testing
activate resource manager, 194
check consumer group assignments, 193, 194
check DBRM metrics, 195, 196, 198
DAYTIME resource plan allocation, 190
deactivate DBRM, 191
examine session trace file, 194, 195
execute a query, 194
log in as RJOHNSON, 191
10046 session trace, 193
start load test, 192
V$RSRC_CONSUMER_GROUP view, 190
Restart Server (RS), 16
runtime attributes, 179
S
SCRATCH_DG, 302
SKEW3
HCC load times vs. compression ratios, 75
statistics gathering timing, 79
unqualified query timing, 82
Smart Scan, 387
metrics and performance counters, 350
CPU usage, 350
multiblock reads, 350
single block reads, 350
performance, 346
bitmap index segments, 346, 348
B*Tree index segments, 346, 348
column projection, 347
filtration, 347
full segment scans, 347
index fast full scan, 349
Index-Organised Table (IOT) segment, 349
materialized view segments, 348
storage() predicate, 347
Spine switch, 8
SQL monitoring, 379
control, 392
database time, 382
duration vs. CPU time, 381, 382
Enterprise Manager performance
Grid Control, 381
SQL executions, 381
features, 380
parallel query, 383
real-time monitoring, single long running query
bind variable values, 384
Cell Offload Efficiency ratio, 387
Monitored SQL Execution Details, 383
Time and Wait Statistics, 386
V$SQL and V$SQLSTATS, 393
SQL statement's performance metrics
Exadata-specific performance statistics, 374
V$SQL columns and meanings, 374
Storage cell layer monitoring
cell metrics assessment
cell layer, cellCLI, 395
CPU utilization, 406
grid control Exadata Storage Server, 396
Oracle, 405
I/O metrics, iostat
disk service time, 408
I/O response time, 407
I/O waiting (queueing time), 409
Linux iostat, 409
LSI disks, 410
lsscsi command, 410
Oracle (cellsrv), 408
SAN storage network, 407
small I/O request, 407
synchronous and asynchronous I/O, 406
OS Watcher
archive files output, 412
benefits, 411
bzipped file, 413
cellsrvstat command, 413
collected data storage, 412
iostat archive, 417
little script, 414
logfiles, 414
log file write latency problem, 416
My Oracle Support version, 417
name search, 411
output sorting, 416
Perl text processing, 415
post-processing, 416
pstree command, 411
Storage cells configuration, 272
Storage Indexes
_CELL_STORIDX_MODE parameter, 112
__KCFIS_STORAGEIDX_DIAG_MODE parameter, 112
_kcfis_storageidx_disabled parameter, 111
bind variables, 113
cellinit.ora Storage Index parameters, 112
encryption, 114
features and syntax, prevention, 114
HCC, 113
joins, 113
at least one predicate, 113
limitations, 114
monitoring
database statistics, 107
tracing mechanism, 108
wrap up, 111
multi-column predicates, 113
null optimization, 116
operators, 113
parallel query, 113
partitioned objects, 114
performance benefits, 114
potential issues
incompatible coding techniques, 122
incorrect results, 119
moving targets, 119
partition size, 122
Smart Scan, 113
structure, 105
sub-query, 114
Storage network configuration, 486
Stripe and mirror everything (SAME) methodology, 468
sundiag.sh output
dmesg, 276
fdisk-l, 276
log files
alert.log, 278
alerthistory, 278
cell-detail, 277
celldisk-detail, 277
fdom-l, 278
flashcache-detail, 278
griddisk-detail, 278
lun-detail, 277
ms-odl.log, 278
ms-odl.trc, 278
physicaldisk-detail, 277
physicaldisk-fail, 277
lspci, 276
lsscsi, 276
megacli64, 276
messages, 276
sel-list, 276
Sun F20 PCIe Flash Card, 127
System backup
database server, 284
LVM snapshots, 285
storage cell, 287
CELLBOOT USB flash drive, 288
external USB drive, 289
System I/O class
cell smart incremental backup
cell hash number, 335
Incremental Level 0 backup, 334
Incremental Level 1 backup, 334
RMAN command, 334
10046 trace file, 334
cell smart restore from backup
cell hash number, 336
file initialization, 335
RMAN restores, 335
miscellaneous System I/O class events, 334
System recovery, 296
database servers, 296
LVM snapshot-based backup, 296
reimaging, 298
storage cell, 299
disk failure (see Cell disk failure)
flash cache failure, 313
permanent cell failure, 316
system volume failure, 300, 301
temporary cell failure, 313
validation framework, 301
T
Tanel Poder's Blog, 546
Tape-based backups, 293
Temporary cell failure, 314
Transportable tablespaces (TTS)
cross platform TTS, 456
endian format conversion, 457
restrictions, 455
TRANSPORT_FULL_CHECK parameter, 457
U
Unbreakable Enterprise Kernel (UEK), 11
User I/O class
cell list of blocks physical read event, 331, 332
cell multiblock physical read event, 330, 331
cell single block physical read event
active production system, 329
cell hash number, 330
disk-based storage systems, 329
disk hash number, 330
flash cache, 329
histogram, 329
index access paths, 328
cell smart file creation, 332, 333
cell smart index scan event
aggressiveness, 326
cell hash number, 328
fast full index scans, 326
object ID, 328
serial_direct_read=TRUE, 327
cell smart table scan event, 323
allocation units, 323
cell hash number, 325
Full Table Scans, 323
InfiniBand network, 323
object ID, 325
cell statistics gather, 333
multi-block read mechanisms, 323
User I/O class (cont.)
physical I/O events, 323
single-block read mechanisms, 323
V
V$SQL and V$SQLSTATS views, 393
W, X, Y, Z
Wait events
cell smart incremental backups, 296
cell smart restore from backups, 296
discrete operating system calls, 319
11gR2 code, 319
old events
direct path read, 338
enq:KO-fast object checkpoint, 339
reliable message, 340
Oracle database, 319
resource manager events
resmgr:cpu quantum event, 341, 342
resmgr:pq queued event, 342, 343
V$EVENT_NAME, 341
steps planning, trigger events, 321, 323
System I/O class (see System I/O class)
User I/O class. (see User I/O class)
v$event_name, 319
Workload management
CG_FC_IO_RQ_LG, 222
CG_FD_IO_RQ_LG, 222
CG_IO_RQ_LG, 222
consumer_type attribute, 222
device_type attribute, 222
DSS workload, 221
METRICCURRENT and METRICHISTORY objects, 224
metricObjectName attribute, 223
name attribute of IORM METRICCURRENT, 223
OLTP workload, 221
storage cells, 221