Tools
CATEGORY

Database

Master SQL, PostgreSQL, MySQL, MongoDB, and trending open-source databases. Learn optimization, design patterns, and best practices for modern data management.

323 articles
12 min read

Oracle Transaction Management & Read Consistency

Oracle’s transaction management and read consistency mechanisms are fundamental to maintaining data integrity in multi-user environments. Understanding how Oracle handles concurrent transactions, prevents dirty…

9 min read

Oracle ROLLBACK Statement: Behind the Scenes

When you execute ROLLBACK;, Oracle discards all uncommitted changes and restores data to its previous state. Understanding ROLLBACK is essential for transaction management and…

14 min read

Oracle COMMIT Statement: Behind the Scenes

When you execute COMMIT;, Oracle makes all your DML changes permanent. This seemingly simple statement triggers a complex series of operations involving redo logs,…

21 min read

Oracle DELETE Statement: Behind the Scenes

When you execute DELETE FROM employees WHERE employee_id = 101;, Oracle performs a complex series of operations involving row location, undo generation, lock management,…

15 min read

Oracle UPDATE Statement: Behind the Scenes

When you execute UPDATE employees SET salary = 60000 WHERE employee_id = 101;, Oracle performs a sophisticated series of operations involving undo segments, redo…

26 min read

Oracle INSERT Statement: Behind the Scenes

When you execute a simple INSERT INTO employees VALUES (101, 'John', 'Doe', 50000); statement, Oracle performs a complex series of operations involving memory structures,…

14 min read

Oracle SELECT Statement: Behind the Scenes

When you execute a simple SELECT * FROM employees WHERE department_id = 10; query, have you ever wondered what happens behind the scenes? Understanding…