SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql_text in dba_hist_sqltext is cut after 4000 bytes

meravkeDec 2 2019 — edited Dec 4 2019

Hi,

Oracle version being used is 12.2.0.1.

I suddenly see cases where the sql_text in dba_hist_sqltext is cut after 4000 bytes, instead of holding the complete text of the statement being executed.

(i.e select dbms_lob.getlength(sql_text) from dba_hist_sqltext return 4000 bytes ).

I saw this happening for SELECT statements.

Any idea what can cause this phenomenon and how to overcome it?

Thanks,

Merav

Added on Dec 2 2019

8 comments

2,918 views