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
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
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
gcs_server_processes parameter, 16
Global Cache Service, 16
Grid
features, 2–3
Grid Control, 215, 227
grouped table outer joins, 208–209
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