oracle 13 adj,初始化参数-LOG_PARALLELISM

C:\Documents and Settings\gqgai>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.6.0 - Production on Sun Feb 13 09:53:34 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.6.0 - Production

09:55:54 SQL> show parameter log_p

NAME TYPE VALUE

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

log_parallelism integer 1

09:56:22 SQL>

以上是Oracle9iR2中的参数设置。

在Oracle0g中，log_parallelism参数变为隐含参数，并且Oracle引入了另外两个参数，允许log_parallelism进行动态调整。

缺省的_log_parallelism_dynamic参数被设置为True，如果_log_parallelism_max被设置为不同于_log_parallelism的参数值，那么Oracle会动态的选择并行度，当然不超过最大允许值，这是Oracle10g中动态SGA的另外一个提高。

SQL> @d:\script\gethiddenpar

Enter value for par: log_parallelism

old 14: x.ksppinm like '%_&par%'

new 14: x.ksppinm like '%_log_parallelism%'

NAME VALUE ISDEFAULT ISMOD ISADJ

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

_log_parallelism 1 TRUE FALSE FALSE

_log_parallelism_dynamic TRUE TRUE FALSE FALSE

_log_parallelism_max 1 TRUE FALSE FALSE

SQL> select * from v$version;

BANNER

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

Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Prod

PL/SQL Release 10.1.0.3.0 - Production

CORE 10.1.0.3.0 Production

TNS for 32-bit Windows: Version 10.1.0.3.0 - Production

NLSRTL Version 10.1.0.3.0 - Production

获得隐含参数的脚本，请参考如何获得Oracle的隐含参数

并行度显然和CPU数量有关，

SYS AS SYSDBA on 15-MAR-05 >show parameter cpu_count

NAME TYPE VALUE

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

cpu_count integer 4

SYS AS SYSDBA on 15-MAR-05 >@gethiddenpar

Enter value for par: log_par

old 14: x.ksppinm like '%_&par%'

new 14: x.ksppinm like '%_log_par%'

NAME VALUE ISDEFAULT ISMOD ISADJ

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

_log_parallelism 1 TRUE FALSE FALSE

_log_parallelism_dynamic TRUE TRUE FALSE FALSE

_log_parallelism_max 2 TRUE FALSE FALSE

关于这些内容，目前Oracle还没有文档说明。

历史上的今天...

>>

2011-02-13文章:

2010-02-13文章:

2009-02-13文章:

2008-02-13文章:

2007-02-13文章:

2006-02-13文章: