Method for collecting Oracle ARW reports in batches

The invention relates to the field of computers and discloses a method for collecting oracle ARW reports in batches. The method comprises steps of (1) entering an SQLPLUS order tool to call an AWR report batch collection scripts, and starting a collection program to collect, (2) setting collection time according to a collection time requirement, and inputting a time range for collecting reports, (3) inputting a report storage path, determining space of the path, giving out an alarm for prompting to remove files if the space is inadequate, and storing the path into the report if the space is enough, and (4) operating the script and generating all AWR reports in the designated time range according to the step (2) and (3). During systemic analysis to a database by an operation and maintenance worker, work can be simplified by the SQL script, so report collection efficiency can be improved; the creativity of the invention is that AWR report batch production can be simplified; and possibility of mistakes during th