The Heart of Oracle How the RDBMS actually works
How does the Oracle RDBMS actually work? In this session I'll tell you how. All of it. In under an hour. Well, the key processes and activities anyway. Whether Cloud or on your own servers, Oracle 12.2 back to, well, any version you have!
The session will help you better understand SQL and database performance, how data moves between disk, memory & your queries, how Oracle ensures you see a consistent set of data and, most importantly, what a "Consistent Get" actually is. And why the Datafiles are less important then Redo.
If you can write a select statement you can understand everything in this talk - and might end up knowing some things most oracle professionals don't know.
Understanding how the database works really helps you to use it more efficiently.