Observe the information in the columns:
1. The SGAa. 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?
A.
1-c, 2-b, 3-d, 4-a
B.
1-b, 2-c, 3-d, 4-a
C.
1-a, 2-b, 3-c, 4-d
D.
1-a, 2-b, 3-d, 4-c
System Global Area (SGA), which is shared by all server and background processe
A “stack,” or stack space, is a block of memory used to store temporary data needed for proper program execution.
http://blog.csdn.net/rlhua/article/details/16878087
• The shared SQL area stores all SQL statements in a parsed form.
The shared SQL area is in the Library Cache. The Library Cache is in the Shared Pool. The Shared pool is in the SGA.
• The cursor state contains runtime information for the cursor, including the rows retrieved and return codes.
• User session data includes user-specific information for the session such as security and other resource usage information.
• The stack space contains local variables used by the user session.