oraclearchitecturalcomponents(英文版)(文件)
【正文】 on, 2023. All rights reserved.Hidden SlideE23 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.Hidden SlideE31 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.Other Instance Processes? Other required processes:– Database Writer (DBW0)– Process Monitor (PMON)– System Monitor (SMON)– Checkpoint (CKPT)? The archive process (ARC0) is usually createdin a production database E25 Copyright 169。 Oracle Corporation, 2023. All rights reserved. Rollback SegmentDML statementOld imageNew imageRollback segmentTableE21 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Program Global Area (PGA)? Not shared? Writable only by the server process? Contains:– Sort area– Session informa
高考資料相關(guān)推薦
鄂ICP備17016276號(hào)-1