C D

Page 234

baselines, 230

in the workload repository, 46

bigfile tablespaces (BFTs), 35, 88

altering, 136

benefits of, 134–135

creating, 136

data dictionary views, 137

database defaults, 135–136

defined, 134

dropping, 136

and extended ROWIDs, 137–138

migrating to, 136–137

size and backup concerns, 135

using DDL on, 135–136

block change tracking, 87–89

buffer cache, flushing, 23

bulk binds

exception handling, 164

processing sparse collections, 162–164

C

Calendar Expressions, 32

case-insensitive searching, 172–173

catalog command, 85–86

checkpointing, self-tuned, 62

Cluster Ready Services, 15

See also Real Application Clusters

Common Management Infrastructure (CMI)

architecture overview, 43–44

Automatic Workload Repository, 44–50

server-based advisors, 50–59

server-generated alerts, 59–61

compacting segments, 37–38

compatible parameter, 5

connect by clause, 209–210

connect string format, 187–188

context_sensitive policy, 69

cross-platform transportable tablespaces, 138–139

converting tablespace endian format with RMAN, 140–141

datafile byte ordering, 139–140

CRS. See Cluster Ready Services

CTWR, 232

D

data dictionary statistics, 19–21

data dictionary views

and Automatic Storage Management, 12–13

bigfile tablespaces, 137

Flashback Drop, 98

Oracle Data Pump, 118

standby databases, 112

tablespace group, 35

and valid_for attribute, 106

Workspace Manager, 196

Data Guard, 103

applying redo in real time, 104–105

ARCH process writes to standby redo logs, 108

assigning threads to standby redo log groups, 108

logical standby databases, 109–112

redo transmission, 107

standby database parameters, 107–108

standby database startups, 108

valid_for attribute, 105–106

Data Pump. See Oracle Data Pump

Data Pump Export utility, 120

examples, 126–127

interactive mode commands, 125

new features, 120–121

parameters, 122–125

preparing to use, 121–122

quirks, 125–126

See also Data Pump Import utility; Oracle Data Pump

Data Pump Import utility, 128

examples, 133–134

interactive mode commands, 132

new features, 128

parameters, 129–133

See also Data Pump Export utility; Oracle Data Pump

database backup commands, 76–77

Database Configuration Assistant, 6, 15–16

creating an ASM instance, 11

and OEM Database Control, 214

Database Resource Manager

job scheduling, 221