Which component of the SGA stores parsed SQL statements is used for process sharing?()
Observe the information in the columns: 1: The SGA a. Text and parsed forms of all SQL statements 2: The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved 3: User-session data c. Security and resource usage information 4:The stack space d. Local variables for the process Which option has the correct match between the memory areas and their contents()
he Dynamic SGA feature allows the SGA to grow and shrink dynamically according to an ALTER SYSTEM command. This avoids the previous need of shutting down the instance in order to modify the components of the SGA, namely the buffer cache and shared pool components. Which three statements are true for the Dynamic SGA feature? ()
以下内存区不属于SGA的是()。
以下关于SGA和PGA的叙述正确的是()
64S型继电半自动闭塞为什么在TCJ电路中加入SGA的第一组和第二组接点?。
To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters?()
The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA,based on the amount of memory available on the system?()
Observe the information in the columns: 1. The SGA a. Text and parsed forms of all SQL statements 2. The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved 3. User-session data c. Security and resource usage information 4. The stack space d. Local variables for the process Which option has the correct match between the memory areas and their contents()
Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately?()