SELECT db_param.NAME,
db_param.VALUE,
db_db.db_unique_name,
db_db.database_role
FROM v$parameter db_param,
v$database db_db
WHERE db_param.NAME IN ( 'db_file_name_convert',
'db_name',
'db_unique_name',
'fal_client',
'fal_server',
'local_listener',
'log_archive_config',
'log_archive_dest_1',
'log_archive_dest_2',
'log_archive_dest_3',
'log_archive_dest_state_1',
'log_archive_dest_state_2',
'log_archive_dest_state_3',
'log_file_name_convert',
'standby_archive_dest',
'standby_file_management',
'remote_login_passwordfile',
'log_archive_format'
)
ORDER BY db_param.NAME;