Shulou(Shulou.com)05/31 Report--

The main content of this article is to explain "what is the automatic generation script of awr report every day". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn what the awr report automatically generates script every day.

Later, according to their own business needs, set the next awr generation time

#! / bin/bash

# load the environment variable file of oracle, otherwise the sqlplus command cannot be executed in the crontab scheduled task (or use source / home/oracle/.bash_profile)

. / home/oracle/.bash_profile

# define variable-the file type that generates the awr report

AWR_FORMAT=html

# define variables-pull the snap list within a few days

NUM_DAYS=3

# define the variable-the end snap ID of the generated awr report, that is: end_snap

MAX_SNAP_ID=$ (echo `sqlplus-S / as sysdba

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.