PARAMETERES

 COL con_name FOR A20

COL parameter_name FOR A40

COL value FOR A80

SELECT c.name con_name,

       p.name parameter_name,

       p.value

FROM   v$parameter p,

       v$containers c

WHERE  p.con_id=c.con_id

AND    p.name IN (

'db_name',

'db_unique_name',

'service_names',

'utl_file_dir',

'local_listener',

'remote_listener',

'db_create_file_dest',

'log_archive_dest_1'

)

ORDER BY c.name,p.name;