试题详情
多项选择题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
  • 关注下方微信公众号,在线模考后查看

热门试题