oraclearchitecturalcomponents(英文版)-文庫吧在線文庫
【正文】 nstance? List the stages in processing:– Queries– DML statements– CommitsE3 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Oracle Database FilesDatabaseRedolog filesControl filesData files Archived log filesParameterfilePasswordfileE6 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 dictionarycacheLibrarycacheShared poolE14 Copyright 169。 Oracle Corporation, 2023. All rights reserved.SGARedo logbufferData buffercacheShared pool LGWRInstanceDatabaseRedolog filesControl filesData files COMMIT Processing1234UserprocessServerprocessE22 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Hidden SlideE30 Copyright 169。 Oracle Corporation, 2023. All rights reserved.Database Writer (DBW0)DBW0 writes when:? There are many dirty buffers? There are few free buffers? Timeout occurs? Checkpoint occursSGARedo logbufferData buffercacheShared poolDatabaseRedolog filesControl filesData files DBW0E26 Copyright 169。 Oracle Corporation, 2023. All rights reserved.11Processing a DML Statement2 34UPDATE employees ...UserprocessServ
高考資料相關(guān)推薦
鄂ICP備17016276號(hào)-1