oraclearchitecturalcomponents(英文版)(存儲(chǔ)版)
【正文】 y rows selected? Fetch: Return rows to user processE13 Copyright 169。 Oracle Corporation, 2023. All rights reserved. Rollback SegmentDML statementOld imageNew imageRollback segmentTableE21 Copyright 169。 Oracle Corporation, 2023. All rights reserved.SummaryIn 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, fetchE29 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 segmentsE27 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Hidden SlideE19 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.ObjectivesAfter pleting this appendix, you should be ableto do the following:? Describe the Oracle Server architecture and its main ponents? List the structures involved in connecting a user to an Oracle i
高考資料相關(guān)推薦
鄂ICP備17016276號(hào)-1