You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for DBA_2PC_PENDING


1 to 20 of 39 results. Previous page Prev  Next next page


Database Reference, 12c Release 1 (12.1)

DBA_2PC_PENDING

4.2 DBA_2PC_PENDINGDBA_2PC_PENDING describes distributed transactions awaiting recovery. Column Datatype NULL

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Distributed Transactions

35.7.2 Step 2: Query DBA_2PC_PENDINGAn example illustrates querying the DBA_2PC_PENDING data dictionary view for information about in … -doubt transactions. After connecting with SQL*Plus to warehouse, query the local DBA_2PC_PENDING data … @warehouse.example.com AS SYSDBA SELECT * FROM DBA_2PC_PENDING WHERE LOCAL_TRAN_ID = '1.21.17'; The database returns the

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Distributed Transactions

35.7.6 Step 6: Check for Mixed Outcome Using DBA_2PC_PENDING… You can query the pending transaction table of a database through the DBA_2PC_PENDING data

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Distributed Transactions

You can name a transaction. This is useful for identifying a specific distributed transaction and replaces…35.4.3.1 Find a Node that Committed or Rolled Back Use the DBA_2PC_PENDING view to find a node that … Comments See if any information is given in the TRAN_COMMENT column of DBA_2PC_PENDING for the

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Distributed Transactions

35.5.2 Manually Rolling Back an In-Doubt TransactionLOCAL_TRAN_ID or GLOBAL_TRAN_ID columns of the DBA_2PC_PENDING data dictionary view. For example … , assume that you query DBA_2PC_PENDING and determine that LOCAL_TRAN_ID for a distributed transaction … the DBA_2PC_PENDING view of a remote database also involved with the transaction in question. Note the … LOCAL_TRAN_ID or GLOBAL_TRAN_ID

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Distributed Transactions

35.7.5 Step 5: Commit the In-Doubt Transactionadministrator queries the DBA_2PC_PENDING data dictionary view. SQL> CONNECT SYS@sales.example.com AS SYSDBA SQL … > SELECT * FROM DBA_2PC_PENDING > WHERE GLOBAL_TRAN_ID = 'SALES.EXAMPLE.COM.55d1c563.1.93.29 … hq administrator queries the DBA_2PC_PENDING data dictionary view. SELECT * FROM DBA_2PC_PENDING

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Distributed Transactions

35.3.1 Determining the ID Number and Status of Prepared TransactionsUse the DBA_2PC_PENDING view to determine the global commit number for a particular transaction ID … dictionary: View Purpose DBA_2PC_PENDING Lists all in-doubt distributed transactions. The view is … view, see Oracle Database Reference ): Table 35-1 DBA_2PC_PENDING Column Description LOCAL_TRAN_ID … pending_txn_script, to query

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Distributed Transactions

35.2 Naming Transactionscolumn of the V$TRANSACTION view, and in the TRAN_COMMENT field of the DBA_2PC_PENDING view when the transaction is committed.

Database Administrator's Guide, 12c Release 1 (12.1)

Distributed Transactions Concepts

34.4.3 Manual Resolution of In-Doubt TransactionsDBA_2PC_PENDING and DBA_2PC_NEIGHBORS views to determine whether the databases involved in the

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Distributed Transactions

35.7.3 Step 3: Query DBA_2PC_NEIGHBORS on Local Nodethe State of the Transaction The STATE column of the DBA_2PC_PENDING data dictionary view shows the … Looking for Comments or Advice The TRANS_COMMENT column of the DBA_2PC_PENDING data dictionary view

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Distributed Transactions

35.4.2 Determining Whether to Perform a Manual Overridedictionary view DBA_2PC_PENDING. The failure preventing the two-phase commit phases to complete cannot be

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Distributed Transactions

35.6.1 About Purging Pending Rows from the Data Dictionary, and the MIXED column in DBA_2PC_PENDING has a value of YES. These entries can be cleaned up with the

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Distributed Transactions

35.9.1 Forcing a Distributed Transaction to Failappears in the DBA_2PC_PENDING view. If enabled, RECO automatically resolves the transaction.

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Distributed Transactions

35.3.2 Tracing the Session Tree of In-Doubt TransactionsGLOBAL_TRAN_ID. DBA_2PC_PENDING for a connection are the same, the node is the global coordinator of the … DBA_2PC_PENDING (sample output included): COL LOCAL_TRAN_ID FORMAT A13 COL IN_OUT FORMAT A6 COL

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Distributed Transactions

35.5 Manually Overriding In-Doubt TransactionsDBA_2PC_PENDING for the distributed transaction. An application can prescribe advice about whether to

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_TRANSACTION

PURGE_MIXED Procedure; however, Oracle flags entries in DBA_2PC_PENDING by setting the MIXED column to a value of 'yes'. Oracle … PURGE_MIXED Procedure Parameters Parameter Description xid Must be set to the value of the LOCAL_TRAN_ID column in the DBA_2PC_PENDING table.

Database SQL Language Reference, 12c Release 1 (12.1)

ROLLBACK

ROLLBACKdictionary view DBA_2PC_PENDING. A ROLLBACK statement with a FORCE clause rolls back only the

Database SQL Language Reference, 12c Release 1 (12.1)

COMMIT

COMMITdictionary view DBA_2PC_PENDING along with the transaction ID if a distributed transaction becomes … data dictionary view DBA_2PC_PENDING. You can use integer to specifically assign the transaction a

Database Development Guide, 12c Release 1 (12.1)

Developing Applications with Oracle XA

19.4.3 Using SYS Account Tables to Monitor Oracle XA TransactionsDBA_2PC_PENDING DBA_2PC_NEIGHBORS For transactions generated by Oracle XA applications, this column … XA applications: SELECT * FROM DBA_2PC_PENDING p, DBA_2PC_NEIGHBORS n WHERE p.LOCAL_TRAN_ID

Database SQL Language Reference, 12c Release 1 (12.1)

ALTER SESSION

ALTER SESSIONtransaction. The advice appears in the ADVICE column of the DBA_2PC_PENDING view on the remote database (the