oraclearchitecturalcomponents(英文版)-資料下載頁
2025-01-23 09:44本頁面
【正文】 racle Corporation, 2023. All rights reserved.Database Writer (DBW0)DBW0 writes when:? There are many dirty buffers? There are few free buffers? Timeout occurs? Checkpoint occursSGARedo logbufferData buffercacheShared poolDatabaseRedolog filesControl filesData files DBW0E26 Copyright 169。 Oracle Corporation, 2023. All rights reserved.SMON: System Monitor? Automatically recovers the instance:– Rolls forward changes in the redo logs– Opens the database for user access– Rolls back unmitted transactions? Coalesces free space? Deallocates temporary segmentsE27 Copyright 169。 Oracle Corporation, 2023. All rights reserved.PMON: Process MonitorCleans up after failed processes by:? Rolling back the transaction? Releasing locks? Releasing other resourcesE28 Copyright 169。 Oracle Corporation, 2023. All rights reserved.SummaryIn this appendix, you should have learned how to:? Identify database files: data files, control files, online redo logs? Describe SGA memory structures: DB buffer cache, shared SQL pool, and redo log buffer? Explain primary background processes: DBW0, LGWR, CKPT, PMON, SMON, and ARC0? List SQL processing steps: parse, execute, fetchE29 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Hidden SlideE30 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Hidden SlideE31 Copyright 169。 Oracle Corporation, 2023. All rights reserved.演講完畢，謝謝觀看！
高考資料相關(guān)推薦
鄂ICP備17016276號-1