Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)
A.
Shared SQL Area will be allocated in the shared pool
B.
Shared SQL Area will be allocated when a session starts
C.
Shared SQL Area will be allocated in the large pool always
D.
The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always
E.
Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool
F.
The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter
OPEN_CURSORS specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once.
Shared area
Contains parse tree and execution path. The shared SQL area stores each SQL statement executed in the database. This area allows SQL execution plans to be reused by many users.
Private area ( session-specific)
Private SQL areas are non-shared memory areas assigned to unique user sessions.
The PGA is memory specific to an operating process or thread that is not shared by other processes or threads on the system. Because the PGA is process-specific, it is never allocated in the SGA.
private SQL area is in the UGA
SGA include cached data blocks and shared SQL areas
OPEN CURSOR – PRIV SQL HANDLE