Complete discussion of TK33

wilddog

Question 8

Buffer cache = Default + Recycle + Keep
Oracle can be 9i and 9i Release 2

Before 9i Release 2, D is wrong;
However, Oracle enhances this function in 9i Release 2.
That means what?

I guess Oracle should remove this question from exam database.

wilddog

最初由 Galahad.Wu 发布
[B]老兄，你的回答当中有很多错误哦。比如26题，TK是正确的，你的答案明显是错误的。在书中有原话的。ORACLE更宁愿维护DICTIONARY的。所以你才不太需要维护DICTIONARY，而仅仅维护LIBRARY CACHE的。

你这一张帖子很容易误导人的。 [/B]

You are correct again.
Question 26. I confuse with Oracle Algorithm and the preference performance.

wilddog

最初由 Galahad.Wu 发布
[B]还有，181中，ANALYZE是不一定会引起排序的。如果你使用ESITMATE的话，是不用排序的。只有使用COMPUTE的情况下才会因起排序的。 [/B]

Disaggree Here.

Compare B and D:

B: Execution of the ANALYZE command
I acknowledge that if you use Estimate, no sort happenes.

D: Use of insert operations involving index maintenance.
When D happens? When parallel insert only. If Oracle doesn't explictly express parallel, it always serializes.

wilddog

QUESTION NO: 186
(Choose two)
Which two statements are true regarding the use of DB_CACHE_ADVICE init.ora parameter?
A. Setting the parameter to READY reserves space in the buffer cache to store information about
different buffer cache sizes, but no CPU overhead is incurred.
B. Setting the parameter to READY reserves space in the shared pool to store information about
different buffer cache sizes, but no CPU overhead is incurred.
C. Setting the parameter to ON reserves space in the buffer cache to store information about different
buffer cache sizes, and CPU overhead is incurred as statistics are collected.
D. The V$DB_CACHE_ADVICE view contains information that predicts the estimated number of
physical reads for different cache sizes for each buffer cache setup in the SGA.
Answer: C, D

Yes, the correct answer is BD.

The key here is that DB_CACHE_ADVICE allocates the memory from Share pool, not the buffer cache.

Galahad.Wu

也许Q181 问题本身就不对吧。问问资深人员，看看他们怎么回答呢？

wilddog

1z0-033 confusing questions

QUESTION NO: 167
Which is a correct guideline for resolving wait times on the request queue when using Oracle Shared
Servers?
A. Reduce the number of dispatchers, thus reducing the requests to a number that is manageable by the shared servers.
B. Increase the size of the large pool, so that less time is spent performing I/O connected with the
session data.
C. Increase the size of the shared pool, so that less time is spent performing I/O connected with the
session data.
D. If the value of SERVERS_HIGHWATER reaches the value set for the MAX_SHARED_SERVERS
initialization parameter, consider raising the value of SHARED_SERVERS.

Answer: D

Yes. I find the exact same work from reference.

wilddog

==================================
Thanks for your correction, WU.
Have to read 2 times more for TK and maybe one more for SG.
Prepare to take the exam by next Tue.
==================================