SELECT '实例名称' 数据库选项,INSTANCE_NAME  数据库集群相关参数值 FROM V$INSTANCE UNION ALL
SELECT '数据库版本',SUBSTR(SVR_VERSION,INSTR(SVR_VERSION,'('))  FROM V$INSTANCE UNION ALL
SELECT 'ID_CODE',ID_CODE UNION ALL
SELECT '字符集',CASE SF_GET_UNICODE_FLAG() WHEN '0' THEN 'GBK18030' WHEN '1' THEN 'UTF-8' WHEN '2' THEN 'EUC-KR' END UNION ALL
SELECT '页大小',CAST(PAGE()/1024 AS VARCHAR) UNION ALL
SELECT '簇大小',CAST(SF_GET_EXTENT_SIZE() AS VARCHAR) UNION ALL
SELECT '大小写敏感',CAST(SF_GET_CASE_SENSITIVE_FLAG() AS VARCHAR) UNION ALL
SELECT '数据库模式',MODE$ FROM V$INSTANCE  UNION ALL
SELECT '唯一魔数', TO_CHAR(DB_MAGIC) FROM V$RLOG UNION ALL
SELECT '永久魔数',CAST(PERMANENT_MAGIC AS VARCHAR) UNION ALL
SELECT 'LSN',CAST(CUR_LSN AS VARCHAR) FROM V$RLOG UNION ALL
SELECT '以字符为单位',PARA_VALUE FROM V$DM_INI WHERE PARA_NAME='LENGTH_IN_CHAR'  UNION ALL
SELECT '结尾空格填充',PARA_VALUE FROM V$DM_INI WHERE PARA_NAME='BLANK_PAD_MODE'  UNION ALL
SELECT '授权',EXPIRED_DATE||'_'||AUTHORIZED_CUSTOMER||'_'||CLUSTER_TYPE||'_'||SERVER_SERIES FROM V$LICENSE;