| 普通创建数据库的一些参数信息模板 |
| Use this template to create a customized database. |
Common Options
OptionSelected
| Oracle JVM | true |
| Oracle Data Mining | true |
| Oracle Text | true |
| Oracle XML DB | true |
| Oracle Intermedia | true |
| Oracle OLAP | true |
| Oracle Spatial | true |
| Oracle Ultra Search | false |
| Oracle Label Security | false |
| Sample Schemas | false |
| Enterprise Manager Repository | true |
初始化参数
| audit_file_dest | {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump |
| background_dump_dest | {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/bdump |
| compatible | 10.2.0.2.0 |
| control_files | ("{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl", "{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control02.ctl", "{ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control03.ctl") |
| core_dump_dest | {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/cdump |
| db_block_size | 8KB |
| db_file_multiblock_read_count | 16 |
| db_recovery_file_dest | {ORACLE_BASE}/flash_recovery_area |
| db_recovery_file_dest_size | 2048MB |
| dispatchers | (PROTOCOL=TCP) (SERVICE={SID}XDB) |
| job_queue_processes | 10 |
| open_cursors | 300 |
| pga_aggregate_target | 24MB |
| processes | 150 |
| remote_login_passwordfile | EXCLUSIVE |
| sga_target | 140MB |
| undo_management | AUTO |
| undo_tablespace | UNDOTBS1 |
| user_dump_dest | {ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/udump |
字符集设置
| Database Character Set | WE8ISO8859P1 |
| National Character Set | AL16UTF16 |
控制文件
| {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control01.ctl |
| {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control02.ctl |
| {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/control03.ctl |
表空间
| SYSAUX | PERMANENT | LOCAL |
| SYSTEM | PERMANENT | LOCAL |
| TEMP | TEMPORARY | LOCAL |
| UNDOTBS1 | PERMANENT , UNDO | LOCAL |
| USERS | PERMANENT | LOCAL |
数据文件（M）
| {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/sysaux01.dbf | SYSAUX | 120 |
| {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/system01.dbf | SYSTEM | 300 |
| {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/temp01.dbf | TEMP | 20 |
| {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/undotbs01.dbf | UNDOTBS1 | 200 |
| {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/users01.dbf | USERS | 5 |
Redo日志组（K）
| 1 | 51200 |
| 2 | 51200 |
| 3 | 51200 |
