oracleocpsqloraclearchitecturalcomponents(完整版)
【正文】 cache Library cache PMON DBW0 SMON LGWR CKPT Others E5 Copyright 169。 Oracle Corporation, 2023. All rights reserved. Oracle Database Files Database Redo log files Control files Data files Archived log files Parameter file Password file E6 Copyright 169。 Oracle Corporation, 2023. All rights reserved. Program Global Area (PGA) ? Not shared ? Writable only by the server process ? Contains: – Sort area – Session information – Cursor state – Stack space Server process PGA E17 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 segments E27 Copyright 169。 Oracle Corporation, 2023. All rights reserved. Summary In 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, fetch E30 Copyright 169。 Oracle Corporation, 2023. All rights reserved. Redo Log Buffer ? Has its size defined by LOG_BUFFER
法律信息相關(guān)推薦
鄂ICP備17016276號(hào)-1