RAID technology, 92
Range partitioning, 77–79
defined, 77
in EASYDW schema, 77–79
illustrated, 78
partition keys, 86–88
See also Partitioning
RANK() function, 110, 112, 124
Ranking functions, 110–15
CUME_DIST(), 113
defined, 109, 110
examples, 118, 119, 120
NTITLE(), 114–15
PERCENT_RANK(), 113
RANK(), 110, 112
WIDTH_BUCKET(), 115
See also SQL functions
RATIO_TO_REPORT function, 119–20
Real application clusters (RAC), 16–17
buffer cache sharing, 134
defined, 134
technology, 133–34
Real-time data warehouses, 17–18
Recommendations, 198–200
graph, 198
implementing, 199–200
materialized views, 202
view/modify, 199
See also Summary Advisor
Recovery
configuration, 363
disaster, 365–68
log, 364
Recovery catalog, 356–57
creating, 357
database placement, 357
database registration with, 359
illustrated, 357
Recovery Manager (RMAN), 329, 344
back contents, 360
backups, 356
Recovery Wizard, 361–63
report files needing backup, 361
running, 358
schema report, 360
Recovery Wizard, 361–63
configuration, 363
location of data files, 363
starting, 362
Refreshing, 137–38
complete, 138
defined, 137
incremental, 138
materialized view, 142–43
options, 275
with Oracle Enterprise Manager, 150–51
warehouses, 378
See also Summary tables
Refresh operation, 149–57
DBMS_MVIEW procedures, 149–51
defined, 149
fast, 152–57
of multiple materialized views, 150
ON COMMIT, 142–43
ON DEMAND, 143, 149
PCT, 155, 157
policy, 149
Relational OLAP (ROLAP)
defined, 427
MOLAP vs., 427–28
See also On-line analytical processing (OLAP)
Relations, 436
RELY clause, 45, 182
Reorganizing, 368–78
index changes, 377–78
partition maintenance, 369–77
reasons for, 368–69
REPORT command, 359, 441
Reporting aggregates, 109, 118–20
MAX, 118
RATIO_TO_REPORT, 119–20
SUM, 118, 119
See also SQL functions
Reports
changing, 325
column widths, 418
conditional, 420–21
with conditions, 328
creating, with Presentation Wizard, 461–66
creating, with Report Wizard, 413–19
customizing, 324
data source, 414
defining, 412
Discoverer Plus, 323
Discoverer Viewer, 409, 410
distributing, to Web, 410–12
dynamic, with graphs, 303
fields, selecting, 417
formats, 423
grouping levels, 416
illustrated, 419
integrated from Discoverer into Oracle 9iAS Portal, 412
layout, 418
matrix, 420
medium, selecting, 413
month-level, 326
output format, 424
run-time format, 423
scheduling, 425
selecting, 424
style, selecting, 414
Summary Advisor, 202–4
total calculations, 417
for Web, 421–25
in workbook, 318
REPORT SCHEMA command, 359
Report Wizard, 413–19
column widths specification, 418
data source selection, 414
grouping levels specification, 416
Query Builder setting, 416
report field selection, 417
reporting medium selection, 413
report style selection, 414
SQL query specification, 415
totals calculation, 417
See also Oracle 9i Reports
Repository, 280
location, 281
tablespace, 281
Repository Assistant, 280
Restoring, 361–64
concerns, 361
with Recovery Wizard, 362–64
type, selecting, 362
Resumable statements, 394–95
status, 395
suspended, 394, 395
REVOKE command, 389
Roles, 56–57
allocating, 390, 391
creating, 390
EASY_USER, 389
Rolling window operations
adding/dropping partitions to perform, 369–70
defined, 369
ROLLUP function, 102, 103–4
defined, 102, 103
groupings determination, 14
output comparison, 104
with supported aggregates, 103
See also SQL functions
Rule-based optimizer, 94–95