oraclearchitecturalcomponents(英文版)-文庫吧
2025-01-13 09:44 本頁面
【正文】 ivedlog filesDatabaseArchived log filesParameterfilePasswordfileE7 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.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.Connecting to an InstanceUser ServerServerUserClientUser ServerOracle ServerServerApplication serverBrowser E11 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Hidden SlideE12 Copyright 169。 Oracle Corporation, 2023. A
高考資料相關推薦
鄂ICP備17016276號-1