How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
4.2 DBA_2PC_PENDING → DBA_2PC_PENDING describes distributed transactions awaiting recovery. Column Datatype NULL
35.7.2 Step 2: Query DBA_2PC_PENDING → An 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
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
You can name a transaction. This is useful for identifying a specific distributed transaction and replaces… → 126.96.36.199 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
35.5.2 Manually Rolling Back an In-Doubt Transaction → LOCAL_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
35.7.5 Step 5: Commit the In-Doubt Transaction → administrator 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.55d1c5188.8.131.52 … hq administrator queries the DBA_2PC_PENDING data dictionary view. SELECT * FROM DBA_2PC_PENDING
35.3.1 Determining the ID Number and Status of Prepared Transactions → Use 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
35.2 Naming Transactions → column of the V$TRANSACTION view, and in the TRAN_COMMENT field of the DBA_2PC_PENDING view when the transaction is committed.
34.4.3 Manual Resolution of In-Doubt Transactions → DBA_2PC_PENDING and DBA_2PC_NEIGHBORS views to determine whether the databases involved in the
35.7.3 Step 3: Query DBA_2PC_NEIGHBORS on Local Node → the 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
35.4.2 Determining Whether to Perform a Manual Override → dictionary view DBA_2PC_PENDING. The failure preventing the two-phase commit phases to complete cannot be
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
35.9.1 Forcing a Distributed Transaction to Fail → appears in the DBA_2PC_PENDING view. If enabled, RECO automatically resolves the transaction.
35.3.2 Tracing the Session Tree of In-Doubt Transactions → GLOBAL_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
35.5 Manually Overriding In-Doubt Transactions → DBA_2PC_PENDING for the distributed transaction. An application can prescribe advice about whether to
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.
ROLLBACK → dictionary view DBA_2PC_PENDING. A ROLLBACK statement with a FORCE clause rolls back only the
COMMIT → dictionary 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
19.4.3 Using SYS Account Tables to Monitor Oracle XA Transactions → DBA_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