单选题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 s

题目

单选题

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

Set the CPU time per call in the users profile.

Set the CPU time per session in the users profile.

Set the CPU levels for the user’s group using Resource Manager.

Set the TIMED_STATISTICS parameter to TRUE in the parameter file.

参考答案和解析

正确答案： C

解析：暂无解析

如果没有搜索结果，请直接联系老师获取答案。

更多相关问题

相关问题 1：

You will find as you read this book that you just can't keep some of these stories to ___. You will want to share them with a friend.A、itselfB、yourselfC、himselfD、themselves

点击查看答案
相关问题 2：

We are confident that you will find _____ ready market for the item ______ your end.A、/; atB、a; byC、a; atD、some; by

点击查看答案
相关问题 3：

A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）A. Execute the query and view Active Session History (ASH) for information about the query.B. Enable SQL trace for the query.C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

点击查看答案
相关问题 4：

You can find it in our____brochure, along with some of our other models.A.last B.late C.lately D.latest

点击查看答案
相关问题 5：

What view might you use to try to determine how long a particular backup will take?（）A、V$SESSION_EVENT B、V$SESSION C、V$W0041ITSD、V$WAITSTAT E、V$SESSION_LONGOPS

点击查看答案
相关问题 6：

You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_JOBSD、 DBA_SCHEDULER_JOB_LOG

点击查看答案
相关问题 7：

You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.

点击查看答案

CMS专题

单选题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 s

题目

参考答案和解析

更多相关问题

相关问题 1：

相关问题 2：

相关问题 3：

相关问题 4：

相关问题 5：

相关问题 6：

相关问题 7：

相关内容