T U

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

T

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

U

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