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 database to Autonomous AI Database. You must be logged in as the ADMIN user or have 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`

Parent topic: Autonomous AI Database Views