In this vodie, we will define what a distributed transaction is and how the RECO process cleans up after failed distributed transactions
- [Lecturer] Whoa, we are really making great progress. We have reviewed most of the Oracle background processes with only three more to go. Let's keep it moving. Our next background process is the RECO process, which stands for the Recover Process. The Recover Process is a background process that is used as part of distributed database transactions. Distributed transactions are transactions that involve multiple databases, and should either commit a rollback on both databases at once.
A distributed transaction should not be allowed to only succeed on a single database. For example, assume we have two databases. Database A and database B. A distributed transaction is executed, requesting to modify data on both databases, starting with database A. As the transaction is running on database A, it begins updating rows local to database A. The transaction is also executed on the remote database, database B, updating rows local to database B.
If during the update on database B, the transaction failed, it will be marked as an in doubt or failed transaction, and should be cleaned up on both databases. The RECO process handles this task, and automatically resolves any failures of those distributed transactions. It will automatically connect to the other databases involved in such in doubt or failed distributed transactions, and remove any rows that were affected by the transaction.
After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Learning Relational Databases (2014)with Adam Wilbert2h 39m Beginner
2. Instance Memory Pools
3. Instance Background Processes
4. Client Connections
5. Physical Database Structures
6. Mulitenant Database
7. Start and Stop the Database
8. Install Oracle 12c software
9. Create a Database Instance
Use DBCA to create a database14m 55s
10. Tools for Developers and DBAs
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.