052-10
Automatic Shared Memory Management is disabled for your database instance. You realize that there
are cases of SQL statements performing poorly because of repeated parsing activity, resulting in
degradation of performance. What would be your next step to improve performance?
A. Run the SQL Access Advisor.
B. Run the Memory Advisor for the SGA.
C. Run the Memory Advisor for the PGA.
D. Run the Memory Advisor for the shared pool.
E. Run the Memory Advisor for the buffer cache.
这里是表示内存自动管理被禁用,然后SQL解析的有一定的瓶颈。Library Hit Ratio 太低了,需要增大shared pool
9:
The user session must automatically be logged off if more than 10 minutes elapsed time used.
How would you accomplish the above?
A. by assigning profiles for the users
B. by implementing Fine-Grained Auditing (FGA)
C. by granting a secure application role to the users
D. by implementing the Database Resource Manager plan
表示需要一个登录的oracle用户10分钟之后强制退出。
选择A, 可以设置profile的connect_time 以及IDle时间都是可以进行控制的