You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below:  SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario? ()A、 A total 

题目

You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below:  SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario? ()

  • A、 A total of 14 GB memory will be allocated to the automatically tuned memory components
  • B、 Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
  • C、 The value for SGA_TARGET can be increased up to a maximum of 14 GB
  • D、 A maximum of 3 GB can be allocated to shared pool
  • E、 Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
  • F、 Increasing the value for SGA_TARGET will automatically increase the memory allocated for  STREAMS_POOL_SIZE
更多“You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below:  SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario? ()A、 A total ”相关问题