When is the best time to pin large, frequently used objects in the shared pool?
A. Immediately after startup.
B . On startup, by specifying the PIN_LARGE_OBJECTS parameter.
C . Immediately prior to their use.
D . On startup, by specifying the FAST_LOAD_OBJECTS parameter.
E . Immediately after shutdown.
Explanation:
Answer A: We can eliminate Immediately after shutdown, On startup, by specifying the PIN_LARGE_OBJECTS parameter, and On startup, by specifying the FAST_LOAD_OBJECTS parameter; we cannot pin objects when the database is down, and the two parameters mentioned are not valid init.ora parameters. So that leaves Immediately after startup or Immediately prior to their use: ; if we choose to pin large objects immediately prior to their use, then the first process that accesses the object will take a performance hit. To avoid this hit, and possible fragmentation, load the large frequently- used objects immediately after startup.
No comments:
Post a Comment