The Windows operating system (whether 32bit or 64bit) is not supported by the Db_32k_cache_size parameter for Oracle DB.
As follows:
F:\oracle\product\10.2.0\db_1\bin>sqlplus/as sysdbasql*plus:release 10.2.0.4.0-production on Tue 19 09:03:23 2 015Copyright (c) 1982, Oracle. All rights reserved.connected to:oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit productionwith the part Itioning, OLAP, Data Mining and Real application testing options09:03:27 [email protected]> Show parameter Instnam E TYPE VALUE--------------------------------------------------------------------- --------active_instance_count integercluster_database_instances Integer 1instance_groups Stringinstance_name string Fsinstance_number Integer 0instance_type string Rdbmsopen_links_per_instance integer 4parallel_instanc E_group stringparallel_server_instances integer 109:03:31 [email protected]> Show parameter 32kNAME TYPE VALUE-------------------------------------------- ---------------------------------db_32k_cache_size big integer 009:03:37 [email protected]> al ter system set Db_32k_cache_size=10m;alter system set Db_32k_cache_size=10m*error at line 1:ora-32017:failure in updating spfileora-00382:32768 not a valid block size, valid range [...] elapsed:00:00:00.0909:03:48 [email protected]> Create tablespace tbs32k16:43:28 2 datafile ' c:\tbs32K.dbf ' siz E 4m16:43:28 3 blocksize 32k;create tablespace tbs32k*error at line 1:ora-00382:32768 not a valid block size, valid RA nge [2048..16384]elapsed:00:00:00.4016:43:30 [email protected]>
The Windows operating system (whether 32bit or 64bit) is not supported by the Db_32k_cache_size parameter for Oracle DB.