單項(xiàng)選擇題

You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.
Which action would you consider to overcome the performance degradation？（）

A.Configure Java Pool to cache the java objects.
B.Configure Streams Pool to enable parallel processing.
C.Increase Shared Pool size to cache more PL/SQL objects.
D.Increase Database Buffer Cache size to increase cache hits.
E.Configure Large Pool to be used by RMAN and shared server.
F.Increase the total System Global Area （SGA） size to increase memory hits.

你可能感興趣的試題

多項(xiàng)選擇題

Which three statements are true regarding the logical structure of the Oracle database？（）

A.Each segment contains one or more extents.
B.Multiple tablespaces can share single data file.
C.A data block is the smallest unit of I/O for data files.
D.It is possible to have tablespaces of different block sizes in a database.
E.Each data block in the database always corresponds to one OS block.

多項(xiàng)選擇題

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）

A.This clause is not valid for a temporary or undo tablespace.
B.If the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.
C.The tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.
D.The tablespacelevel logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

Which three statements are true regarding the logical structure of the Oracle database？（）

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

Which three statements are true regarding the logical structure of the Oracle database？（）