oracleocpsqloraclearchitecturalcomponents-文庫吧資料
2025-01-26 07:08本頁面
【正文】 rocess E23 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. Program Global Area (PGA) ? Not shared ? Writable only by the server process ? Contains: – Sort area – Session information – Cursor state – Stack space Server process PGA E17 Copyright 169。 Oracle Corporation, 2023. All rights reserved. The Shared Pool ? The library cache contains the SQL statement text, parsed code, and execution plan. ? The data dictionary cache contains table, column, and other object definitions and privileges. ? The shared pool is sized by SHARED_POOL_SIZE. Data dictionary cache Library cache Shared pool E15 Copyright 169。 Oracle Corporation, 2023. All rights reserved. Connecting to an Instance User Server Server User Client User Server Oracle Server Server Application server Browser E12 Copyright 169。 Oracle Corporation, 2023. All rights reserved. Oracle Instance Background processes An Oracle instance: ? Is a means to access an Oracle database ?
法律信息相關(guān)推薦
鄂ICP備17016276號-1