[20251027]建立完善s2h.sql脚本.txt

--//增加kgl_bucket的计算。

$ cat s2h.sql
-- Copyright 2023 lfree. All rights reserved.
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms and conditions.
----------------------------------------------------------------------------------------------
--
-- Name:        s2h.sql
-- Purpose:     display Sql_id of Hash_value
--
-- Author:      lfree
-- Usage:
--     @ s2h <sql_id>
--
-----------------------------------------------------------------------------------------------
column sql_id format a13
column hash_value format 9999999999

SELECT '&1' sql_id
      ,DBMS_UTILITY.SQLID_TO_SQLHASH ('&1') hash_value
      ,MOD (DBMS_UTILITY.SQLID_TO_SQLHASH ('&1'), 131072) kgl_bucket
FROM DUAL;

SCOTT@book01p> @ sql_id 318q0cyx1n9s3

-- SQL_ID = 318q0cyx1n9s3 come from shared pool

Select /*+ a */ count(*) from t1 where id = :"SYS_B_0";

SCOTT@book01p> @ s2h 318q0cyx1n9s3

SQL_ID         HASH_VALUE KGL_BUCKET
------------- ----------- ----------
318q0cyx1n9s3 3122276099       9987

ITPub博客

[20251027]建立完善s2h.sql脚本.txt

最新文章