Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity, resulting indegradation 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.

Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity, resulting indegradation 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.

相关考题:

Which two initialization parameters would you set to enable Automatic Shared Memory Management?() A. set SHARED_POOL_SIZE to zeroB. set STATISTICS_LEVEL to BASICC. set SGA_TARGET to a non-zero valueD. set DB_CACHE_SIZE to a non-zero valueE. set STATISTICS_LEVEL to TYPICAL or ALL

You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components?()  A、 MMANB、 PMONC、 MMOND、 MMNL

术语翻译:Weight memo()

下面对Memo组件Memo1操作正确的语句是()A、Memo1.Clear"";B、Memo1.Lines := ’ Test ’;C、Memo1.Lines.Add(123456)D、Memo1.Lines.Delete(1);

显示第一个字符为“A”的内存变量的命令是()A、LIST MEMO LIKE ?B、LIST MEMO LIKE A*C、LIST MEMO LIKE A?D、LIST MEMO

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?()A、PMONB、SMONC、MMNLD、MMANE、MMON

Which statement is true about the Manageability Monitor (MMON) background proces()A、It transfers statistics from memory to disk at regular intervals.B、It coordinates the rebalance activity for disk groups when ASM is used.C、It communicates with the Automatic Storage Management (ASM) instance on behalf of the databaseinstance.D、It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.

Which two initialization parameters would you set to enable Automatic Shared Memory Management?()A、 set SHARED_POOL_SIZE to zeroB、 set STATISTICS_LEVEL to BASICC、 set SGA_TARGET to a non-zero valueD、 set DB_CACHE_SIZE to a non-zero valueE、 set STATISTICS_LEVEL to TYPICAL or ALL

SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason?()A、The User Global Area (UGA) is not configured.B、The sessions were started using the login name SYS.C、The sessions are running in the Automatic Shared Memory Management mode.D、The sessions are running in the automatic Program Global Area (PGA) memory management mode.

You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area (SGA) are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page?() A、 Advisor CentralB、 Global AttributesC、 Resource MonitorsD、 Memory ParametersE、 Database Usage StatisticsF、 All Initialization ParametersG、 Automatic Workload Repository

A senior DBA asked you to execute the following command to improve performance: SQL ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?()A、The keep pool is not configured.B、Automatic Workarea Management is not configured.C、Automatic Shared Memory Management is not enabled.D、The data blocks in the SUBSCRIBE_LOG table are rarely accessed.E、All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view

The Automatic Shared Memory Management feature is enabled for the PROD database. Currently, a lot of insert activity is taking place in the database, and the memory structures are allocated according to the database workload. As the workload reduces, you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged?()A、 LOG_BUFFERB、 DB_CACHE_SIZEC、 JAVA_POOL_SIZED、 LARGE_POOL_SIZEE、 SHARED_POOL_SIZEF、 STREAMS_POOL_SIZE

For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()  A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above

You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()A、 log bufferB、 Java poolC、 Large poolD、 Fixed SGAE、 Shared poolF、 Streams poolG、 Keep buffer cacheH、 Database buffer cache

Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?()  A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above

In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?()  A、 Setting a nonzero value for SGA_TARGETB、 Configuring Automatic Shared Memory ManagementC、 Configuring Automatic Memory ManagementD、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE、 None of the above

单选题Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?()APMONBSMONCMMNLDMMANEMMON

单选题Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity, resulting indegradation of performance.  What would be your next step to improve performance? ()ARun the SQL Access Advisor.BRun the Memory Advisor for the sga.CRun the Memory Advisor for the pga.DRun the Memory Advisor for the shared pool.ERun the Memory Advisor for the buffer cache.

单选题In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?()A Setting a nonzero value for SGA_TARGETB Configuring Automatic Shared Memory ManagementC Configuring Automatic Memory ManagementD Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE None of the above

单选题By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?()A Automatic PGA Memory ManagementB Automatic SGA Memory ManagementC Automatic Shared Memory ManagementD Automatic Memory ManagementE Manual SGA Memory ManagementF None of the above

单选题You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components?()A MMANB PMONC MMOND MMNL

多选题Which two initialization parameters would you set to enable Automatic Shared Memory Management?()Aset SHARED_POOL_SIZE to zeroBset STATISTICS_LEVEL to BASICCset SGA_TARGET to a non-zero valueDset DB_CACHE_SIZE to a non-zero valueEset STATISTICS_LEVEL to TYPICAL or ALL

单选题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()ARun the SQL Access AdvisorBRun the Memory Advisor for the sga.CRun the Memory Advisor for the pga.DRun the Memory Advisor for the shared pool.ERun the Memory Advisor for the buffer cache

单选题For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()A Automatic PGA Memory ManagementB Automatic SGA Memory ManagementC Automatic Shared Memory ManagementD Automatic Memory ManagementE Manual SGA Memory ManagementF None of the above

单选题Which statement is true about the Manageability Monitor (MMON) background process()AIt transfers statistics from memory to disk at regular intervals.BIt coordinates the rebalance activity for disk groups when ASM is used.CIt communicates with the Automatic Storage Management (ASM) instance on behalf of the database Instance.DIt performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

单选题SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason?()AThe User Global Area (UGA) is not configured.BThe sessions were started using the login name SYS.CThe sessions are running in the Automatic Shared Memory Management mode.DThe sessions are running in the automatic Program Global Area (PGA) memory management mode.

单选题Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?()A Automatic PGA Memory ManagementB Automatic SGA Memory ManagementC Automatic Shared Memory ManagementD Automatic Memory ManagementE Manual SGA Memory ManagementF None of the above

多选题You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()Alog bufferBJava poolCLarge poolDFixed SGAEShared poolFStreams poolGKeep buffer cacheHDatabase buffer cache