37.Oracle杂记——Oracle常用动态视图v$sqltext_with_newlines

37.Oracle杂记——Oracle常用动态视图v$sqltext_with_newlines

视图v$sqltext_with_newlines和V$SQLTEXT一样，只是为了提高易读性，

视图sqltext_with_newlines没有用空格替换SQL语句中的新行和制表符。

视图描述如下：

sys@PDB1> desc v$sqltext_with_newlines;

 Name                                                                  Null?    Type

 ------------------------------------------------------------- ------------------------------------

 ADDRESS                                                                         RAW(8)

 HASH_VALUE                                                                 NUMBER

 SQL_ID                                                                 VARCHAR2(13)

 COMMAND_TYPE                                                                  NUMBER

 PIECE                                                                                 NUMBER

 SQL_TEXT                                                                        VARCHAR2(64)

 CON_ID                                                                          NUMBER

视图各个列描述如下：

ADDRESS:配合HASH_VALUE一起确定一个唯一缓存的游标

HASH_VALUE:配合ADDRESS一起确定一个唯一缓存的游标

SQL_ID:游标的SQL ID

COMMAND_TYPE：SQL语句的代码类型

PIECE： SQL文本碎片的标号，用于组成完整SQL文本

SQL_TEXT：包含SQL文本段的列

CON_ID：容器ID