Index

A B C D E F G H I M N O P Q R S T U V W

A

adding

mapping operators, 5.4

analytic capabilities, 7.1

analytic SQL, 7.1

ARCHIVELOG mode

as a best practice, 11.2.1

attribute properties, setting, 5.7

attributes

connecting, 5.6.3

level attributes, 4.4.1.2

setting properties, 5.7

auto binding rules, 4.4.2.2

B

backup, 11.1

backup and recovery, 11.1

best practices, 11.2

best practices

ARCHIVELOG mode, 11.2.1

backup and recovery, 11.2

NOLOGGING, 11.2.4

read-only tablespaces, 11.2.3

RMAN, 11.2.2

tablespace differences, 11.2.5

binding

auto binding, rules, 4.4.2.2

B-tree index, 10.2.3

C

calculating moving averages, 7.1.8

calculating relative contributions, 7.1.6

column statistics, 10.1.1

common tasks

in data warehouses, 1.2.2

COMPATIBLE parameter, 2.3.3

COMPRESS clause, 10.2.4.2

compression, 10.2.4

compression advisor interface, 10.2.4.1

connecting

attributes, 5.6.3

groups, 5.6.2

operators, 5.6

CPUs, 2.2.1.1

Create External Table Wizard, 4.3.1

creating

mappings, 5

CUBE function, 7.1.2

cubes, 4.5

dimensionality, 4.5.1.2

example, 4.5.1.3

measures, 4.5.1.1

relational implementation, 4.5.2.1

D

data compression, 9.3.1

data warehouses

common tasks, 1.2.2

key characteristics of, 1.2.1

setting up, 2.2, 2.3

tools, 1.4

data warehousing security, 12

DB_BLOCK_SIZE parameter, 2.3.3

DB_FILE_MULTIBLOCK_READ_COUNT parameter, 2.3.3

DBMS_COMPRESSION package, 10.2.4.1

DBMS_STATS package, 10.1.1

dd utility, 2.2.2.1

defining

mappings, 5

degree of parallelism (DOP), 10.3.1.2

densification, 7.2

dimensions

dimension roles, 4.4.1.4

example, 4.4.1.6

hierarchies, 4.4.1.3

implementing, 4.4.2

level attributes, 4.4.1.2

level relationships, 4.4.1.5

star schema implementation, 4.4.2.1

disks

needed, 2.2.1.3

E

explain plan

analyzing, 10.1.2

EXPLAIN PLAN statement, 10.1.2

explain plans, 10.1.2

external tables

creating a new definition, 4.3.1

defined, 4.3.1

wizard for creating, 4.3.1

F

fine-grained auditing

in data warehouses, 12.5

flat files

G

group properties, 5.7

GROUPING function, 7.1.3

GROUPING SETS function, 7.1.4

groups

connecting, 5.6.2

setting properties, 5.7

H

hardware configuration, 2.2.1

verifying, 2.2.2

hierarchies

about, 4.4.1.3

hints, 10.1.3

I

implementing

relational cubes, 4.5.2.1

star schema, 4.4.2.1

index statistics, 10.1.1

indexes

bitmap, 10.2.3

optimizing, 9.2

optimizing with SQL Access Advisor, 9.2

initialization parameters

setting, 2.3.3

interrow calculations

performing, 7.1.7

I/O, 2.2.1.4, 9.1.1.2

monitoring, 9.1.1.2

M

mapping operators

about, 5.1

adding, 5.4

connecting, 5.6

editing, 5.5

synchronizing with Repository objects, 5.8

types of, 5.3.1

mapping operators, setting, 5.7

mappings

about, 5.1

creating, 5

defining, 5

materialized views, 10.2.2

memory, 2.2.1.2

memory management

parameters, 2.3.1

memory needed, 2.2.1.2

MERGE PARTITION operation, 9.3.1

MOVE PARTITION operation, 9.3.1

N

NOLOGGING

as a best practice, 11.2.4

O

offloading data

with rolling windows, 8.2

operator attributes, 5.6.3

operator properties

setting, 5.7

operators

connecting, 5.6

editing, 5.5

synchronizing with Repository objects, 5.8

operators, mapping, 5.1

adding, 5.4

connecting, 5.6

editing, 5.5

types of, 5.3.1

optimizer statistics, 10.1.1

OPTIMIZER_FEATURES_ENABLE parameter, 2.3.3

Oracle Label Security, 12.4

in data warehouses, 12.3

Orion utility, 2.2.2.3

P

parallel execution, 10.3.1

how it works, 10.3.1.1

parallel query, 9.1.1.1, 10.3.1

monitoring, 9.1.1.1

PARALLEL_ADAPTIVE_MULTI_USER parameter, 2.3.3

PARALLEL_MAX_SERVERS parameter, 2.3.3

parameter

COMPATIBLE, 2.3.3

DB_BLOCK_SIZE, 2.3.3

DB_FILE_MULTIBLOCK_READ_COUNT, 2.3.3

OPTIMIZER_FEATURES_ENABLED, 2.3.3

PARALLEL_ADAPTIVE_MULTI_USER, 2.3.3

PARALLEL_MAX_SERVERS, 2.3.3

QUERY_REWRITE_ENABLED, 2.3.3

QUERY_REWRITE_INTEGRITY, 2.3.3

STAR_TRANSFORMATION_ENABLED, 2.3.3

parameters

initialization, 2.3.3

memory management, 2.3.1

partition outer join, 7.2

partition pruning, 10.2.1.1

partitioning, 10.2.1

partitionwise joins, 10.2.1.2

performance

improving with compression, 10.2.4

using hints, 10.1.3

using query rewrite, 10.2.2

using SQL Access Advisor, 10.1.4

using SQL Tuning Advisor, 10.1.4

privileges

in data warehouse security, 12.2

properties

setting, 5.7

Q

query rewrite, 2.3.3, 2.3.3, 4.4, 8.1.1, 10.2.2

QUERY_REWRITE_ENABLED parameter, 2.3.3

QUERY_REWRITE_INTEGRITY parameter, 2.3.3

R

range-partitioned table, 9.3.1

RANK function, 7.1.5

read-only tablespaces

as a best practice, 11.2.3

refreshing

data warehouse, 8

resource consumption, 10.2

minimizing, 10.2

Resource Manager, 9.1.2

resource use, 10.2

rewrite

query, 2.3.3, 2.3.3

RMAN

as a best practice, 11.2.2

roles

dimension roles, 4.4.1.4

in data warehouse security, 12.2

rolling windows, 8.2

ROLLUP function, 7.1.1

S

security

data warehouse, 12

sparsity, 7.2

SPLIT PARTITION operation, 9.3.1

SQL Access Advisor, 10.1.4

evaluating partitioning, 10.2.1.3

optimizing indexes, 9.2

SQL Tuning Advisor, 10.1.4

STAR_TRANSFORMATION_ENABLED parameter, 2.3.3

statistics

optimizer, 10.1.1

storage

optimizing, 9.3

synchronizing

operators and Repository objects, 5.8

system statistics, 10.1.1

T

table statistics, 10.1.1

table_compress clause, 10.2.4.2

tables

U

UTLXPLAN.SQL script, 10.1.2

V

virtual private database

how it works, 12.3.1

in data warehouses, 12.3

W

wait events, 10.3.2

WITH clause, 7.3

wizards

Create External Table Wizard, 4.3.1