share 1Z0-064 部分题

QUESTION 1
You are administering a database that supports an OLTP workload. Users complain about the degraded response time of a query. You want to gather new statistics
for objects accessed by the query and test query performance with the new statistics without affecting other sessions connected to the instance.
The STALE_PERCENT statistic preference is set to a default value and the STATISTICS_LEVEL parameter is set to TYPICAL.
Which two actions would you take to accomplish the task? (Choose two.)
A. Set the STALE_PERCENT statistic preference to a higher value than the default, and then gather statistics.
B. Set the STATISTICS_LEVEL parameter to ALL for the instance.
C. Set the INCREMENTAL preference to TRUE, and then gather statistics.
D. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE for the session in which you want to test the query.
E. Set the PUBLISH statistic preference to FALSE, and then gather statistics.
F. Set the NO_INVALIDATE statistic preference to TRUE, and then gather statistics.

Correct Answer: BE


QUESTION 2
You are administering a database that supports a DSS workload. Automatic Shared Memory Management is enabled for the database instance. Users issue
queries to perform large soft operations and complain about degraded performance of the queries. On investigation, you notice that the queries are performing
multipass work area executions and the I/O contention on one of the temporary tablespaces is very high.
Which two can be possible resolutions for this issue? (Choose two.)
A. Increase the size of the large pool.
B. Increase the value of the PGA_AGGREGATE_TARGET parameter.
C. Create a temporary tablespace group and assign it to users.
D. Increase the value of the PGA_AGGREGATE_LIMIT parameter.
E. Create another temporary tablespace and assign it to users.
F. Enable temporary undo.
Correct Answer: AD


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 4
    评论
评论 4
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值