Which of the following is true when CURSOR_SPACE_FOR_TIME=TRUE ?
A. The cursor cannot be deallocated from memory while an application cursor that is associated with it is open.
B . The cursor will be deallocated from memory as soon as all application cursors are closed.
C . The cursor must be deallocated from memory as soon as an application cursor that is associated with it is open.
D . The cursor management algorithm will attempt to deallocate used cursors from memory while an application cursor that is associated with it is open, if the library cache hit ratio is less than the specified threshold.
Explanation:
Answer A: Setting CURSOR_SPACE_FOR_TIME=TRUE indicates that the cursor will not be deallocated from memory as long as the application cursor is open. Only set this to TRUE if you have no library cache misses; the library cache hit ratio is almost 100 percent. Each of the other statements is an incorrect assessment of how the setting influences cursor retention.
No comments:
Post a Comment