MIME-Version: 1.0
From: yudhi s <learnerdatabase99@gmail.com>
Date: Fri, 3 Mar 2023 17:18:06 +0530
Message-ID: <CAEzWdqd-kK4Z3XokcxDxjy_aSD8V=4fu=Fz=yRuapK3wZ3sbww@mail.gmail.com>
Subject: Dash_wait_chain script resulting into ORA-01489
To: Oracle L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="00000000000077dde205f5fd85f4"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: learnerdatabase99@gmail.com
--00000000000077dde205f5fd85f4
Content-Type: text/plain; charset="UTF-8"

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

--00000000000077dde205f5fd85f4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hello Listers,=C2=A0<div dir=3D"auto"><br></div><div dir=
=3D"auto">While trying to run Tanels below script for investigating one of =
the issue I am seeing error &quot;ORA-01489: result of string concatenation=
 is too long&quot;. The issue was basically the database almost come to fre=
eze for about ~1minute duration. So anybody saw this error while running th=
e dash_wait_chain script?<div dir=3D"auto"><br></div><div dir=3D"auto"><a h=
ref=3D"https://github.com/tanelpoder/tpt-oracle/blob/master/ash/dash_wait_c=
hains.sql">https://github.com/tanelpoder/tpt-oracle/blob/master/ash/dash_wa=
it_chains.sql</a></div><div dir=3D"auto"><br></div><div dir=3D"auto">Is it =
because we have too many blocking session coming and below part of the scri=
pt is throwing that error? How can i handle this error?</div><div dir=3D"au=
to"><br></div><div dir=3D"auto">,substr(REPLACE(SYS_CONNECT_BY_PATH(/*&amp;=
1*/ program2||event2, &#39;-&gt;&#39;), &#39;-&gt;&#39;, &#39; -&gt; &#39;)=
||CASE WHEN CONNECT_BY_ISLEAF =3D 1 AND d.blocking_session IS NOT NULL THEN=
 &#39; -&gt; [idle blocker &#39;||d.blocking_inst_id||&#39;,&#39;||d.blocki=
ng_session||&#39;,&#39;||d.blocking_session_serial#||(SELECT &#39; (&#39;||=
s.program||&#39;)&#39; FROM gv$session s WHERE (s.inst_id, s.sid , s.serial=
#) =3D ((d.blocking_inst_id,d.blocking_session,d.blocking_session_serial#))=
)||&#39;]&#39; ELSE NULL END  , 1,3999) path</div><div dir=3D"auto"><br></d=
iv><div dir=3D"auto">[Error] Execution (64: 296): ORA-01489: result of stri=
ng concatenation is too long</div><div dir=3D"auto"><br></div></div></div>

--00000000000077dde205f5fd85f4--
--
http://www.freelists.org/webpage/oracle-l