Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would…

The correct answer is B. Run the Memory Advisor for the shared pool. https://blogs.oracle.com/oraclemagazine/using-database-advisors The shared pool advisor provides information about the estimated parse time in the shared pool for different pool sizes, the buffer cache advisor provides information about physical reads and time for the cache…

Manage Database Performance

Question

Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?

Options

ARun the SQL Access Advisor.
BRun the Memory Advisor for the shared pool.
CRun the SQL Tunning Advisor.
DRun the Memory Advisor for the Program Global Area.
ERun the Memory Advisor for the System Global Area.

How the community answered

(42 responses)

A
14% (6)
B
71% (30)
C
2% (1)
D
7% (3)
E
5% (2)

Explanation

https://blogs.oracle.com/oraclemagazine/using-database-advisors The shared pool advisor provides information about the estimated parse time in the shared pool for different pool sizes, the buffer cache advisor provides information about physical reads and time for the cache size, and the PGA advisor provides information about cache hit percentage against PGA target memory size.

Topics

#hard parse#shared pool#Memory Advisor#SGA tuning

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice