E F G H

Page 235

mapping automatic assignment of sessions, 25–26

reverting back to original consumer group, 24–25

setting the idle timeout, 25

Database Upgrade Assistant, 4, 15

databases, dropping, 36–37

datafile image copies, 89

DBA_ALERT_HISTORY, 61

DBA_AUDIT_TRAIL, 70

DBA_FGA_AUDIT_TRAIL, 71–72

DBA_HIST_SYSMETRIC_HISTORY, 49, 61

DBA_OUTSTANDING_ALERTS, 61

DBA_THRESHOLDS, 61

DBA_WM_SYS_PRIVS view, 200

DBCA, 6, 15–16

creating an ASM instance, 11

and OEM Database Control, 214

dbms_advisor.quick_tune procedure, 57

dbms_dimension package, 156

dbms_monitor, 62–63

dbms_mview.explain_rewrite, 152

dbms_profiler procedure, 187

DBMS_STATS behaviors, 21–22

dbms_wm package, new functionality in, 191–193

dbms_wm.export, 197

dbms_wm.getphysicaltablename, 193

dbms_wm.import, 197–198

dbms_wm.refreshworkspace, 199

dbms_wm.setsystemparameter, 191–193

DBUA, 4, 15

See also upgrading

DDL functionality, 200

directory, new features, 72

DML statements, auditing, 72

downgrading, 4

See also upgrading

drop database command, 36–37

dynamic policy, 69, 70

dynamic views, 75

E

EM2Go, 229

See also Oracle Enterprise Manager

Enhanced Partition Management, 224

Enterprise Manager. See Oracle Enterprise Manager

exception handling, 164

external tables

projecting columns in, 145–146

writing to, 143–145

F

flash recovery area, 78

file types back up within, 79

other features, 83

reasons to use, 78–80

RMAN backup and restore, 82–83

RMAN commands, 82

setting up, 80–81

views, 81

Flashback Database, 92–93

architecture, 93

limitations, 96–97

use requirements, 93

using from RMAN, 95

using from SQL*Plus, 94–95

views, 96

Flashback Drop, 97

data dictionary views, 98

flashback table to before drop command, 98–99

recycle bin, 97–98

Flashback Table, 101–102

Flashback Transaction Query, 101

Flashback Versions Query, 99–100

flushing the buffer cache, 23

G

gcs_server_processes parameter, 16

Global Cache Service, 16

Grid

features, 2–3

Grid Control, 215, 227

grouped table outer joins, 208–209

H

hash clusters, sorted, 63–65

hash-partitioned global indexes, 157–159

Heterogeneous Services, 190

high-water mark statistics, 49

histogram views, 42–43

History, 230

hyperlinks, in OEM, 230