truncated ddl in 12c (and 11.2.0.4)

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 thoughts on “truncated ddl in 12c (and 11.2.0.4)

  1. 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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s