Learning is not a spectator sport

truncated ddl in 12c (and 11.2.0.4)

November 30, 2014

1–2 minutes

Just curious if anyone else is seeing this behaviour..

SQL> set long 500000
SQL> @pt "select * from v$sql where sql_id = '1km492z723vpu'"
 
SQL_TEXT                      : alter table scott.emp
SQL_FULLTEXT                  : alter table scott.emp
SQL_ID                        : 1km492z723vpu
...

Suffice to say, there’s a lot more to that SQL statement, but its lost in v$sql. Once complete, it does appear in full in v$sqlstats, but its a pain when you cant see the whole statement..

2 responses to “truncated ddl in 12c (and 11.2.0.4)”

Hemant K Chitale

November 30, 2014 at 11:30 pm

Yes, I have noticed this in 11.2.0.4

Reply
Randolf Geist

December 1, 2014 at 3:18 am

Hi Connor,

yes, very annoying bug introduced with 11.2.0.4 PSU 2 (plain vanilla 11.2.0.4 doesn’t reproduce), see:

V$SQL.SQL_FULLTEXT For Create Table Statement Is Trimmed (Doc ID 1922923.1)

I’ve come across another bug that says even with patch 19148376 installed DBA_HIST_SQLTEXT would still contain truncated content, was however closed as “not a bug”.

Bug 19610478 : AWR REPORT DOESN’T SHOW FULL SQL TEXT FOR CREATE TABLE STATEMENT

Randolf

Reply