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博客 ” ，链接：https://blog.itpub.net/70034820/viewspace-2994136/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 中国OCM联盟隆重落户ITPUB社区，百位OCM已入驻，欢迎更多的OCM加入我们哦！
- OCMU联盟-一个有温度的联盟
- 丢掉盔甲，我们依然是骄傲的骑士——Secooler“三问四看”话认证培训
- 【数据安全】一次惊心动魄的ASM磁盘头损坏故障处理过程带来的深思
- 【参数】恢复db_recovery_file_dest_size参数为默认值“0”方法
- 【如何做快乐的DBA】ITPUB社区第一期博客专家专题“如何做快乐的DBA”
- 【Bitmap Index】B-Tree索引与Bitmap位图索引的锁代价比较研究
- 【RMAN】使用RMAN的Duplicate功能创建物理DataGuard报错（ORA-17627、ORA-17629）处理
- 【CUBE】Oracle分组函数之CUBE魅力
- 【ROLLUP】Oracle分组函数之ROLLUP魅力
