ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-052 All Questions

View all questions & answers for the 1z0-052 exam
Go to Exam

Exam 1z0-052 topic 1 question 61 discussion

Actual exam question from Oracle's 1z0-052
Question #: 61
Topic #: 1
[All 1z0-052 Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
Using the Memory Advisor through OEM
The Memory Advisor can be used only when the automatic memory management (AMM) feature is disabled. The Memory Advisor has three advisors that give recommendations on: the Shared Pool in the SGA, the Buffer Cache in the SGA, and the PGA.
by thuthuysphn58 at April 4, 2025, 7:19 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago