What is oracle ACID?

Atomicity All or None A transaction includes multiple statement/queries to be processed. The atomicity property identifies that the transaction is atomic. An atomic transaction is either fully completed, or is not begun at all. All the statements to be processed or none of them to be processed. Consistency: This property ensures that any transaction will bring the database from one valid state to another. Any data written to the database must be valid according to all defined rules, including constraints, cascades, triggers, and any combination thereof. Isolation This isolation property ensures that the concurrent execution of transaction statements. All the statement must execute in serial order (one after the other). Providing isolation is the main goal of concurrency control. Durable: This property means that once a transaction has been committed, it will remain so, even in the event of power loss, crashes, or errors. read less

ACID: A- Atomicity: Transaction should be complete or not complete. Transactions are taken as atomic unit. C- Consistency: The database must remain in a consistent state after any transaction I- Integrity: In a database system where more than one transaction are being executed simultaneously and in parallel, the property of isolation states that all the transactions will be carried out and executed as if it is the only transaction in the system. No transaction will affect the existence of any other transaction. D- Durability: The database should be durable enough to hold all its latest updates even if the system fails or restarts. read less

Hi Ramesh, All Relational Databases have a concept called ACID. This is an acronym for Atomicity, Consistency, Isolation and Durability. This concept rules the how a transaction behaves by default and how it can be controlled. it is also called properties of a transaction. This is a very detailed concept, and is followed by all Databases, not only Oracle DB. I will be posting a lesson on Transactions and behaviour soon on UrbanPro. In the mean while, to get more information on ACID, google ACID properties of a Transaction using Oracle Database. read less