Linux Script to Gather Stats

Hi,

I found the below script in your blog and I'm not able to get how to use it. Could you please explain step by step how to configure this script to gather schema statistics and generate a log file.

Here is a Linux shell script to gather HR schema stats and generates a log file under /tmp location #!/bin/bash . /home/oracle/.bash_profile export ORACLE_HOME=/u01/app/oracle/product/19.3/db_home export ORACLE_BASE=/u01/app/oracle export ORACLE_SID=orcl export DATE=$(date +%y-%m-%d_%H%M%S) #### Gather HR schema stats #### sqlplus / as sysdba << EOF > /tmp/HR_stats_gather_$DATE.log EXEC DBMS_STATS.gather_schema_stats('HR'); EOF echo "Stats gathered succeeded"