The Heart of Oracle 12C – How the core RDBMS works
How does the Oracle RDBMS actually work? Despite the complexity and capability of the database, there are just a few things you need to know to understand most of it. In this session I’ll explain them, covering the core structures and activities that drive the RDBMS. Whilst this is an overview presentation it is still technical.
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.