Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Oracle Exam 1Z0-084 Topic 15 Question 11 Discussion

Actual exam question for Oracle's 1Z0-084 exam
Question #: 11
Topic #: 15
[All 1Z0-084 Questions]

A database instance is suffering poor I/O performance on two frequently accessed large tables.

No Big Table caching occurs in the database.

Examine these parameter settings:

Which are two actions either one of which will allow Big Table caching to occur?

Show Suggested Answer Hide Answer
Suggested Answer: C, D

Big Table caching is a feature that allows frequently accessed large tables to be cached in memory to improve I/O performance. From the parameter settings provided, Big Table caching is not occurring because DB_BIG_TABLE_CACHE_PERCENT_TARGET is set to 10, which is the minimum threshold for enabling the feature, but the size of the cache is too small for the big tables to be effectively cached.

To enable Big Table caching, one of the following actions could be taken:

C (Correct): Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 25. This action would allocate a larger percentage of the buffer cache for storing big tables, which could allow for caching large tables and thus improve I/O performance.

D (Correct): Increasing DB_CACHE_SIZE to 1G. Since the size of the buffer cache is a determining factor for how much data can be cached, increasing this parameter would provide more memory space for big tables to be cached.

Options A, B, E, and F will not enable Big Table caching because:

A: Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to 50 without adjusting the overall size of the cache might still not be sufficient if the DB_CACHE_SIZE is not large enough to hold the big tables.

B: Setting DB_KEEP_CACHE_SIZE to at least 50M only specifies a separate buffer pool for objects with the KEEP cache attribute and does not affect Big Table caching.

E: and F: Changing the PARALLEL_DEGREE_POLICY to ADAPTIVE or AUTO influences the behavior of parallel execution but does not directly enable or influence Big Table caching.


Oracle Database Performance Tuning Guide: Big Table Caching

Oracle Database Reference: DB_BIG_TABLE_CACHE_PERCENT_TARGET

Oracle Database Reference: DB_CACHE_SIZE

Contribute your Thoughts:

Makeda
6 months ago
I disagree, I believe setting DB_KEEP_CACHE_SIZE to at least 50M is the better option.
upvoted 0 times
...
Nohemi
6 months ago
I think increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 50 will help.
upvoted 0 times
...
Chery
6 months ago
This question is a real head-scratcher! I mean, who comes up with these exam questions anyway? They're like trying to solve a Rubik's cube with one hand tied behind your back.
upvoted 0 times
...
Eura
6 months ago
Hmm, I'm not sure about this one. Shouldn't we also consider increasing the DB_CACHESIZE to 1 GB? That might help with the I/O performance too.
upvoted 0 times
Shannon
5 months ago
I agree with both suggestions. Let's try increasing both parameters and see if it helps.
upvoted 0 times
...
Elza
6 months ago
What about setting DB_CACHESIZE to 1 G? That might also improve the performance.
upvoted 0 times
...
Arlette
6 months ago
I think increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 50 could help.
upvoted 0 times
...
...
Barrie
7 months ago
I think the correct answer is A and C. Increasing the DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 50 and 25 should allow Big Table caching to occur.
upvoted 0 times
Kerry
5 months ago
I think setting PARALLEL_DEGREE_POLICYAUTO could also improve performance.
upvoted 0 times
...
Alita
5 months ago
I agree, increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 50 and 25 should help with Big Table caching.
upvoted 0 times
...
Candida
6 months ago
I agree, increasing the DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 50 and 25 should help with Big Table caching.
upvoted 0 times
...
Marge
6 months ago
I think the correct answer is A and C.
upvoted 0 times
...
Jodi
6 months ago
I think setting DB_KEEP_CACHE_SIZE to at least 50M could also improve the caching performance.
upvoted 0 times
...
Lang
6 months ago
I agree, increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 50 and 25 should help with Big Table caching.
upvoted 0 times
...
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77