【单选题】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, an...
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.
【简答题】Complete the following passage with words chosen from this unit. The initial letter of each is given. What is a Type A workaholic? Phil was a typical case in point. He worked six days a week and didn’...
【判断题】Professor Lee is talking with a group of students from Yizhou High School. Now Li Hua is asking a question and Professor Lee is answering. Li Hua: When I hang out with American friends, I’m always a...
【简答题】Complete the following sentences with theappropriate forms of the words given. Pay attention to the part of speech of the word you use. 1) empty a. I __ _1_ __ out my bag to find my keys. b. The isola...