Oracle Exam 1Z0-902 Topic 3 Question 41 Discussion

Actual exam question for Oracle's 1Z0-902 exam

Question #: 41
Topic #: 3

[All 1Z0-902 Questions]

Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?

APMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary

BPMEM Pool Misses in the Exadata Outlier Summary

Ccell PMEM cache Read Hits in the Database IOs portion of the Performance Summary

DPMEM Cache section within Memory Statistics

EPMEM Cache section within Exadata Smart Statistics

Show Suggested Answer

Suggested Answer: D

According to Oracle's documentation1, to set a threshold for a metric on a database server, you need to use thecreate thresholdcommand with the appropriate parameters.Theset thresholdcommand is used to modify an existing threshold2.

Therefore, the command that you should use to generate alerts for such an event is:

dbmcli -e ''create threshold ds_temp comparison='>', critical=30'' on each database server1

by Sheridan at May 19, 2024, 04:51 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-902 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Chantell

1 months ago

I heard the exam writers were so tired of students acing the PMEM questions that they decided to make this one a real 'persistent' memory test!

upvoted 0 times

Dong

19 days ago

A) PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary

upvoted 0 times

...

Regenia

1 months ago

Oh man, this is a tough one. I'm going to guess B and E - the PMEM Pool Misses and the PMEM Cache section within Exadata Smart Statistics. Gotta love these Exadata curveballs!

upvoted 0 times

...

Haha, I bet the exam writers are trying to trip us up with all these tricky Exadata-specific terms. But I'm going to go with A and D - the PMEM Pool cache Read Hits and the PMEM Cache section seem like the best bets.

upvoted 0 times

Della

12 days ago

Let's go with A and D then, they seem like the most logical choices based on the terms mentioned.

upvoted 0 times

...

Aaron

17 days ago

I agree, those sections definitely sound like they would contain the information we're looking for.

upvoted 0 times

...

Estrella

20 days ago

I think you're right, A and D seem like the most relevant sections for X9M Persistent Memory Cache statistics.

upvoted 0 times

...

Vallie

1 months ago

I'm going with C and D. The Database IOs portion and the dedicated PMEM Cache section seem like the most likely places to find these statistics.

upvoted 0 times

...

2 months ago

I think the answer is A) PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary.

upvoted 0 times

...