oracleocpsqloraclearchitecturalcomponents-在線瀏覽
2025-02-23 07:08本頁(yè)面
【正文】 l rights reserved. Other Key Physical Structures Archived log files Database Archived log files Parameter file Password file E7 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. Processing a Query ? Parse: – Search for identical statement – Check syntax, object names, and privileges – Lock objects used during parse – Create and store execution plan ? Execute: Identify rows selected ? Fetch: Return rows to user process E13 Copyright 169。 Oracle Corporation, 2023. All rights reserved. Database Buffer Cache ? Stores the most recently used blocks ? Size of a buffer based on DB_BLOCK_SIZE ? Number of buffers defined by DB_BLOCK_BUFFERS Data buffer cache E16 Copyright 169。 Oracle Corporation, 2023. All rights reserved. 1 1 Processing a DML Statement 2 3 4 UPDATE employees ... User process Server process Database Redo log f
法律信息相關(guān)推薦
鄂ICP備17016276號(hào)-1