TAILIEUCHUNG - Dynamic Instance Resizing

After completing this lesson, you should be able to do the following: Implement dynamic SGA allocation Dynamically adjust the buffer caches Dynamically adjust the shared pool | Dynamic Instance Resizing Objectives After completing this lesson, you should be able to do the following: Implement dynamic SGA allocation Dynamically adjust the buffer caches Dynamically adjust the shared pool Dynamic SGA Feature The dynamic SGA feature implements an infrastructure to allow the server to change its SGA configuration without shutting down the instance. SGA is limited by SGA_MAX_SIZE. A dynamic SGA can grow and shrink in response to a DBA command. Dynamic SGA The SGA has always been a static allocation of memory, which was shared across all threads of execution. The dynamic SGA infrastructure allows for the sizing of the buffer cache and shared pool without having to shut down the instance, modify the initialization parameter file, and restart the instance. In addition, the dynamic SGA infrastructure allows limits to be set at run time on how much physical memory is used for the SGA. The parameter that limits the memory is SGA_MAX_SIZE. This amount of memory is .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.