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
题目
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.
相似问题和答案
第1题：
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.
第2题：
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$W0041ITS
- D、V$WAITSTAT
- E、V$SESSION_LONGOPS
正确答案:E
第3题：
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、itself
B、yourself
C、himself
D、themselves
第4题：
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$WAITS
- D、 V$WAITSTAT
- E、 V$SESSION_LONGOPS
正确答案:E
第5题：
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.
正确答案:B
第6题：
B.late
C.lately
D.latest
第7题：
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_DETAILS
- B、 DBA_SCHEDULER_RUNNING_JOBS
- C、 DBA_SCHEDULER_JOBS
- D、 DBA_SCHEDULER_JOB_LOG
正确答案:C
第8题：
We are confident that you will find _____ ready market for the item ______ your end.
A、/; at
B、a; by
C、a; at
D、some; by
第9题：
If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）
- A、V_CONTROLFILE_RECORD_SECTION
- B、V_CONTROLFILE
- C、V$PARAMETER
- D、init.ora file
正确答案:A
第10题：
Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）
- A、V$LOG
- B、V$LOFHIST
- C、V$LOGFILE
- D、V$LOG_HISTORY
正确答案:A