单选题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？（）AJava poolBLarge poolCShared poolDStreams poolELibrary cacheFRedo log bufferGData dictionary cacheHDatabase 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
参考解析
解析：
暂无解析
相关考题：
In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）A. It collects data from SGA and compares it with a preserved snapshot.B. It collects data from SGA, analyzes it, and provides a report.C. It collects data from SGA and compares it with the latest snapshot.D. It collects data from both SGA and PGA, analyzes it, and provides a report
You are the network administrator of a Layer 3 switched network. Users in one VLAN are complaining thataccess to the server VLAN is very slow from time to time. Traffic in the local VLAN works without any issue，and users in other VLANs do not have any complaint to reach the server VLAN. What is most likely thecause of this issue？（）A、routing issueB、denial-of-service attackC、MAC floodingD、spanning-tree recalculationE、Layer 2 loopF、ARP spoofing attack
A 4-way x445 server with 2GB of memory running Windows 2003 Server with Exchange 2003 is performing poorly. Users are complaining of slow response times when accessing their email. Which subsystem should be checked first as a potential bottleneck？（）A、ProcessorsB、Memory subsystemC、Storage subsystemD、Network connectivity
A system has users doing interactive work while background jobs are running. Interactive users are requesting that system response time be improved for foreground processes. Which tuning parameters should be changed to accomplish this？（）A、 schedtune -hB、 schedtune -rC、 vmtune -fD、 schedtune -w
Companycom has just installed a p5 595 with four uncapped LPARs in a shared processor pool. The system and profile settings are still in their default states. One of the LPARs has an application that is consuming all of the available shared processor resources. Users of this application are complaining about response time. Which of the following changes to the slow LPAR would improve response time?（）A、Enable SMTB、Reduce the weightC、Renice the processD、Increase the weight
Users complain an AIX server is running slow. Which of the following commands can be run to determine what is consuming systems resources？（）A、 tprofB、 lpstatC、 ps auxD、 entstat
Companycom is using shared processor LPARs exclusively, including the Virtual IO Server. The users are complaining about response time. The application LPARs can be heavy processor users. The Virtual IO Server has been measured to be processor constrained. How should the Virtual IO Server's shared processor LPAR be configured?（）A、Capped and with a lower shareB、Uncapped and with a lower shareC、Uncapped and with a higher shareD、Capped and with no change in share
You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）A、The trace fileB、The fixed viewsC、The data dictionary viewsD、The operating system log fieldsE、The dynamic performance views.
单选题Users complain an AIX server is running slow. Which of the following commands can be run to determine what is consuming systems resources？（）A tprofB lpstatC ps auxD entstat
单选题A system has users doing interactive work while background jobs are running. Interactive users are requesting that system response time be improved for foreground processes. Which tuning parameters should be changed to accomplish this？（）A schedtune -hB schedtune -rC vmtune -fD schedtune -w
单选题You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）AIncrease the undo returnBCreate more undo segmentsCCreate another undotablespaceDIncrease the size of the undotablespace
单选题Users in your PROD database complain about the slow response of the transactions. While investigating the reason， you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）Aincrease the undo retentionBcreate more undo segmentsCcreate another undo tablespaceDincrease the size of the undo tablespace
单选题Due to slow response times， a customer purchased additional memory. After the memory was installed，response time was not improved. They complained to the pSeries technical specialist. Which of the following questions should be asked of this customer？（）AWho recommended the memory purchase？BHave more users been added since the memory purchase？CWhy were additional CPUs not ordered at the same time as the memory？DDid a performance analysis of peak periods show a memory bottleneck？
单选题A system administrator periodically receives calls from users who complain about poor performance with their application. Use the following sar command output to answer the question： Which of the following system resources need more investigation？（）A CPUsB DiskC MemoryD NetworkX
单选题You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）AIncrease the undo returnBCreate more undo segmentsCCreate another undotablespaceDIncrease the size of the undo tablespace
单选题In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）AIt collects data from SGA and compares it with a preserved snapshot.BIt collects data from SGA, analyzes it, and provides a report.CIt collects data from SGA and compares it with the latest snapshot.DIt collects data from both SGA and PGA, analyzes it, and provides a report
多选题You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer. Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance？（）AIncrease the size of redo log filesBIncrease the size of redo log bufferCIncrease the number of redo log filesDPlace the redo log files on a separate diskEDecrease the number of redo log groups to twoFIncreate the number Log Writer （LGWR） process
单选题You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）A The index can be changed from NOLOGGING to LOGGINGB The index cannot be recovered even in the ARCHIVELOG mode.C The index can only be created if the base table is created with the NOLOGGING option.D The index can be recovered if you perform a backup after the CREATE INDEX statement.
单选题For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）A Set the CPU time per call in the users profile.B Set the CPU time per session in the users profile.C Set the CPU levels for the user’s group using Resource Manager.D Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
单选题You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）AThe trace fileBThe fixed viewsCThe data dictionary viewsDThe operating system log fieldsEThe dynamic performance views.
单选题From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）Aset the CPU time per call in the users profileBset the CPU time per session in the users profilesCset the CPU levels for the users’ group using Resource ManagerDset the TIMED_STATISTICS parameter to TRUE in the parameter file
单选题The main idea of Paragraph Three is that ______.Amost people feel life is easyBthe writer feels life is easyCthe writer likes to complain about his problemsDmost people complain about how hard their lives are
填空题My mother did nothing but (complain) ____ about it all the time when she was here.