Page 239
sorted hash clusters, 63–65
sorting, case-and accent-insensitive, 172–173
SQL
data type enhancements, 206
LOBs and the before row insert trigger, 206
modeling, 207
moving data from BFILEs to a LOB, 206
regular expressions, 164–172
removal of statement length limitations, 209
returning clause, 206, 207–208
SQL Access Advisor, 58
SQL Apply, 110–111
bypassing to make changes to logical standby databases, 112
skipping a failed transaction, 112
SQL Tuning Advisor, 55–58
SQL*Plus
compatibility command, 205
copy command, 205
describe command, 202
new define variables, 204
pagesize default, 205
profile files, 203
run-time variable substitution, 204–205
show recyclebin command, 205
spool command, 203
using Flashback Database from, 94–95
whitespace in file-and pathnames, 205
sql_trace, 6
standby databases, 75–76
logical, 109–112
parameters, 107–108
startups, 108
static policy, 69, 70
statistics collection
automated, 18–19
base statistics, 48
data dictionary, 19–21
DBMS_STATS behaviors, 21–22
fixed table statistics, 20–21
high-water mark statistics, 49
planning strategy for, 22
table-monitoring behaviors, 23
usage metrics, 48–49
Streams. See Oracle Streams
SYSAUX tablespace, 6–8, 71
managing occupants of, 8–9
renaming, 36
SYSTEM tablespace, 71
renaming, 36
table functions, enhancements, 187
table-monitoring behaviors, 23
tablespace groups, 33–34
assigning temporary tablespaces to, 34
data dictionary view, 35
defining as the default temporary tablespace, 34–35
tablespace point-in-time recovery, 91
tablespaces
bigfile, 35, 88, 134–138
cross-platform transportable, 138–141
defining the tablespace of a nested table, 177–178
renaming, 36
SYSAUX, 6–9, 36, 71
SYSTEM, 36, 71
temporary, 33–35
user-configurable default tablespaces, 33
testing, sql_trace, 6
tkprof, 66
Top Sessions, 227
Top SQL Assessment, 227–228
trace functionality, 62–63
transaction recovery, monitoring, 102–103
trcsess utility, 62, 66
TSPITR changes, 91
uncatalog command, 85–86
undo retention
automatic, 37
guaranteed, 100–101
update indexes command, 159–160
upgrading
compatible parameter, 5
DBUA, 4
manual upgrades, 4–5