oracle帮助文档——DB Reference

DB_SECUREFILE： 

有两个分区的LOB列，ASSM分区的表空间的LOB视为securefile LOB，而另一个没有ASSM的被视为basicfile LOB，前者由于后者。

参数： NEVER-以前的也会异常；PERMITTED-允许创建的；ALWAYS-为所有的创建；IGNORE-忽略强制创建basic导致的错误

/3 Initialization Parameters

3.1 Changing Parameter Values in a Parameter File

OCI_RESULT_CACHE_MAX_SIZE：覆盖CLIENT_RESULT_CACHE_SIZE

OPTIMIZER_USE_PENDING_STATISTICS:optimizer在compiling SQL statements时，是否pending statistics

DB_BLOCK_CHECKING： { FALSE只检查system块 | OFF | LOW在updata和insert的块头 | MEDIUM不对索引 | TRUE | FULL }

NLS_SORT: 指定了collating sequence for character value，如果是BINARY，则会比较快，但没有意义

                                                                                       如果是linguistic，则会比较有意义

DB_ULTRA_SAFE：数据库严苛安全参数？？对参数的进行保护{ OFF | DATA_ONLY块检查为中等 | DATA_AND_INDEX块检查为全部 }

MEMORY_TARGET： 默认zero. After startup, 你可以dynamically change MEMORY_TARGET to a nonzero value, provided that it does not exceed the value of MEMORY_MAX_TARGET.

NLS_COMP： 指定session的排序规则，values={ BINARY | LINGUISTIC | ANSI }   排序？？

SEC_PROTOCOL_ERROR_FURTHER_ACTION：服务器进程从恶意客户端接收到不良数据包 CONTINUE；(DELAY,integer)；(DROP,integer)

/8 Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to XS_SESSION_ROLES

DBA_TEMP_FREE_SPACE   ALLOCATED_SPACE

/9 Dynamic Performance (V$) Views: V$ACCESS to V$HVMASTER_INFO

V$ASM_OPERATION：state（wait | run | reap | halt | errs） pwer()

V$BACKUP:  有status

ColumnDatatypeDescriptionFILE#NUMBERFile identifierSTATUSVARCHAR2(18)File status: NOT ACTIVE, ACTIVE (backup in progress), OFFLINE NORMAL, or description of an error.
NOT ACTIVE indicates that the file is not currently in backup mode (that is, an ALTER TABLESPACE ... BEGIN BACKUP or ALTER DATABASE BEGIN BACKUP statement has not been issued), whereas ACTIVE indicates that the file is currently in backup mode.CHANGE#NUMBERSystem change number when backup startedTIMEDATETime the backup started

/12 Logical Storage Structures

12.2 Overview of Data Blocks

12.2.4 Space Management in Data Blocks

PCTFREE:保留为现有行更新的可用空间的数据块的最小百分比。

DB_SECUREFILE： 

有两个分区的LOB列，ASSM分区的表空间的LOB视为securefile LOB，而另一个没有ASSM的被视为basicfile LOB，前者由于后者。

参数： NEVER-以前的也会异常；PERMITTED-允许创建的；ALWAYS-为所有的创建；IGNORE-忽略强制创建basic导致的错误

/3 Initialization Parameters

3.1 Changing Parameter Values in a Parameter File

OCI_RESULT_CACHE_MAX_SIZE：覆盖CLIENT_RESULT_CACHE_SIZE

OPTIMIZER_USE_PENDING_STATISTICS:optimizer在compiling SQL statements时，是否pending statistics

DB_BLOCK_CHECKING： { FALSE只检查system块 | OFF | LOW在updata和insert的块头 | MEDIUM不对索引 | TRUE | FULL }

NLS_SORT: 指定了collating sequence for character value，如果是BINARY，则会比较快，但没有意义

                                                                                       如果是linguistic，则会比较有意义

DB_ULTRA_SAFE：数据库严苛安全参数？？对参数的进行保护{ OFF | DATA_ONLY块检查为中等 | DATA_AND_INDEX块检查为全部 }

MEMORY_TARGET： 默认zero. After startup, 你可以dynamically change MEMORY_TARGET to a nonzero value, provided that it does not exceed the value of MEMORY_MAX_TARGET.

NLS_COMP： 指定session的排序规则，values={ BINARY | LINGUISTIC | ANSI }   排序？？

SEC_PROTOCOL_ERROR_FURTHER_ACTION：服务器进程从恶意客户端接收到不良数据包 CONTINUE；(DELAY,integer)；(DROP,integer)

/8 Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to XS_SESSION_ROLES

DBA_TEMP_FREE_SPACE   ALLOCATED_SPACE

/9 Dynamic Performance (V$) Views: V$ACCESS to V$HVMASTER_INFO

V$ASM_OPERATION：state（wait | run | reap | halt | errs） pwer()

V$BACKUP:  有status

ColumnDatatypeDescriptionFILE#NUMBERFile identifierSTATUSVARCHAR2(18)File status: NOT ACTIVE, ACTIVE (backup in progress), OFFLINE NORMAL, or description of an error.
NOT ACTIVE indicates that the file is not currently in backup mode (that is, an ALTER TABLESPACE ... BEGIN BACKUP or ALTER DATABASE BEGIN BACKUP statement has not been issued), whereas ACTIVE indicates that the file is currently in backup mode.CHANGE#NUMBERSystem change number when backup startedTIMEDATETime the backup started

/12 Logical Storage Structures

12.2 Overview of Data Blocks

12.2.4 Space Management in Data Blocks

PCTFREE:保留为现有行更新的可用空间的数据块的最小百分比。