8.73 V$MAPPED_SQL
V$MAPPED_SQL
lists the SQL statements that are translated and mapped in memory to a different SQL statement for execution.
Column | Datatype | Description |
---|---|---|
|
|
First 1000 characters of the original SQL text |
|
|
Full text for the original SQL statement |
|
|
SQL identifier of the original SQL statement |
|
|
Hash value of the original SQL statement |
|
|
First 1000 characters of the mapped SQL text |
|
|
Full text for the mapped SQL statement |
|
|
SQL identifier of the mapped SQL statement |
|
|
Hash value of the mapped SQL statement |
|
|
A non-NULL value specifies the object ID of the SQL translation profile used to translate the SQL statement into the mapped SQL statement |
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
Time this SQL statement was translated |
|
|
CPU time used to translate this SQL statement |
|
|
Elapsed time used to translate this SQL statement |
|
|
Method used to translate this SQL statement |
|
|
SQL ID of SQL text in custom translation dictionary used to translate this SQL statement |
|
|
Number of times this translation has been used |