Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）A.Run the SQL Access Advisor.B.Run the Memory Advisor for the sgaC.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

单项选择题

Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.
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

相关考题

多项选择题 WhichtwostatementsaretrueaboutsettingtheFAST_START_MTTR_TARGETinitializationparametertoanonzerovalue（）

单项选择题 Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3. It enables the loading of data from an external file into tables of an Oracle database. 4. It provides a tape backup management for the Oracle ecosystem. Which point describes the Oracle Data Pump utility（）

多项选择题 Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered. Which two statements are trueregarding the MRKT tablespace（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064

1Z0-052