itgle.com

单选题When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）AThe V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETBThe V$PGA_TARGET_ADVIC

题目
单选题
When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）
A

 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET

B

 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET

C

 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management

D

 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management

相似考题

1.Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters？（） A、 SORT_AREA_SIZEB、 HASH_AREA_SIZEC、 BITMAP_MERGE_AREA_SIZED、 CREATE_BITMAP_AREA_SIZEE、 PGA_AGGREGATE_TARGET

2.Which statement about Automatic Memory Management with Oracle 11g is true？（）  A、 You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or  PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.B、 Oracle can reallocate memory between the SGA and PGA automatically as needed.C、 To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D、 You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

3.View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）A、The database instance is running with manual PGA management.B、The database instance is running with manual shared memory management.C、The database instance has the MEMORY_TARGET value set to a nonzero value.D、All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed

4.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 parameterB、modify the PGA_AGGREGATE_TARGET initialization parameterC、modify the WORK_AREASIZE_POLICY initialization parameterD、increase the value of the SGA_TARGET initialization parameterE、increase the value of the SGA_MAX_SIZE initialization parameterF、increase the value of the SORT_AREA_SIZE initialization parameter

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）A  The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB  The V$PGA_TARGET_A”相关问题

  • 第1题：

    You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）

    • A、Set MEMORY_TARGET to zero
    • B、Set the STATISTICS_LEVEL parameter to BASIC
    • C、Set the WORKAREA_SIZE_POLICY parameter to MANUAL
    • D、Set the PGA_AGGREGATE_TARGET parameter to nonzero value

    正确答案:D

  • 第2题：

    You have included the following parameter setting in your server parameter file：       PGA_AGGREGATE_TARGET = 800M        SORT_AREA_SIZE = 100M        HASH_AREA_SIZE = 100M        BITMAP_MERGE_AREA_SIZE = 100M        CREATE_BITMAP_AREA_SIZE = 100M   Which statement is true？（）  

    • A、 All the *_AREA_SIZE parameters are ignored.
    • B、 The Automatic PGA Memory Management feature cannot be disabled.
    • C、 The total Program Global Area （PGA） memory cannot be manually increased above 800M.
    • D、 The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.

    正确答案:A

  • 第3题：

    For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

    • A、 Automatic PGA Memory Management
    • B、 Automatic SGA Memory Management
    • C、 Automatic Shared Memory Management
    • D、 Automatic Memory Management
    • E、 Manual SGA Memory Management
    • F、 None of the above

    正确答案:D

  • 第4题：

    Which three statements are true about Automatic Workload Repository (AWR)?（）

    • A、All AWR tables belong to the SYSTEM schema.
    • B、The AWR data is stored in memory and in the database.
    • C、The snapshots collected by AWR are used by the self-tuning components in the database
    • D、AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
    • E、AWR contains system wide tracing and logging information.

    正确答案:B,C,E

  • 第5题：

    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 Management
    • B、 Automatic SGA Memory Management
    • C、 Automatic Shared Memory Management
    • D、 Automatic Memory Management
    • E、 Manual SGA Memory Management
    • F、 None of the above

    正确答案:C

  • 第6题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第7题：

    单选题
    View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）
    A

    The database instance is running with manual PGA management.

    B

    The database instance is running with manual shared memory management.

    C

    The database instance has the MEMORY_TARGET value set to a nonzero value.

    D

    All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    Which statement about Automatic Memory Management with Oracle 11g is true？（）
    A

     You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or  PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.

    B

     Oracle can reallocate memory between the SGA and PGA automatically as needed.

    C

     To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

    D

     You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）
    A

     Set MEMORY_TARGET to zero

    B

     Set the STATISTICS_LEVEL parameter to BASIC

    C

     Set the WORKAREA_SIZE_POLICY parameter to MANUAL

    D

     Set the PGA_AGGREGATE_TARGET parameter to nonzero value


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）
    A

     Automatic PGA Memory Management

    B

     Automatic SGA Memory Management

    C

     Automatic Shared Memory Management

    D

     Automatic Memory Management

    E

     Manual SGA Memory Management

    F

     None of the above


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    Which statement about Automatic Memory Management with Oracle 11g is true?（）
    A

    You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.

    B

    Oracle can reallocate memory between the SGA and PGA automatically as needed.

    C

    To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

    D

    You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:B,D

  • 第14题：

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

    • A、 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET
    • B、 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET
    • C、 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management
    • D、 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management

    正确答案:A

  • 第15题：

    Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）  

    • A、 Automatic PGA Memory Management
    • B、 Automatic SGA Memory Management
    • C、 Automatic Shared Memory Management
    • D、 Automatic Memory Management
    • E、 Manual SGA Memory Management
    • F、 None of the above

    正确答案:D

  • 第16题：

    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

    正确答案:B

  • 第17题：

    单选题
    You want to enable automatic PGA memory management in your database. Which setting is required toachieve this?（）
    A

    Set MEMORY_TARGET to zero

    B

    Set the STATISTICS_LEVEL parameter to BASIC

    C

    Set the WORKAREA_SIZE_POLICY parameter to MANUAL

    D

    Set the PGA_AGGREGATE_TARGET parameter to nonzero value


    正确答案： A
    解析： 暂无解析

  • 第18题：

    多选题
    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.


    正确答案： A,B
    解析： 暂无解析

  • 第19题：

    单选题
    You have included the following parameter setting in your server parameter file：       PGA_AGGREGATE_TARGET = 800M        SORT_AREA_SIZE = 100M        HASH_AREA_SIZE = 100M        BITMAP_MERGE_AREA_SIZE = 100M        CREATE_BITMAP_AREA_SIZE = 100M   Which statement is true？（）
    A

     All the *_AREA_SIZE parameters are ignored.

    B

     The Automatic PGA Memory Management feature cannot be disabled.

    C

     The total Program Global Area （PGA） memory cannot be manually increased above 800M.

    D

     The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    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 Management

    B

     Automatic SGA Memory Management

    C

     Automatic Shared Memory Management

    D

     Automatic Memory Management

    E

     Manual SGA Memory Management

    F

     None of the above


    正确答案： C
    解析： 暂无解析

  • 第21题：

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

     The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET

    B

     The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET

    C

     The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management

    D

     The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management


    正确答案： B
    解析： 暂无解析

  • 第22题：

    多选题
    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


    正确答案： B,A
    解析： 暂无解析

  • 第23题：

    单选题
    Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）
    A

     Automatic PGA Memory Management

    B

     Automatic SGA Memory Management

    C

     Automatic Shared Memory Management

    D

     Automatic Memory Management

    E

     Manual SGA Memory Management

    F

     None of the above


    正确答案： C
    解析： 暂无解析

  • 第24题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

相关内容