Dash_wait_chain script resulting into ORA-01489
Date: Fri, 3 Mar 2023 17:18:06 +0530
Message-ID: <CAEzWdqd-kK4Z3XokcxDxjy_aSD8V=4fu=Fz=yRuapK3wZ3sbww_at_mail.gmail.com>
Hello Listers,
While trying to run Tanels below script for investigating one of the issue I am seeing error "ORA-01489: result of string concatenation is too long". The issue was basically the database almost come to freeze for about ~1minute duration. So anybody saw this error while running the dash_wait_chain script?
https://github.com/tanelpoder/tpt-oracle/blob/master/ash/dash_wait_chains.sql
Is it because we have too many blocking session coming and below part of the script is throwing that error? How can i handle this error?
,substr(REPLACE(SYS_CONNECT_BY_PATH(/*&1*/ program2||event2, '->'), '->', '
-> ')||CASE WHEN CONNECT_BY_ISLEAF = 1 AND d.blocking_session IS NOT NULL
THEN ' -> [idle blocker
'||d.blocking_inst_id||','||d.blocking_session||','||d.blocking_session_serial#||(SELECT
' ('||s.program||')' FROM gv$session s WHERE (s.inst_id, s.sid , s.serial#)
=
((d.blocking_inst_id,d.blocking_session,d.blocking_session_serial#)))||']'
ELSE NULL END , 1,3999) path
[Error] Execution (64: 296): ORA-01489: result of string concatenation is
too long-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 03 2023 - 12:48:06 CET