Refresher (deep dive) wanted on the database runtime engine
I am looking for a recent source to refresh my knowledge on the Oracle database runtime engine. We are using Oracle 19 and a combination of SE and EE. Our app connects to the DB via a JDBC connection pool. I have not dived deeply into this in a few years and wanted to catch up. I am looking for a really deep dive into this covering topics such as the DB processing a mixture of long and short queries, parallelization and queuing, recycling of connections, Behavior of the runtime engine with and without resource manager turned on.