Oracle sqlplus Unix nohup

nohup sqlplus '/ as sysdba' @Run_gather_stats.sql > Run_gather_stats_`date '+%d%m%y_%H%M%S'`.log 2>&1 &

nohup sqlplus prod1/prod1 @index.sql > index.out 2>&1 &

nohup /export/home/oracle/restore.sh > /export/home/oracle/restore_`date '+%Y%m%d_%H%M%S'`.log 2>&1 &


https://anuj-singh.blogspot.com/search?q=catcon.pl


====

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -e -C 'PDB$SEED' -b ss ss.sql &

jobs -l
[1]+ 1855587 Running                 $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -e -C 'PDB$SEED' -b ss ss.sql &


===
 cat ss.sql

SET VERIFY OFF time on timing on

alter session set nls_date_format='dd-mm-yyyy hh24:mi';

select sysdate from dual;


prompt ========================================
prompt DBMS_STATS.GATHER_FIXED_OBJECTS_STATS ()
prompt ========================================

EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS ();


prompt ========================================
prompt DBMS_STATS.GATHER_SCHEMA_STATS('SYSTEM')
prompt ========================================

EXEC DBMS_STATS.GATHER_SCHEMA_STATS('SYSTEM');


prompt ========================================
prompt DBMS_STATS.GATHER_SCHEMA_STATS('SYS')
prompt ========================================


EXEC DBMS_STATS.GATHER_SCHEMA_STATS('SYS');


prompt ========================================
prompt DBMS_STATS.GATHER_DICTIONARY_STATS
prompt ========================================

EXEC DBMS_STATS.GATHER_DICTIONARY_STATS ();

select sysdate from dual;

--spool off

===



nohup sqlplus '/ as sysdba' @/home/oracle/st.sql > /home/oracle/st.log 2>&1 &

st.sql <<<

set time on timing on 
alter session set container=vihaan ;

EXEC DBMS_STATS.gather_table_stats(ownname => 'ANUJ', tabname => 'AUDITLOG', GRANULARITY => 'ALL', estimate_percent => dbms_stats.auto_sample_size, cascade => TRUE, degree=> 6);