Oracle OCP 1Z0-053 Q632(Standard Block Size )
632.Note the following parameter settings: Which setting is NOT allowed?
A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;
B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
Answer: B
驗證:
SQL> show parameter db
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
clonedb boolean FALSE
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TYPICAL
db_block_size integer 8192
db_cache_advice string ON
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_cache_size big integer 0
db_create_file_dest string
SQL> ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
System altered.
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00380: cannot specify db_8k_cache_size since 8K is the standard block size
因8K是標準的block size,所以引數db_8k_cache_size不能被修改
A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;
B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
Answer: B
驗證:
SQL> show parameter db
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
clonedb boolean FALSE
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TYPICAL
db_block_size integer 8192
db_cache_advice string ON
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_cache_size big integer 0
db_create_file_dest string
SQL> ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
System altered.
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-00380: cannot specify db_8k_cache_size since 8K is the standard block size
因8K是標準的block size,所以引數db_8k_cache_size不能被修改
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2072243/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle Log Block SizeOracleBloC
- DB_BLOCK_SIZE and DB_CACHE_SIZE in OracleBloCOracle
- oracle的塊 db_block_sizeOracleBloC
- Oracle OCP 1Z0-053 Q115(ASM variable extent size support)OracleASM
- Oracle10g 五種不同的block sizeOracleBloC
- Oracle OCP 1Z0-053 (ASM)OracleASM
- ORA-27046: file size is not a multiple of logical block sizeBloC
- oracle block_size 為非標準塊的時候OracleBloC
- DB_BLOCK_SIZE Initialization Parameter (92)BloC
- Oracle OCP 1Z0-053 (System Partitioning)Oracle
- Oracle OCP 1Z0-053 Q445Oracle
- error:unable to get logical block size for spfileErrorBloC
- Initianization Parameter (1) : DB_BLOCK_SIZEBloC
- Oracle 11G OCP 1Z0-053 600Oracle
- Oracle 11G OCP 1Z0-053 581Oracle
- Oracle 11G OCP 1Z0-053 582Oracle
- Oracle 11G OCP 1Z0-053 583Oracle
- Oracle 11G OCP 1Z0-053 584Oracle
- Oracle 11G OCP 1Z0-053 585Oracle
- Oracle 11G OCP 1Z0-053 586Oracle
- Oracle 11G OCP 1Z0-053 587Oracle
- Oracle 11G OCP 1Z0-053 588Oracle
- Oracle 11G OCP 1Z0-053 589Oracle
- Oracle 11G OCP 1Z0-053 590Oracle
- Oracle 11G OCP 1Z0-053 591Oracle
- Oracle 11G OCP 1Z0-053 592Oracle
- Oracle 11G OCP 1Z0-053 593Oracle
- Oracle 11G OCP 1Z0-053 594Oracle
- Oracle 11G OCP 1Z0-053 595Oracle
- Oracle 11G OCP 1Z0-053 596Oracle
- Oracle 11G OCP 1Z0-053 597Oracle
- Oracle 11G OCP 1Z0-053 598Oracle
- Oracle 11G OCP 1Z0-053 563Oracle
- Oracle 11G OCP 1Z0-053 564Oracle
- Oracle 11G OCP 1Z0-053 565Oracle
- Oracle 11G OCP 1Z0-053 566Oracle
- Oracle 11G OCP 1Z0-053 567Oracle
- Oracle 11G OCP 1Z0-053 568Oracle