Oracle FLASHBACK_TRANSACTION_QUERY

￡神魔★判官ぃ 2023-10-18 23:42 63阅读 0赞

### FLASHBACK\_TRANSACTION\_QUERY ###

`FLASHBACK_TRANSACTION_QUERY` displays information about all flashback transaction queries in the database.

<table> 
 <thead> 
 <tr> 
 <th>Column</th> 
 <th>Datatype</th> 
 <th>NULL</th> 
 <th>Description</th> 
 </tr> 
 </thead> 
 <tbody> 
 <tr> 
 <td><code>XID</code></td> 
 <td><code>RAW(8)</code></td> 
 <td>&nbsp;</td> 
 <td>Transaction identifier</td> 
 </tr> 
 <tr> 
 <td><code>START_SCN</code></td> 
 <td><code>NUMBER</code></td> 
 <td>&nbsp;</td> 
 <td>Transaction start system change number (SCN)</td> 
 </tr> 
 <tr> 
 <td><code>START_TIMESTAMP</code></td> 
 <td><code>DATE</code></td> 
 <td>&nbsp;</td> 
 <td>Transaction start timestamp</td> 
 </tr> 
 <tr> 
 <td><code>COMMIT_SCN</code></td> 
 <td><code>NUMBER</code></td> 
 <td>&nbsp;</td> 
 <td>Transaction commit system change number (null for active transactions)</td> 
 </tr> 
 <tr> 
 <td><code>COMMIT_TIMESTAMP</code></td> 
 <td><code>DATE</code></td> 
 <td>&nbsp;</td> 
 <td>Transaction commit timestamp (null for active transactions)</td> 
 </tr> 
 <tr> 
 <td><code>LOGON_USER</code></td> 
 <td><code>VARCHAR2(30)</code></td> 
 <td>&nbsp;</td> 
 <td>Logon user for the transaction</td> 
 </tr> 
 <tr> 
 <td><code>UNDO_CHANGE#</code></td> 
 <td><code>NUMBER</code></td> 
 <td>&nbsp;</td> 
 <td>Undo system change # (<code>1</code>&nbsp;or higher)</td> 
 </tr> 
 <tr> 
 <td><code>OPERATION</code></td> 
 <td><code>VARCHAR2(32)</code></td> 
 <td>&nbsp;</td> 
 <td>Forward-going DML operation performed by the transaction: 
 <ul> 
 <li> <code>D</code>&nbsp;- Delete </li> 
 <li> <code>I</code>&nbsp;- Insert </li> 
 <li> <code>U</code>&nbsp;- Update </li> 
 <li> <code>B</code> </li> 
 <li> <code>UNKNOWN</code> </li> 
 </ul></td> 
 </tr> 
 <tr> 
 <td><code>TABLE_NAME</code></td> 
 <td><code>VARCHAR2(256)</code></td> 
 <td>&nbsp;</td> 
 <td>Name of the table to which the DML applies</td> 
 </tr> 
 <tr> 
 <td><code>TABLE_OWNER</code></td> 
 <td><code>VARCHAR2(32)</code></td> 
 <td>&nbsp;</td> 
 <td>Owner of the table to which the DML applies</td> 
 </tr> 
 <tr> 
 <td><code>ROW_ID</code></td> 
 <td><code>VARCHAR2(19)</code></td> 
 <td>&nbsp;</td> 
 <td>Rowid of the row that was modified by the DML</td> 
 </tr> 
 <tr> 
 <td><code>UNDO_SQL</code></td> 
 <td><code>VARCHAR2(4000)</code></td> 
 <td>&nbsp;</td> 
 <td>SQL to undo the DML indicated by&nbsp;<code>OPERATION</code></td> 
 </tr> 
 </tbody> 
</table>