单项选择题

A.Configure Java Pool to cache the java objects.B.Confi……

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.

<上一题目录下一题>

热门试题

多项选择题WhichthreestatementsaretrueregardingthelogicalstructureoftheOracledatabase？（）

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.

多项选择题WhichtwostatementsregardingtheLOGGINGclauseoftheCREATETABLESPACE...statementarecorrect？（）

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.

多项选择题InyourOracle10gdatabase，youhavescheduledajobtoupdatetheoptimizerstatisticsat05：00pmeveryFriday.Thejobhassuccessfullycompleted.Whichthreepiecesofinformationwouldyouchecktoconfirmthatthestatisticshavebeencollected？（）

A.average row size
B.last analyzed date
C.size of table in bytes
D.size of table in database blocks
E.number of free blocks in the free list
F.number of extents present in the table

多项选择题The following are the details of your database： Instance name：test Host name：tech1.us.oracle.com IP address：145.33.230.186 Enterprise Manager Console HTTP Port number：5500 You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control？（）

A.http：//145.33.230.186：5500/em
B.http：//www.145.33.230.186：5500/em
C.http：//tech1.us.oracle.com：5500/em
D.http：//test.145.33.230.186：5500/em
E.http：//test.tech1.us.oracle.com：5500
F.http：//www.tech1.us.oracle.com：5500/em
G.http：//test.tech1.us.oracle.com：5500/em

单项选择题Youfindtoday’sperformanceofyourproductiondatabasetobethebestever.Therefore，youwanttobenotifiedinthefuturewhenevertheperformancedegradesby10%oftoday’sperformance.Whatisthefirststepthatyouwouldtaketoensurethis？（）

A.create baseline metrics for today’s performance
B.write the current database metrics to a database table and create a trigger to compare with future database statistics
C.write the current database metrics to a flat file and create an operating script to compare with future database statistics
D.write the current database metrics to a database table and create a procedure to compare with future database statistics
E.write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics