Oracle学习 - 专用词汇摘录

ADDM: Automatic DataBase Diagnostic Monitor

ASM: Automatic Storage Management

AWR: Automatic Workload Repository

BMR: Block Media Recovery

CKPT: checkpoint 校验点

DBCA: Database Configuration Assistanct

EM: Enterprise Manager

FGA: Fine-Grained Auditing

HWM: The High-Water Mark

IOTs: index-organized tables

LGWR: Log Writer

MMAN: Memory Manager

MTTR: Mean Time to Restoration，平均恢复当前时间

OC4J: Oracle Application Server Containers for J2EE

OLTP: online transaction processing

OMF: Oracle Managed Files

OS: Operating System

RMAN: Recover Manager

RVWR: Recover Writer

SAA: SQL Access Advisor 

SCN: System Change Number

SGA: System Globle Area

SMON: System Monitor 系统监视器

SPFILE: the server parameter file

STA: SQL Tuning Advisor

 

 

flat file: 没有相对关系记录结构的文件

SGA_TARGET: 用来自动分配内存

UNDO_RETENTION: 设置单位为 "秒"

RESETLOG: 将日志文件顺序重置，这样以前的归档文件就无效了

V$PARAMETER: 显示当前有效参数值