Oracle7 Server Distributed Systems Volume II: Replicated Data

Listing Information about Deferred Transactions

Oracle provides several tables and views for you to use in administering deferred transactions. These views provide information about each deferred transaction, such as the transaction destinations, the deferred calls that make up the transaction, and any errors encountered during attempted execution of the transaction. You should not modify these tables directly; use the procedures provided in the DBMS_DEFER and DBMS_DEFER_SYS packages.

These views are briefly described below. For more information, see Chapter 13.

DefCall Records all deferred remote procedure calls.
DefCallDest Lists the destinations for each deferred remote procedure call.
DefDefaultDest Lists the default destination for deferred remote procedure calls.
DefError Provides information about transactions that could not be applied at each destination.
DefSchedule Displays information about when a job is next scheduled to be executed.
DefTran Records all deferred transactions.
DefTranDest Lists the destinations for a deferred transaction.

DefCall	Records all deferred remote procedure calls.
DefCallDest	Lists the destinations for each deferred remote procedure call.
DefDefaultDest	Lists the default destination for deferred remote procedure calls.
DefError	Provides information about transactions that could not be applied at each destination.
DefSchedule	Displays information about when a job is next scheduled to be executed.
DefTran	Records all deferred transactions.
DefTranDest	Lists the destinations for a deferred transaction.