单选题以下关于SGA和PGA的叙述正确的是()APGA是SGA的一部分,SGA是共享的,但分配后的PGA是不共享的BPGA是客户机内存的一部分,而SGA是服务器内存的一部分CPGA和SGA都是服务器内存的一部分,前者是私有的,后者是共享的DPGA与SGA的总和等于服务器主机内存的总和

单选题
以下关于SGA和PGA的叙述正确的是()
A

PGA是SGA的一部分,SGA是共享的,但分配后的PGA是不共享的

B

PGA是客户机内存的一部分,而SGA是服务器内存的一部分

C

PGA和SGA都是服务器内存的一部分,前者是私有的,后者是共享的

D

PGA与SGA的总和等于服务器主机内存的总和


参考解析

解析: 暂无解析

相关考题:

TheDBAhaschosentomanageSGAandPGAmemoryseparatelyinanOLTPdatabasebecauseofhisuniqueknowledgeoftheapplication.WhichofthesearegoodstartingpointstousewhenconfiguringthemaximumvaluesforSGAandPGA,basedontheamountofmemoryavailableonthesystem?()A.20%SGA 80%PGAB.25%SGA 75%PGAC.50%SGA 50%PGAD.75%SGA 25%PGAE.80%SGA 20%PGA

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.

In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?()A. It collects data from SGA and compares it with a preserved snapshot.B. It collects data from SGA, analyzes it, and provides a report.C. It collects data from SGA and compares it with the latest snapshot.D. It collects data from both SGA and PGA, analyzes it, and provides a report

Oracle Instance由哪两个部分组成?() A. Shared pool和Server processB. Shared pool和Background processC. SGA和user processD. PGA和user processE. SGA和Background process

以下关于SGA和PGA的叙述正确的是() A.PGA是SGA的一部分,SGA是共享的,但分配后的PGA是不共享的B.PGA是客户机内存的一部分,而SGA是服务器内存的一部分C.PGA和SGA都是服务器内存的一部分,前者是私有的,后者是共享的D.PGA与SGA的总和等于服务器主机内存的总和

You specify a nonzero value for the MEMORY_TARGET initialization parameter,but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true?()A、 The database instance starts,and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB、 The database instance starts,and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGAC、 The database instance starts,but Automatic Memory Management is disabledD、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set thePGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?()A、The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEB、The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC、The database instance starts, but Automatic Memory Management is disabledD、The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? ()A、Shared pool B、Control file C、SGA D、PGA

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

说明数据库内存结构中SGA和PGA的组成,以及这两个内存区存放信息的区别。

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

Oracle Instance由哪两个部分组成?()A、Shared pool和Server processB、Shared pool和Background processC、SGA和user processD、PGA和user processE、SGA和Background process

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

The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA,based on the amount of memory available on the system?()A、 20% SGA 80% PGAB、 25% SGA 75% PGAC、 50% SGA 50% PGAD、 75% SGA 25% PGAE、 80% SGA 20% PGA

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

问答题说明数据库内存结构中SGA和PGA的组成,以及这两个内存区存放信息的区别。

单选题Examine the parameter setting in your database: Which statement is correct about the database?()A Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not setB The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are setC The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are setD Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

单选题In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?()AIt collects data from SGA and compares it with a preserved snapshot.BIt collects data from SGA, analyzes it, and provides a report.CIt collects data from SGA and compares it with the latest snapshot.DIt collects data from both SGA and PGA, analyzes it, and provides a report

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

单选题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?()Amodify the HASH_AREA_SIZE initialization parameterBmodify the PGA_AGGREGATE_TARGET initialization parameterCmodify the WORK_AREASIZE_POLICY initialization parameterDincrease the value of the SGA_TARGET initialization parameterEincrease the value of the SGA_MAX_SIZE initialization parameterFincrease the value of the SORT_AREA_SIZE initialization parameter

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

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

单选题You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?()AThe database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZEBThe database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGACThe database instance starts, but Automatic Memory Management is disabledDThe database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

单选题The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA,based on the amount of memory available on the system?()A 20% SGA 80% PGAB 25% SGA 75% PGAC 50% SGA 50% PGAD 75% SGA 25% PGAE 80% SGA 20% PGA

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