解释Hanganalyze报告中的SQL ID Oracle

发布于 2025-02-10 04:55:38 字数 450 浏览 1 评论 0原文

我正在使用Oracle数据库19C。我需要帮助了解HangaNalyze Trace中的当前 sql_id 字段。通常， sql_id 具有诸如 bhi12gxhrpqsj 之类的字母数值值，以识别特定的SQL语句。但是在这里，有10个数字值。任何帮助将不胜感激。

提前致谢！

oradebug hanganalyse痕迹输出：

    time in wait: 1 min 20 sec
   timeout after: never
         wait id: 2335
        blocking: 1 session
  current sql_id: 3597362520 <<======
    wait history:

原文

I am using oracle database 19c. I need help in understanding the current sql_id field in the hanganalyze trace. Generally sql_id has alphanumeric values like bhi12gxhrpqsj to identify a particular sql statement. But here, there is 10 digit numeric value. Any help will be appreciated.

Thanks in advance !

Oradebug hanganalyze trace output:

    time in wait: 1 min 20 sec
   timeout after: never
         wait id: 2335
        blocking: 1 session
  current sql_id: 3597362520 <<======
    wait history:

分享到QQ

分享到微博