A. All SGA components retain their current sizes at the time of disabling.
B. All auto-tuned SGA components are reset to their original user-defined values.
C. The SGA size remains unaffected after disabling ASMM.
D. It requires a database instance restart to take effect.
E. Both SGA_TARGET and SGA_MAX_SIZE must be set to zero.
F. All SGA components excluding fixed SGA and other internal allocations are readjusted immediately after disabling ASMM.
A. One or more results were aged out of the result cache.
B. Decreasing the value set for RESULT_CACHE_REMOTE_EXPIRATION.
C. A request was made by the RCBG background process in a physical standby database that is opened read only and whose primary has a result cache.
D. result_cache_max_size is set dynamically to 0.
E. A request was made by the RCBG background of a non-RAC database.
A.
B.
C.
D.
E.
F.
G.
A. Both the RECYCLE and KEEP buffer caches should always have a very high cache hit ratio.
B. The performance of workloads that primarily generate full table scans and fast full index scans are always affected by the cache hit ratio.
C. A 99% cache hit ratio can be observed for database instances which have very poor I/O performance.
D. A 60% cache hit ratio can be observed for database instances which have very good I/O performance.
E. The buffer cache advisory view v$db_cache_advice provides advice on cache hit ratios appropriate for the instance workload.
A. By viewing V$SERVICE_STATS
B. By viewing V$SERV_MOD_ACT_STATS
C. In $ORACLE_BASE/diag/rdbms/<db unique name>/<instance name>/trace
D. In the current working directory
A. Design and development
B. Upgrade or migration
C. Testing
D. Production
E. Deployment
