How Oracle store your data

All of you probably at least once in your life try to insert some records to a database table, but is anyone of you ever tried to understand how Oracle actually saves the entries in the database? Last time I was making a small experiment and I want to share my results with you. Step one, let’s build a small table and insert a few records: INSERT INTO tab1 VALUES('AAA',111); INSERT INTO tab1 VALUES('AAA',222); INSERT INTO tab1 VALUES('AAA',333); INSERT INTO tab1 VALUES('AAA',444); INSERT INTO tab1 VALUES('BBB',111); INSERT INTO tab1 VALUES('BBB',222); INSERT INTO tab1 VALUES('BBB',333); INSERT INTO tab1 VALUES('BBB',444); INSERT INTO tab1 VALUES('CCC',111); INSERT INTO tab1 VALUES('CCC',222); INSERT INTO tab1 VALUES('CCC',333); INSERT INTO tab1 VALUES('CCC',444); Let’s start some fun and check how my dump from Oracle DB looks like....

August 10, 2018 · 4 min