5.66 DBA_HIST_SQLTEXT
DBA_HIST_SQLTEXT
displays the text of SQL statements belonging to shared SQL cursors captured in the Workload Repository.
This view captures information from V$SQL
and is used with the DBA_HIST_SQLSTAT
view.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Database ID |
|
|
|
SQL identifier of the parent cursor in the library cache |
|
|
|
Full text for the SQL statement exposed as a CLOB column |
|
|
|
Oracle command type definition |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: