Oracle
Before going through this article it will be helpful to read SQL – Transaction Statements -Transaction Management… and Savepoints In SQL Transactions. – SAVEPOINT to know more about SQL transactions.
Autonomous transactions are independent transactions that can be called from within another transaction.
Continue reading about Autonomous Transactions in PL/SQL -Autonomous Transactions
A Transaction ensures that the action of a group of statements is atomic.A transaction is a logical unit of work that contains one or more SQL statements.The effects of all the SQL statements in a transaction can be either all committed or all rolled back.
Continue reading about SQL – Transaction Statements -Transaction Management
Savepoints In SQL Transactions. – Oracle SAVEPOINT.
The intermediate markers within the context of a transaction called savepoints. Savepoints divide a long transaction into smaller parts.
Continue reading about Savepoints In SQL Transactions. – SAVEPOINT
The data in oracle is stored logically in tablespaces and physically in datafiles.
Tablespaces collectively store all of the database’s data.
Continue reading about Oracle Tablespace, and Datafiles – Introduction
FINDING oracle database objects, finding valid and INVALID objects and finding object counts – SQL Tips