可以通过以下sql进行查询
SELECT '页大小', cast(PAGE()/1024 as varchar)
union all
SELECT '簇大小', cast(SF_GET_EXTENT_SIZE() as varchar)
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(SF_GET_CASE_SENSITIVE_FLAG() as varchar)
union all
select
'VARCHAR类型长度是否以字符为单位',
para_value
from
v$dm_ini
where
para_name='LENGTH_IN_CHAR'
union all
select '实例名称' 数据库选项, INSTANCE_NAME 数据库集群相关参数值 FROM v$instance
union all
select '数据库名', name from v$database
union all
select '端口号', para_value from v$dm_ini where para_name='PORT_NUM'
union all
select '数据库版本', substr(svr_version, instr(svr_version, '(')) FROM v$instance
union all
select '数据库模式', MODE$ from v$instance
union all
SELECT
'字符数据类型' NAME,
CASE VALUE WHEN 0 THEN 'BYTE' WHEN 1 THEN 'CHAR' end
FROM
v$parameter
WHERE
name like '%LENGTH_IN_CHAR%'
union all
select '唯一魔数', cast(permanent_magic as varchar)
union all
select 'LSN', cast(cur_lsn as varchar) from v$rlog
union all
select 'KEY文件属性', cluster_type from v$license ;