Understanding SQL Transaction Management in Oracle

Q

Where to find answers to frequently asked questions on SQL Transaction Management in Oracle?

✍: FYIcenter.com

A

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Transaction Management in Oracle. Clear answers are provided with tutorial exercises on starting and ending transactions, committing and rolling back transactions, transaction/statement-level read consistency, read committed isolation level, locks and dead locks.

What Is a Transaction in Oracle

Ways to Start a New Transaction in Oracle

Ways to End the Current Transaction in Oracle

Create a Test Table for Transaction Testing in Oracle

Commit the Current Transaction in Oracle

Rollback the Current Transaction in Oracle

Transaction Commit When DDL Statement Executed in Oracle

Transaction Commit When Session Ended in Oracle

Transaction Rollback When Session Killed in Oracle

Read Consistency in Oracle in Oracle

What Is a READ WRITE Transaction in Oracle

What Is a READ ONLY Transaction in Oracle

Set a READ ONLY Transaction in Oracle

Restrictions in a READ ONLY Transaction in Oracle

General Rules on Data Consistency in Oracle

Supported Transaction Isolation Levels in Oracle

What Is a Data Lock in Oracle

How Data Locks Are Respected in Oracle

Experiments of Data Locks in Oracle

Show Existing Locks on the Database in Oracle

What Is a Dead Lock in Oracle

How Oracle Handles Dead Locks in Oracle

Sample scripts used in this FAQ assumes that you are connected to the server with the HR user account on the default database instance XE. See other FAQ collections on how to connect to the server.

Some sample scripts may require database tables created by other samples in the beginning of the collection.

 

⇒⇒Oracle Database Tutorials

2016-10-16, 204👍, 0💬