SQL> set linesize 200
set pagesize 1000
column name format a40
column value format a60
select inst_id, name,value from gv$parameter
where name in ('db_create_file_dest',
'audit_file_dest',
'audit_trail',
'diagnostic_dest',
'standby_file_management',
'db_recovery_file_dest_size',
'db_create_online_log_dest_1',
'db_create_online_log_dest_2',
'log_archive_format',
'log_archive_dest_1')
order by name;
INST_ID NAME VALUE
---------- ---------------------------------------- ------------------------------------------------------------
1 audit_file_dest /u01/app/oracle/admin/SHESTSU/adump
2 audit_file_dest /u01/app/oracle/admin/SHESTSU/adump
2 audit_trail OS
1 audit_trail OS
2 db_create_file_dest +REG_DATA01
1 db_create_file_dest +REG_DATA01
2 db_create_online_log_dest_1 +REDOLOG01
1 db_create_online_log_dest_1 +REDOLOG01
1 db_create_online_log_dest_2 +REDOLOG02
2 db_create_online_log_dest_2 +REDOLOG02
1 db_recovery_file_dest_size 10737418240
2 db_recovery_file_dest_size 10737418240
1 diagnostic_dest /u01/app/oracle/admin
2 diagnostic_dest /u01/app/oracle/admin
1 log_archive_dest_1 LOCATION=USE_DB_RECOVERY_FILE_DEST
2 log_archive_dest_1 LOCATION=USE_DB_RECOVERY_FILE_DEST
2 log_archive_format %t_%s_%r.dbf
1 log_archive_format %t_%s_%r.dbf
2 standby_file_management MANUAL
1 standby_file_management MANUAL
20 rows selected.