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) |
