PURGE_CONVERTED_STMTS View
Describes how to review SQL statement conversions after migration using the DBA_CONVERTED_STATEMENTS view.
Related View: DBA_CONVERTED_STATEMENTS displays information about converted SQL statements when migrating from on-premises Oracle AI Database to Autonomous AI Database. You must be logged in as the ADMIN user or have been granted the PDB_DBA role to query this view.
| Column | Data Type | Description |
|---|---|---|
EXEC_TIME |
TIMESTAMP(6) |
Most recent SQL execution timestamp. |
SESSION_ID |
NUMBER |
Session identifier. |
SESSION_SERIAL |
NUMBER |
Session serial identifier. |
USER_ID |
NUMBER |
User identification number. |
USER_NAME |
VARCHAR2(128) |
Username. |
ORIGINAL_SQL_TEXT |
CLOB |
Original SQL statement. |
CONVERTED_SQL_TEXT |
CLOB |
Converted SQL statement. |
ACTION_TAKEN |
VARCHAR2(1000) |
Action taken: REPLACED or IGNORED. |