You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The tab

题目

You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?（）

A、Increase the value of table_definition_cache
B、Increase the value of table_open_cache_instances
C、Decrease the value of table_open_cache_instances
D、Increase the value of table_open_cache
E、Decrease the value of table_definition_cache
F、Decrease the value of table_open_cache

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

相似问题和答案

第1题：

We are（）how an error like this could have happened.

A、searching
B、researching
C、surveying
D、investigating

正确答案:D

第2题：

单选题

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？（）

Increase the undo return

Create more undo segments

Create another undotablespace

Increase the size of the undotablespace

正确答案： D

解析：暂无解析

第3题：

You are investigating routing problems on a device running the Junos OS. You receive the error shown in the exhibit when you attempt to restart the routing process.Which statement describes the problem?（）

A. You have typed an invalid command.

B. You must be in configuration mode to restart the routing process.

C. You do not have permission to restart the routing process.

D. You must wait until close of business to restart the routing process, based on user-defined policy.

参考答案：C

第4题：

单选题

In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrees when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）

Export and import the mapping table.

Drop and re-create the mapping table.

Truncate the mapping table and reinsert the values.

Use the ALTER TABLE .. REBUILD command to defragment the mapping table.

正确答案： B

解析：暂无解析

第5题：

单选题

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？（）

Java pool

Large pool

Shared pool

Streams pool

Library cache

Redo log buffer

Data dictionary cache

Database buffer cache

正确答案： H

解析：暂无解析

第6题：

Users at the Charleville Company began experiencing high network delays when Internet connectivity was enabled for all users. After investigating the traffic flow, you determine that peerto-peer traffic from a music download site is consuming a large amount of bandwidth. Which QoS mechanism can you implement to improve the network response time?（）

A、Use CBWFQ to queue the peer-to-peer traffic into the default traffic class.
B、Use class-based WRED to randomly drop the peer-to-peer traffic during network congestions.
C、Use class-based policing to limit the peer-to-peer traffic rate.
D、Use class-based shaping to delay any excessive peer-to-peer traffic. Answer: C

正确答案:C

第7题：

单选题

In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated. How do you achieve this objective？（）

by setting the SQL_TRACE parameter to FALSE in the parameter file

by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session

by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session

by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

正确答案： A

解析：暂无解析

第8题：

Due to a recent increase in administrative errors, we are writing to remind you of the process for investigating any suspected discrepancy on your service bill. Please contact the customer service department in writing within 60 days of receiving the bill. In order to avoid fate fees and possi-ble42of your service, you must still pay undisputed portions of the statement by the due date.
Proteus Sat43 every effort to resolve any claims in a timely manner, and to the mutual sat-isfaction.
阅读以上短文，回答191-192题。

第42题答案是__________

A.interrupted
B.to interrupt
C.interruption
D.interruptive

答案：C

解析：

本题选择打扰的名词形式。

第9题：

单选题

You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？（）

Memory Advisor

Segment Advisor

SQL Tuning Advisor

SQL Access Advisor

Automatic Database Diagnostic Monitor （ADDM）

正确答案： B

解析：暂无解析

第10题：

单选题

In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）

export and import the mapping table

drop and re-create the mapping table

truncate the mapping table and reinsert the values

use the ALTER TABLE···REBUILD command to defragment the mapping table

正确答案： D

解析：暂无解析

You are investigating the perfo

题目

相似问题和答案

更多相关问题

相关内容