oraclearchitecturalcomponents(英文版)(專業(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 writesSGARedo logbufferData buffercacheShared pool LGWRDatabaseRedolog filesControl filesData files E24 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Oracle InstanceBackground processesAn Oracle instance:? Is a means to access an Oracle database? Always opens one and only one databaseMemory structuresInstanceSGARedo logbufferData buffercacheShared pool PMON DBW0SMON LGWRCKPT OthersE8 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Oracle InstanceBackground processes? An Oracle instance:– Is a means to access an Oracle database– Always opens one and only one databaseMemory structuresInstanceSGARedo logbufferData buffercacheShared pool PMON DBW0SMON LGWRCKPT OthersE9 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.Hidden SlideE23 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Other Key Physical StructuresArchivedlog fil
高考資料相關(guān)推薦
鄂ICP備17016276號(hào)-1