ocp-043 DB_CREATE_FILE_DEST
来源:互联网 发布:肇庆网络问政 编辑:程序博客网 时间:2024/05/12 06:52
A50
You are managing an Oracle Database 10g database that uses Oracle Managed Files (OMF). You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true?
A. One block change tracking file is created for each data file. By default, the file is created in DB_CREATE_FILE_DEST.
B. One block change tracking file is created for each data file. By default, the file is created in BACKGROUND_DUMP_DEST.
C. One block change tracking file is created for the database. By default, the file is created in DB_CREATE_FILE_DEST.
D. One block change tracking file is created for the database. By default, the file is created in BACKGROUND_DUMP_DEST.
Answer: C
block change tracking
A database option that causes Oracle to track datafile blocks affected by each database update. The tracking information is stored in a new type of file called the change tracking file. When block change tracking is enabled, RMAN uses the record of changed blocks from the change tracking file to improve incremental backup performance by only reading those blocks known to have changed, instead of reading datafiles in their entirety.
Setting the DB_CREATE_FILE_DEST Initialization Parameter
Include the DB_CREATE_FILE_DEST
initialization parameter in your initialization parameter file to identify the default location for the database server to create:
Datafiles
Tempfiles
Redo log files
Control files
Block change tracking files
You specify the name of a file system directory that becomes the default location for the creation of the operating system files for these entities. The following example sets /u01/oradata
as the default directory to use when creating Oracle-managed files:
DB_CREATE_FILE_DEST = '/u01/oradata'
DB_CREATE_FILE_DEST
DB_CREATE_FILE_DEST =
directory
|
disk group
Default valueThere is no default value.ModifiableALTER SESSION
, ALTER SYSTEM
BasicYes- ocp-043 DB_CREATE_FILE_DEST
- db_create_file_dest
- DB_CREATE_FILE_DEST,DB_CREATE_ONLINE_LOG_DEST_
- DB_CREATE_FILE_DEST参数
- 设置DB_CREATE_FILE_DEST初始化参数
- ocp-043
- ocp 认证 043
- OCP-043 RMAN BLOCKRECOVER
- OCP-043 SQL Tuning
- OCP-043 ASM_DISKSTRING
- OCP-043 drop diskgroup
- OCP-043 DB_nK_CACHE_SIZE
- OCP-043 large pool
- OCP-043 automatic PGA
- OCP-043session_longops
- OCP-043 Pending Area
- OCP-043 SESSION_TRACE_DISABLE
- OCP-043 DBMS_SCHEDULER.LOGGING_RUNS
- 文件描述符 文件描述标志 文件状态标志
- nginx学习总结二(nginx的启动停止以及版本平滑升级)
- EasyUI
- 选购一款适合自己的显卡系列之1:The Right GPU for You
- java de Iphone批量推送代码
- ocp-043 DB_CREATE_FILE_DEST
- 数据库规范化三个范式应用实例
- 100个windows平台C++开发错误之四编程
- ibatis的批量处理
- 选购一款适合自己的显卡系列之2:Who Should Care About Good 3D?
- mysql快速插入大量数据
- java操作excel
- 文件编码与文件的读写与0x0D0A
- ostringstream的用法