You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario? ()
- A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
- B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
- C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
- D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
正确答案:B,D
答案解析:有
微信扫一扫手机做题