SUMMARY_TRANSACTIONS_PREPARED_XACTS
Displays information about transactions that are currently prepared for two-phase commit on the primary database node, as described in Table 1. In the multi-tenancy scenario, global statistics are returned if this view is accessed in a non-PDB, and statistics about a PDB is returned if this view is accessed in the PDB.
Name |
Type |
Description |
---|---|---|
transaction |
xid |
Numeric transaction identifier of the prepared transaction. |
gid |
text |
Global transaction identifier that was assigned to the transaction. |
prepared |
timestamp with time zone |
Time at which the transaction is prepared for commit. |
owner |
name |
Name of the user who executes the transaction. |
database |
name |
Name of the database in which the transaction is executed. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.