Userscomplainabouttheslowresponsetimeofqueries.WhileinvestigatingthecauseyoufindthattheOracleInstanceisnotconfiguredtocacheallofthedatablockstosatisfytheusers’queries.WhichcomponentoftheOracleInstancewouldyouchangetoimproveperformance？（）A.Java poolB.Large poolC.Shared poolD.Streams poolE.Library cacheF.Redo log bufferG.Data dictionary cacheH.Database buffer cache

单项选择题

Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance？（）

A.Java pool
B.Large pool
C.Shared pool
D.Streams pool
E.Library cache
F.Redo log buffer
G.Data dictionary cache
H.Database buffer cache

相关考题

单项选择题 A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work. ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）

单项选择题 Youhavecreatedabaselinemetric，DISK_IO_BL，forthediskI/OmetricsinyourPRODdatabaseandyouhavebeengettingnotificationswheneverthedatabaseperformancedegrades.YouoptimizethedatabaseI/Otogaintheperformanceandyoudecidetoremovethebaselinemetrics.WhichmethodwouldyouusetoremovetheDISK_IO_BLbaselinemetrics？（）

多项选择题 Exhibit. Which two options are used to enable the connect-time failover feature？（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064

1Z0-042