set echo off feedback off heading off linesize 160 trimout on trimspool on col dt new_value dt select to_char(systimestamp,'YYYYMMDDHH24MISSFF3') dt from dual / spool McOptions_&dt..txt prompt select banner from v$version where banner like 'Oracle%' / prompt select banner_full from v$version / prompt select 'ODA_INFRASTRUCTURE -> '||sys_context('SYS_CLUSTER_PROPERTIES','ODA_INFRASTRUCTURE') from dual / prompt select 'ODA_TYPE -> '||sys_context('SYS_CLUSTER_PROPERTIES','ODA_TYPE') from dual / prompt select 'EXADATA -> '||decode(count(*), 0,'NO', 'YES') from (select distinct cell_name from gv$cell_state) / prompt set heading on select distinct name features from dba_feature_usage_statistics order by 1 / spool off