Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity. Which action generates recommendations to overcome the performance issues?
A.
running the Memory Advisor for the buffer cache
B.
running the Memory Advisor for the library cache
Memory Advisors
Memory Advisor
SGA Advisor
Buffer Cache Advisor
PGA Advisor
The Memory Advisors provide graphical analyses of total memory target settings, SGA and PGA target settings, or SGA component size settings. You use these analyses to tune database performance and for what-if planning. Depending on the current memory management mode, different memory advisors are available.
If Automatic Memory Management is enabled, the Memory Advisor is available. This advisor provides advice for the total memory target for the instance.
If Automatic Shared Memory Management is enabled, then the SGA Advisor and PGA Advisor are available.
If Manual Shared Memory Management and Automatic PGA Memory are enabled, then the Buffer Cache Advisor and PGA Advisor are available.
So, correct answer should be C
https://docs.oracle.com/database/121/ADMQS/GUID-8DE70F1D-E161-45D2-BE01-E9972883BCEC.htm#ADMQS1031
The Library Cache is a piece of memory within the SGA that Oracle uses in order to store SQL Statements. ... In a similar way, the Library Cache also caches PL/SQL Statements and Objects. The Library Cache was introduced because parsing
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.
rdnkrkmz
Highly Voted 5 years, 10 months agosoniat
3 years, 9 months agorcgenilo27
Highly Voted 5 years, 2 months agohggz
Most Recent 4 years, 3 months agoNorthKorean
4 years, 8 months agosherifelia
5 years ago