Using Oracle Enterprise Manager to set SGA pool values manua

题目
多选题
Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately?()
A

DB_CACHE_SIZE

B

SHARED_POOL_SIZE

C

LARGE_POOL_SIZE

D

JAVA_POOL_SIZE

E

SGA_MAX_SIZE

F

SORT_AREA_SIZE

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Oracle Instance由哪两个部分组成?()

A. Shared pool和Server process

B. Shared pool和Background process

C. SGA和user process

D. PGA和user process

E. SGA和Background process


参考答案:E

第2题:

You work as a database administrator for Certkiller .com. You want to administer your database servers,which are running on different host machines,using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()

  • A、Application Server Control
  • B、Oracle Management Service
  • C、Oracle Enterprise Manager Repository
  • D、Oracle Enterprise Manager Database Control

正确答案:C,D

第3题:

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

第4题:

In an Oracle 10g database, the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics?() 

  • A、recovery catalog
  • B、Oracle Enterprise Manager Repository
  • C、Automatic Workload Repository (AWR)
  • D、Oracle 10g Enterprise Manager Grid Control
  • E、Automatic Database Diagnostic Monitor (ADDM)

正确答案:C

第5题:

You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?()

  • A、SQL*Plus
  • B、iSQL*Plus
  • C、Management Server
  • D、Management Repository
  • E、Oracle Enterprise Manager 10g Database Control

正确答案:E

第6题:

Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately?() 

  • A、 DB_CACHE_SIZE
  • B、 SHARED_POOL_SIZE
  • C、 LARGE_POOL_SIZE
  • D、 JAVA_POOL_SIZE
  • E、 SGA_MAX_SIZE
  • F、 SORT_AREA_SIZE

正确答案:A,B

第7题:

在ORACLE10G中,()参数的调整需要重启数据库才能生效。

  • A、SGA_MAX_SIZE
  • B、SGA_TARGET
  • C、SHARED_POOL_SIZE
  • D、DB_CAHCHE_SIZE

正确答案:A

第8题:

WhenmanuallyconfiguringtheSGA,whichofthefollowingparameterchangesrequiresaninstancerestarttotakeeffect?()"FirstTest,FirstPass"-www.lead2pass.com97Oracle1Z0-053Exam

A.DB_CACHE_SIZE

B.SHARED_POOL_SIZE

C.LARGE_POOL_SIZE

D.JAVA_POOL_SIZE

E.SGA_MAX_SIZE

F.SORT_AREA_SIZE


参考答案:E

第9题:

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 Central
  • B、 Global Attributes
  • C、 Resource Monitors
  • D、 Memory Parameters
  • E、 Database Usage Statistics
  • F、 All Initialization Parameters
  • G、 Automatic Workload Repository

正确答案:A,C

第10题:

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

正确答案:B

更多相关问题