Shulou(Shulou.com)06/01 Report--

I learned about the architecture of Oracle today.

The whole system can be explained by a picture, or it can be compared to a football team.

Users must access the database through the service process.

In the database, at the front are shared pools, database buffer caches and redo log buffers, as well as java pools and large shared pools. There is a library in the shared pool that tells the cache, the data dictionary cache these buffers after the client has read once, there is no need to filter the disk when the client reads it, it can be read directly in memory, which greatly improves the access speed. The log buffer is more important, in case some data is not written to disk, or after a sudden failure, the log buffer can help you recover the data.

Next, uh, PMON SMON DBWR LGMR CKPT, these are process monitors, system monitors, data writers, log writers, and checkpoints. they have a clear division of labor and help us deal with the tasks of the database in an orderly manner.

And at the bottom are data files, control files and redo log files, which are really things that store data. The upper data writer and log writer will write the contents of the top buffer into these three containers, and the last one is the archived log file. He will record all operations for a rainy day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.