ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 【视图】通过v$spparameter视图查看spfile内容

【视图】通过v$spparameter视图查看spfile内容

原创 Linux操作系统 作者:secooler 时间:2009-03-03 16:58:09 0 删除 编辑

1.10g环境中的输出

sys@ora10g> select sid,name,value from v$spparameter where value is not null;

SID        NAME                             VALUE
---------- -------------------------------- -----------------------------
*          processes                        500
*          sga_target                       167772160
*          control_files                    /oracle/u02/oradata/ORA10G/controlfile/o1_mf_4srph8fv_.ctl
*          control_files                    /oracle/u01/app/oracle/flash_recovery_area/ORA10G/controlfile/o1_mf_4srph96b_.ctl
*          db_block_size                    8192
*          compatible                       10.2.0.3.0
*          log_archive_format               %t_%s_%r.dbf
*          db_file_multiblock_read_count    16
*          db_create_file_dest              /oracle/u02/oradata
*          db_recovery_file_dest            /oracle/u01/app/oracle/flash_recovery_area
*          db_recovery_file_dest_size       4294967296
*          undo_management                  AUTO
*          undo_tablespace                  UNDOTBS1
*          remote_login_passwordfile        EXCLUSIVE
*          job_queue_processes              10
*          background_dump_dest             /oracle/u01/app/oracle/admin/ora10g/bdump
*          user_dump_dest                   /oracle/u01/app/oracle/admin/ora10g/udump
*          core_dump_dest                   /oracle/u01/app/oracle/admin/ora10g/cdump
*          audit_file_dest                  /oracle/u01/app/oracle/admin/ora10g/adump
*          db_name                          ora10g
*          open_cursors                     300
*          pga_aggregate_target             16777216

22 rows selected.

2.11g环境中的输出
sys@ora11g> select sid,name,value from v$spparameter where value is not null;

SID        NAME                           VALUE
---------- ------------------------------ --------------------------------------------
*          processes                      500
*          memory_target                  314572800
*          control_files                  /oracle/u02/oradata/ora11g/control01.ctl
*          control_files                  /oracle/u02/oradata/ora11g/control02.ctl
*          control_files                  /oracle/u02/oradata/ora11g/control03.ctl
*          db_block_size                  8192
*          compatible                     11.1.0.0.0
*          log_archive_format             %t_%s_%r.dbf
*          db_recovery_file_dest          /oracle/u01/app/oracle/flash_recovery_area
*          db_recovery_file_dest_size     4294967296
*          undo_tablespace                UNDOTBS1
*          remote_login_passwordfile      EXCLUSIVE
*          audit_file_dest                /oracle/u01/app/oracle/admin/ora11g/adump
*          audit_trail                    db
*          db_name                        ora11g
*          open_cursors                   300
*          diagnostic_dest                /oracle/u01/app/oracle

17 rows selected.

3.10g和11g官方文档对视图v$spparameter的描述

Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02

V$SPPARAMETER

V$SPPARAMETER displays information about the contents of the server parameter file. If a server parameter file was not used to start the instance, then each row of the view will contain FALSE in the ISSPECIFIED column.

Column Datatype Description
SID VARCHAR2(80) SID for which the parameter is defined
NAME VARCHAR2(80) Name of the parameter
VALUE VARCHAR2(255) Parameter value (null if a server parameter file was not used to start the instance)
DISPLAY_VALUE VARCHAR2(255) Parameter value in a user-friendly format. For example, if the VALUE column shows the value 262144 for a big integer parameter, then the DISPLAY_VALUE column will show the value 256K.
ISSPECIFIED VARCHAR2(6) Indicates whether the parameter was specified in the server parameter file (TRUE) or not (FALSE)
ORDINAL NUMBER Position (ordinal number) of the parameter value (0 if a server parameter file was not used to start the instance). Useful only for parameters whose values are lists of strings.
UPDATE_COMMENT VARCHAR2(255) Comments associated with the most recent update (null if a server parameter file was not used to start the instance)


Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01

V$SPPARAMETER

V$SPPARAMETER displays information about the contents of the server parameter file. If a server parameter file was not used to start the instance, then each row of the view will contain FALSE in the ISSPECIFIED column.

Column Datatype Description
SID VARCHAR2(80) SID for which the parameter is defined
NAME VARCHAR2(80) Name of the parameter
TYPE VARCHAR2(11) Parameter type
VALUE VARCHAR2(255) Parameter value (null if a server parameter file was not used to start the instance)
DISPLAY_VALUE VARCHAR2(255) Parameter value in a user-friendly format. For example, if the VALUE column shows the value 262144 for a big integer parameter, then the DISPLAY_VALUE column will show the value 256K.
ISSPECIFIED VARCHAR2(6) Indicates whether the parameter was specified in the server parameter file (TRUE) or not (FALSE)
ORDINAL NUMBER Position (ordinal number) of the parameter value (0 if a server parameter file was not used to start the instance). Useful only for parameters whose values are lists of strings.
UPDATE_COMMENT VARCHAR2(255) Comments associated with the most recent update (null if a server parameter file was not used to start the instance)

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/519536/viewspace-559827/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle ACE 总监,阿里云MVP,北京大学理学硕士,恩墨学院创始人,教育专家,中国区 Cloudera 首位官方授权大数据讲师,金牌培训专家,BDA大数据联盟创始人,OCM联盟创始人,ACCUG创始人、ACOUG核心专家,Blogger。

注册时间:2008-03-16

  • 博文量
    797
  • 访问量
    8038062