为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:linux docker x86
【CPU】: 32核
【问题描述】*:
查询语句:
SELECT s2.OWNER AS "SCHEMA",s2.SEGMENT_NAME AS TABLE_NAME,SUM(NVL(s2.BYTES, 0))/1024 AS DATA_SIZE
FROM DBA_SEGMENTS s2
WHERE s2.OWNER = 'D_CONS002' AND s2.SEGMENT_NAME IN ('ORACLE_DEFAULT0','T1','ORACLE_DEFAULT') GROUP BY s2.OWNER,s2.SEGMENT_NAME
偶现报错问题:
0 (EP[0] sess:0x7f4f20132228 thrd:753 user:TEST trxid:0 stmt:0x7f4f20156228 appname: ip:::ffff:192.168.4.76) [ERR(-4563)]: SELECT s2.OWNER AS "SCHEMA",s2.SEGMENT_NAME AS TABLE_NAME,SUM(NVL(s2.BYTES, 0))/1024 AS DATA_SIZE
FROM DBA_SEGMENTS s2
WHERE s2.OWNER = 'D_CONS002' AND s2.SEGMENT_NAME IN ('ORACLE_DEFAULT0','T1','ORACLE_DEFAULT') GROUP BY s2.OWNER,s2.SEGMENT_NAME EXECTIME: 92(ms) ROWCOUNT: 0(rows).
2024-03-11 15:39:09.775 (EP[0] sess:0x7f4f28132228 thrd:751 user:TEST trxid:0 stmt:0x7f4f28156228 appname: ip:::ffff:192.168.4.76) [ORA]: DROP TABLESPACE IF EXISTS tsp_i02
2024-03-11 15:39:09.775 (EP[0] sess:0x7f4f28132228 thrd:751 user:TEST trxid:9092 stmt:NULL appname:) TRX: START
请求大佬看一下是什么原因导致,或者有什么规避手段,谢谢
你好呀,数据目录下的dm.ini文件、dminit日期.log文件,以及报错时间段的数据库日志可以提供一下吗? 可以发送到邮箱 zxx@dameng.com
另外还想了解一下每次报错的时候查询条件都是一样的吗,还是有不一样的,或者上面这个报错的查询条件有没有正常查出来过的?