为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:Centos7
【CPU】:Intel X86
【问题描述】*:DM有没有 描述当前用户可访问的存储对象上的当前错误的系统表(类似ORACLE的ALL_ERRORS),能定位到哪个OWNER,name的
回答 0
暂无回答
Tianrx
可以查看动态性能视图V$RUNTIME_ERR_HISTORY
SELECT SESS_ID AS “会话ID”,TRX_ID AS “事务ID”,DECODE(SU_FLAG,‘U’,‘用户异常’,‘S’,‘系统异常’,‘P’,‘语法异常’) AS “错误类型”,SQL_TEXT AS “错误的SQL”,ECPT_CODE AS “错误提示”,ERR_TIME AS “产生时间” FROM V$RUNTIME_ERR_HISTORY;
可以查看动态性能视图V$RUNTIME_ERR_HISTORY
SELECT SESS_ID AS “会话ID”,TRX_ID AS “事务ID”,DECODE(SU_FLAG,‘U’,‘用户异常’,‘S’,‘系统异常’,‘P’,‘语法异常’) AS “错误类型”,SQL_TEXT AS “错误的SQL”,ECPT_CODE AS “错误提示”,ERR_TIME AS “产生时间” FROM V$RUNTIME_ERR_HISTORY;
详细信息可以查看DM8系统管理员手册