Architecture

Summary

That’s it — the three pieces to Oracle. We’ve covered the files used by Oracle, from the lowly, but important, init.ora, to data files, redo log files and so on. We’ve taken a look inside the memory structures used by Oracle, both in the server processes and the SGA. We’ve seen how different server configurations such as MTS versus dedicated server mode for connections will have a dramatic impact on how memory is used by the system. Lastly we looked at the processes (or threads depending on the operating system) that make Oracle do what it does. Now we are ready to look at the implementation of some other features in Oracle such as Locking and Concurrency controls, and Transactions in the following chapters.