EcoBuntu.org

sqlplus user/password@db

SQL> set echo off
SQL> set feed off
SQL> set head off
SQL> spool analyze_tables.sql
SQL> select ‘analyze table ‘||table_name||’ compute statistics;’ from user_tables;
SQL> spool off
SQL> exit

sqlplus user/password@db @analyze_tables.sql

The sar command writes to standard output the contents of selected cumulative activity counters in the operating system, e.g:

nohup sar -A -o /tmp/activity 60 0 1>/dev/null 2>&1 &