Day: March 18, 2022

SYSTEM Tablespace is Growing Abnormally in 12c

by

SYSTEM Tablespace is Growing Abnormally in 12c My SYSTEM tablespace was growing rapidly. This was happening in my test environment. We observe that we were not doing much on this database. Only few users were working to test the application and doing approx 40-50 transaction per day. That’s it.There was no much load as well, … Read more

ACID PROPERTY : Transactions

by

A transaction is a logical, atomic unit of work that contains one or more SQL statements. A transaction groups SQL statements so that they are either all committed, which means they are applied to the database, or all rolled back, which means they are undone from the database. Oracle Database assigns every transaction a unique … Read more

Categories SQL