ORACLE – Alle Parameter aus dem spfile

Aug 21, 2017
—
von
SET LINESIZE 150
COLUMN name FORMAT A60
COLUMN value FORMAT A90

SELECT    name, value
FROM      v$spparameter
WHERE     value          IS NOT NULL
ORDER BY  name           ASC;

audit_file_dest              /dod/app/oracle/admin/dod/adump
audit_trail                  NONE
compatible                   12.1.0.2.0
control_files                /db01/oradata1/db01/control01.ctl
control_files                /db01/oralog1/db01/control02.ctl
control_files                /db01/oralog2/db01/control03.ctl
db_block_size                8192
db_domain                    example.com
db_name                      db01
db_unique_name               DB01_TEST
diagnostic_dest              /db01/app/oracle
dispatchers                  (PROTOCOL=TCP) (SERVICE=db01XDB)
local_listener               (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=REGISTER)))
log_archive_dest_1           LOCATION=/db01/oraarch1/dod/
log_archive_format           db01_%t_%s_%r.arc
max_dump_file_size           1G
memory_target                6627000320
open_cursors                 300
processes                    300
remote_login_passwordfile    EXCLUSIVE
service_names                DB01
undo_tablespace              UNDOTBS1

22 rows selected.