Windows 操作系统(不管32bit还是64bit)是不支持oracle db的 db_32k_cache_size参数的。

如下:

F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue May 19 09:03:23 2015

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

09:03:27 sys@FS> show parameter inst

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

active_instance_count integer

cluster_database_instances integer 1

instance_groups string

instance_name string fs

instance_number integer 0

instance_type string RDBMS

open_links_per_instance integer 4

parallel_instance_group string

parallel_server_instances integer 1

09:03:31 sys@FS> show parameter 32k

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_32k_cache_size big integer 0

09:03:37 sys@FS> alter system set db_32k_cache_size=10m;

alter system set db_32k_cache_size=10m

*

ERROR at line 1:

ORA-32017: failure in updating SPFILE

ORA-00382: 32768 not a valid block size, valid range [..]

Elapsed: 00:00:00.09

09:03:48 sys@FS> create tablespace tbs32K

16:43:28 2 datafile 'c:\tbs32K.dbf' size 4M

16:43:28 3 blocksize 32k;

create tablespace tbs32K

*

ERROR at line 1:

ORA-00382: 32768 not a valid block size, valid range [2048..16384]

Elapsed: 00:00:00.40

16:43:30 sys@FS>

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐