oracleocpsqloraclearchitecturalcomponents(專業(yè)版)
【正文】 Oracle Corporation, 2023. All rights reserved. Log Writer (LGWR) LGWR writes when: – There is a COMMIT – The redo buffer log is onethird full – There is more than 1 MB of redo – Before DBW0 writes SGA Redo log buffer Data buffer cache Shared pool LGWR Database Redo log files Control files Data files E24 Copyright 169。 Oracle Corporation, 2023. All rights reserved. Oracle Architectural Components E2 Copyright 169。 Oracle Corporation, 2023. All rights reserved. Redo Log Buffer ? Has its size defined by LOG_BUFFER ? Records changes made through the instance ? Is used sequentially ? Is a circular buffer Redo log buffer E20 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. 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. Database Buffer
法律信息相關(guān)推薦
鄂ICP備17016276號(hào)-1