达梦数据库常见的重要巡检语句

最新推荐文章于 2025-09-28 02:20:54 发布

原创

最新推荐文章于 2025-09-28 02:20:54 发布 · 1.1k 阅读

15 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #sql

一、数据库授权信息查询

SELECT

LIC_VERSION AS "许可证版本",

SERIES_NO AS "序列号",

CHECK_CODE AS "校验码",

AUTHORIZED_CUSTOMER AS "最终用户",

PROJECT_NAME AS "项目名称",

PRODUCT_TYPE AS "产品名称",

CASE SERVER_TYPE

WHEN '1' THEN

'正式版'

WHEN '2' THEN

'测试版'

WHEN '3' THEN

'试用版'

WHEN '4' THEN

'其他'

END AS "产品类型",

TO_CHAR(EXPIRED_DATE) AS "有效日期",

OS_TYPE AS "授权系统",

TO_CHAR(AUTHORIZED_USER_NUMBER) AS "授权用户数",

NVL(TO_CHAR(CONCURRENCY_USER_NUMBER), '') AS "授权并发数",

NVL(TO_CHAR(MAX_CPU_NUM), '') AS "授权CPU个数",

CLUSTER_TYPE AS "授权集群"

FROM

V$LICENSE

1.该项需注意数据库授权的有效日期，到期前需及时进行更换。

2.授权CPU个数字段值（出现过因限制CPU使用个数导致DB性能下降）

二、查询数据库的实例信息

SELECT

'版本号',

(SELECT

id_code)

FROM

v$instance

union all

select

'数据库名',

name

from

v$database

union all

select

'实例名',

instance_name

from

v$instance

union all

select

'系统状态',

status$

from

v$instance

union all

select

'实例模式',

mode$

from

v$instance

union all

select

'是否启用归档',

case arch_mode

when 'Y' then

'是'

when 'N' then

'否'

end

from

v$database

union all

SELECT

'页大小',

cast(PAGE() / 1024 as varchar)

union all

SELECT

'大小写敏感',

cast(

case SF_GET_CASE_SENSITIVE_FLAG()

when '1' then

'是'

when '0' then

'否'

end 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(

case SF_GET_LENGTH_IN_CHAR()

when '1' then

最低0.47元/天解锁文章