Inordertodeterminehowefficientlyanapplicationisreadingandwritingdata,whichofthefollowingutilitieswillreportreadandwritesizesondiskI／Orequests?()A.tprofB.iostatC.svmonD.filemon

题目
Inordertodeterminehowefficientlyanapplicationisreadingandwritingdata,whichofthefollowingutilitieswillreportreadandwritesizesondiskI／Orequests?()

A.tprof

B.iostat

C.svmon

D.filemon

相似考题

1.YouareanalyzingtheperformanceofaSQLAzuredatabase.Youneedtorecommendanapproachforidentifyingtheindexesthatshouldbeaddedtoimprovedatabaseperformance.Whatshouldyourecommend?()A.UseSQLServerProfilertoidentifymissingindexes.B.UsetheDatabaseEngineTuningAdvisortoidentifymissingindexes.C.UseaDynamicManagementViewtoanalyzequeryplans.D.UseaDynamicManagementViewtoascertainthenumberofpendingI/Orequests.

2.Inaniostatreport,whichofthefollowingoptionsbestdescribesthevalueof%iowait?()A.TheamountoftimetakentoserviceanI/OinterruptB.ThepercentageoftimeCPU（s）arewaitingforpageinsC.ThepercentageoftimetheCPU9（s）arewaitingonnetworkD.ThepercentageoftimetheCPU（s）arewaitingforoutstandingdiskI/Orequests

3.Inaniostatreport,whichofthefollowingoptionsbestdescribesthevalueof%idle?()A.Arepresentationoftheequation（tps/kbps）*100B.ThepercentageoftimethedisksareidlewithnoactivityC.ThepercentageoftimethedisksareidlewithnooutstandingCPUrequestsD.ThepercentageoftimetheCPUisidlewithnooutstandingdiskI/Orequests

4.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.

相关内容