网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
Inordertodeterminehowefficientlyanapplicationisreadingandwritingdata,whichofthefollowingutilitieswillreportreadandwritesizesondiskI/Orequests?()
A.tprof
B.iostat
C.svmon
D.filemon
参考答案
更多 “ Inordertodeterminehowefficientlyanapplicationisreadingandwritingdata,whichofthefollowingutilitieswillreportreadandwritesizesondiskI/Orequests?() A.tprofB.iostatC.svmonD.filemon ” 相关考题
考题
YouareanalyzingtheperformanceofaSQLAzuredatabase.Youneedtorecommendanapproachforidentifyingtheindexesthatshouldbeaddedtoimprovedatabaseperformance.Whatshouldyourecommend?()
A.UseSQLServerProfilertoidentifymissingindexes.B.UsetheDatabaseEngineTuningAdvisortoidentifymissingindexes.C.UseaDynamicManagementViewtoanalyzequeryplans.D.UseaDynamicManagementViewtoascertainthenumberofpendingI/Orequests.
考题
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.
考题
Inaniostatreport,whichofthefollowingoptionsbestdescribesthevalueof%iowait?()
A.TheamountoftimetakentoserviceanI/OinterruptB.ThepercentageoftimeCPU(s)arewaitingforpageinsC.ThepercentageoftimetheCPU9(s)arewaitingonnetworkD.ThepercentageoftimetheCPU(s)arewaitingforoutstandingdiskI/Orequests
考题
Inaniostatreport,whichofthefollowingoptionsbestdescribesthevalueof%idle?()
A.Arepresentationoftheequation(tps/kbps)*100B.ThepercentageoftimethedisksareidlewithnoactivityC.ThepercentageoftimethedisksareidlewithnooutstandingCPUrequestsD.ThepercentageoftimetheCPUisidlewithnooutstandingdiskI/Orequests
热门标签
最新试卷
![瑞牛题库 章节练习 历年真题 模拟试卷](http://assets.51tk.com/51_sidebar_right_index.jpg)