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

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

PMON

B

SMON

C

MMNL

D

MMAN

E

MMON


参考解析

解析: 暂无解析

相关考题:

As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?() A. CKPTB. SMONC. MMOND. DBWR

Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?() A. ASMBB. PMONC. RBALD.SMON

Which is the memory area that is created when a dedicated server process is started, and contains data and control information for that server process?()A、SGAB、PGAC、Shared PoolD、Streams Pool

Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()A、ASMBB、PMONC、RBALD、SMON

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 statements are true regarding an Automatic Storage Management (ASM) instance? ()A、As ASM instance mounts an ASM control fileB、An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

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.

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

You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90Critical (%): 95 Which background process is responsible for issuing alerts when the threshold is crossed()A、System monitor (SMON)B、Process monitor (PMON)C、Memory manager process (MMAN)D、Manageability Monitor process (MMON)

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 of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?()A、ASMBB、PMONC、RBALD、SMON

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 is true about the Manageability Monitor (MMON) background process()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 database Instance.D、It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows: Warning (%): 90  Critical (%): 95  Which background process is responsible for issuing alerts when the threshold is crossed()A、System monitor (SMON)B、Process monitor (PMON)C、Memory manager process (MMAN)D、Manageability Monitor process (MMON)

单选题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 of a database instance,using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()A ASMBB PMONC RBALD SMON

单选题Which statement is true about the Manageability Monitor (MMON) background proces()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 databaseinstance.DIt performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.

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

单选题As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?()ACKPTBSMONCMMONDDBWR

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

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