4.4 sqlplus..........................................................................................................................29
4.4.1 命令行参数 ...................................................................................................................29
4.4.2 提示符命令 ...................................................................................................................29
4.4.3 SET 选项 ........................................................................................................................30
4.4.4 例子................................................................................................................................30
5
备份及恢复
...........................................................................................................32
5.1 export 与 import 方式.............................................................................................32
5.2 冷备份............................................................................................................................32
5.3 联机全备份+日志备份.............................................................................................32
5.3.1 设置................................................................................................................................32
5.3.2 步骤................................................................................................................................33
5.3.3 恢复................................................................................................................................33
5.4 注意要点 ......................................................................................................................34
6
数据库优化
...........................................................................................................35
6.1 通用设置 .......................................................................................................................35
6.1.1 硬件配置 .......................................................................................................................35
6.1.2 应用配置 .......................................................................................................................35
6.1.3 日常性能监控...............................................................................................................36
6.2 实战分析 ......................................................................................................................36
6.2.1 总体分析 .......................................................................................................................37
6.2.2 详细分析 .......................................................................................................................37
6.3 专题分析 .......................................................................................................................39
6.3.1 巨表查询 .......................................................................................................................39
6.3.2 对比测试 .......................................................................................................................41
6.3.3 上下载数据 ...................................................................................................................44
6.3.4 回滚空间快照陈旧（snapshot too old）.............................................................46
7
常用技巧
...............................................................................................................48
7.1 增加、更改和删除域 ................................................................................................48
7.2 删除冗余记录 ..............................................................................................................49
7.3 更改字符集...................................................................................................................49
7.4 表数据迁移...................................................................................................................50
7.5 成批生成数据 ..............................................................................................................50
7.6 注意要点 .......................................................................................................................51
8
嵌入式
SQL
（
C
）
...............................................................................................53
8.1 编译 ................................................................................................................................53
8.2 SQL 语句.......................................................................................................................54
8.2.1 内部类型与宿主类型对应 ..........................................................................................54
