PURGE_CONVERTED_STMTS View
Describes the Autonomous AI Database PURGE_CONVERTED_STMTS views.
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 the PDB_DBA role granted to query this view.
| Column | Datatype | 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) |
Executing action, REPLACED or IGNORED |