V$SQLSTATS.SQL_FULLTEXT does not show full of sql statements

(Doc ID 2398100.1)

Last updated on MAY 13, 2018

Applies to:

Oracle Database - Standard Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

V$SQLSTATS.SQL_FULLTEXT does not show the full of sql statements which is longer than 1,000 bytes.

V$SQL and V$SQLAREA can show the full of sql statements without any problems.

ex)

SQL> select length(sql_fulltext) from V$SQLSTATS where sql_id = '0194nncjtmxs1';

LENGTH(SQL_FULLTEXT)
--------------------
                1000

SQL> select length(sql_fulltext),sql_text from V$SQL where sql_id = '0194nncjtmxs1';

LENGTH(SQL_FULLTEXT)
--------------------
SQL_TEXT
--------------------------------------------------------------------------------
                2962
/* SQL Analyze(1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t)
dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monito
ring xmlindex_sel_idx_tbl opt_param('optimizer_inmemory_aware' 'false') no_subst
:

SQL> select length(sql_fulltext) from V$SQLAREA where sql_id = '0194nncjtmxs1';

LENGTH(SQL_FULLTEXT)
--------------------
                2962

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms