oraclearchitecturalcomponents(英文版)(完整版)
【正文】 erprocessDatabaseRedolog filesControl filesData files SGARedo logbufferData buffercacheShared poolE18 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Processing a SQL Statement? Connect to an instance using:– The user process– The server process? The Oracle Server ponents that are used depend on the type of SQL statement:– Queries return rows– DML statements log changes– Commit ensures transaction recovery? Some Oracle Server ponents do not participate in SQL statement processing.E10 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Oracle Architectural ComponentsE2 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Other Key Physical StructuresArchivedlog filesDatabaseArchived log filesParameterfilePasswordfileE7 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Hidden SlideE15 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Hidden SlideE23 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Hidden SlideE31 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.Program Global Area (PGA)? Not shared? Writab
高考資料相關(guān)推薦
鄂ICP備17016276號(hào)-1