When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）  

相似题目

• The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）

  A . statistics recommendations B . SQL Profile recommendations C . Index-related recommendations D . restructuring of SQL recommendatio

  查看最佳答案

• Your database is running on the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）

  A .  modify the HASH_AREA_SIZE initialization parameter B .  modify the PGA_AGGREGATE_TARGET initialization parameter C .  modify the WORK_AREASIZE_POLICY initialization parameter D .  increase the value of the SGA_TARGET initialization parameter E .  increase the value of the SGA_MAX_SIZE initialization parameter F .  increase the value of the SORT_AREA_SIZE initialization parameter

  查看最佳答案

• When BGP tuning is used， how is packet flow into the e-commerce module controlled？（）

  A . by tracking the status of objects along the path to the e-commerce module B . by detecting undesirable conditions along the path to the e-commerce module C . by using the MED to communicate the site preferences for traffic to multiple ISPs D . by communicating the available prefixes， routing policies， and preferences of each site to its ISP E . by moving the SLB to a position where selected traffic to and from the servers does not go through the SLB

  查看最佳答案

• When may the automatic identification system (AIS) be switched off? （）

  A . At anytime as long as it is properly logged B . At the Master's professional judgment C . Only when the vessel is at anchor or in port D . Under no circumstance

  查看最佳答案

• You are tuning RMAN to optimize performance.You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?（）

  A . Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE B . Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE C . Use compression when performing tape backups D . Configure multiple SBT channel

  查看最佳答案

• You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode.   Which two statements are correct in this scenario？（）

  A . The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO. B . The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas. C . Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management. D . The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

  查看最佳答案

• You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）

  A .  The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO. B .  The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas. C .  Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management. D .  The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

  查看最佳答案

• Which parameter can be tuned to affect the selection of a static route as a backup.when a dynamic protocol is also being used?（）

  A . link bandwidth B . hop count C . link cost D . administrative distance E . link delay

  查看最佳答案

• What stanza file does a system administrator view to determine what kernel-tuning parameter changes were made when the system was last booted？（）

  A . /etc/rc.net B . /etc/tunables/tuning C . /etc/tunables/lastboot D . /usr/samples/kernel/nextboot

  查看最佳答案

• You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）

  A .  log buffer B .  Java pool C .  Large pool D .  Fixed SGA E .  Shared pool F .  Streams pool G .  Keep buffer cache H .  Database buffer cache

  查看最佳答案

• Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）

  A .  SQL statements that are part of the AWR baseline only B .  SQL statements based on the AWR top SQL identification C .  SQL statements that are part of the available SQL Tuning Set （STS） only D .  SQL statements that are available in the cursor cache and executed by a user other than SYS

  查看最佳答案

• Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters？（） 

  A .  SORT_AREA_SIZE B .  HASH_AREA_SIZE C .  BITMAP_MERGE_AREA_SIZE D .  CREATE_BITMAP_AREA_SIZE E .  PGA_AGGREGATE_TARGET

  查看最佳答案

• View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?（）https://assets.asklib.com/images/image2/201808021408025170.png

  A . Accept the recommended SQL profile. B . Collect statistics for the related objects. C . Run the Access Advisor for the SQL statement. D . Run the Segment Advisor for recommendations.

  查看最佳答案

• Which statement is true when you run the SQL Tuning Advisor with limited scope？（）

  A . Access path analysis is not performed for the SQL statements. B . SQL structure analysis is not performed for the SQL statements. C . SQL Profile recommendations are not generated for the SQL statements. D . The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

  查看最佳答案

• Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas.  What would you do？（）

  A . modify the HASH_AREA_SIZE initialization parameter B . modify the PGA_AGGREGATE_TARGET initialization parameter C . modify the WORK_AREASIZE_POLICY initialization parameter D . increase the value of the SGA_TARGET initialization parameter E . increase the value of the SGA_MAX_SIZE initialization parameter F . increase the value of the SORT_AREA_SIZE initialization parameter

  查看最佳答案

• In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）  

  A .  Setting a nonzero value for SGA_TARGET B .  Configuring Automatic Shared Memory Management C .  Configuring Automatic Memory Management D .  Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET E .  None of the above

  查看最佳答案

• To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）  

  A .  EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor B .  EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor C .  EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor D .  Either B or C E .  All of the above

  查看最佳答案

• The SQL Tuning Advisor configuration has default settings in your database instance.  Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）

  A .  statistics recommendations B .  SQL Profile recommendations C .  Index-related recommendations D .  restructuring of SQL recommendatio

  查看最佳答案

• Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）

  A . SQL statements that are part of the AWR baseline only  B . SQL statements based on the AWR top SQL identification C . SQL statements that are part of the available SQL Tuning Set (STS) only  D . SQL statements that are available in the cursor cache and executed by a user other than SYS&e

  查看最佳答案

• Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）

  A . LOG_BUFFER B . SORT_AREA_SIZE C . JAVA_POOL_SIZE D . STREAMS_POOL_SIZE E . DB_16K_CACHE_SZIE F . DB_KEEP_CACHE_SIZE

  查看最佳答案

• What happens when you run the SQL Tuning Advisor with limited scope?（）

  A . Access path analysis is not performed for SQL statements. B . SQL structure analysis is not performed for SQL statements. C . SQL Profile recommendations are not generated for SQL statements. D . Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.

  查看最佳答案

• Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window？（）

  A .  generating the SQL profile B .  testing and accepting the SQL profile C .  generating a list of candidate SQLs for tuning D .  adding tuned SQL plans into the SQL plan baseline E .  tuning each SQL statement in the order of importance  F .  generating baselines that include candidate SQLs for tuning

  查看最佳答案

• Which statement is true when Automatic Workload Repository （AWR） baselines are created using baseline templates？（）  

  A .  AWR baselines are always created as repeating baselines. B .  AWR baselines can be created on the basis of two time values. C .  AWR baselines are always created with infinite expiration duration. D .  AWR baselines are always created using the Automatic Workload Repository （AWR） retention period as expiration duration.

  查看最佳答案