Tag: technology

Which of the following options for the PFILE/SPFILE parameter STATISTICS_LEVEL turns off AWR statistics gathering and ADDM advisory services?

Suppose you have used EM Database Control to drill down into ADDM findings and have found that a single SQL statement is causing the majority of I/O on your system. Which of the following advisors is best suited to troubleshoot this SQL statement?

Nearly all the advisors submit their analysis activities to the database in the form of a job. When the analysis job is submitted, which option for job scope adds the least overhead to the system?