后台执行多个SQL数据脚本

最新推荐文章于 2024-04-08 13:06:01 发布

六月闻君

最新推荐文章于 2024-04-08 13:06:01 发布

阅读量713

点赞数

分类专栏： Linux Oracle 文章标签： sql 数据库

本文链接：https://blog.csdn.net/qq_39065491/article/details/128018782

版权

Oracle 同时被 2 个专栏收录

71 篇文章 1 订阅

订阅专栏

Linux

35 篇文章 1 订阅

订阅专栏

后台执行多个SQL数据脚本

需要在linux后台并行执行多个sql数据脚本，提高效率。

1、执行多个文件

scott-105-4.sql文件包括40个数据SQL文件

set heading off
set timing off
set heading off
set echo off
set pagesize 0
set long 1000000
set linesize 2000
spool /sqlscript/scott-4.log

 @/sqlscript/Thread/Thread-16-12-01.sql
 @/sqlscript/Thread/Thread-16-12-02.sql
 @/sqlscript/Thread/Thread-16-12-03.sql
 @/sqlscript/Thread/Thread-16-12-04.sql
 @/sqlscript/Thread/Thread-16-12-05.sql
 @/sqlscript/Thread/Thread-16-12-06.sql
 @/sqlscript/Thread/Thread-16-12-07.sql
 @/sqlscript/Thread/Thread-16-12-08.sql
 @/sqlscript/Thread/Thread-16-12-09.sql
 @/sqlscript/Thread/Thread-16-15-09.sql
 @/sqlscript/Thread/Thread-16-12-10.sql
 @/sqlscript/Thread/Thread-16-13-01.sql
 @/sqlscript/Thread/Thread-16-13-02.sql
 @/sqlscript/Thread/Thread-16-13-03.sql
 @/sqlscript/Thread/Thread-16-13-04.sql
 @/sqlscript/Thread/Thread-16-13-05.sql
 @/sqlscript/Thread/Thread-16-13-06.sql
 @/sqlscript/Thread/Thread-16-13-07.sql
 @/sqlscript/Thread/Thread-16-13-08.sql
 @/sqlscript/Thread/Thread-16-13-09.sql
 @/sqlscript/Thread/Thread-16-13-10.sql
 @/sqlscript/Thread/Thread-16-14-01.sql
 @/sqlscript/Thread/Thread-16-14-02.sql
 @/sqlscript/Thread/Thread-16-14-03.sql
 @/sqlscript/Thread/Thread-16-14-04.sql
 @/sqlscript/Thread/Thread-16-14-05.sql
 @/sqlscript/Thread/Thread-16-14-06.sql
 @/sqlscript/Thread/Thread-16-14-07.sql
 @/sqlscript/Thread/Thread-16-14-08.sql
 @/sqlscript/Thread/Thread-16-14-09.sql
 @/sqlscript/Thread/Thread-16-14-10.sql
 @/sqlscript/Thread/Thread-16-15-01.sql
 @/sqlscript/Thread/Thread-16-15-02.sql
 @/sqlscript/Thread/Thread-16-15-03.sql
 @/sqlscript/Thread/Thread-16-15-04.sql
 @/sqlscript/Thread/Thread-16-15-05.sql
 @/sqlscript/Thread/Thread-16-15-06.sql
 @/sqlscript/Thread/Thread-16-15-07.sql
 @/sqlscript/Thread/Thread-16-15-08.sql
 @/sqlscript/Thread/Thread-16-15-10.sql
 
spool off

exit

2、后台执行

后台执行 sql

#./sqlplus scott/Tiger_scott@dhbackup @./scott-105-1.sql  & 
#./sqlplus scott/Tiger_scott@dhbackup @./scott-105-2.sql  & 
#./sqlplus scott/Tiger_scott@dhbackup @./scott-105-3.sql  & 
#./sqlplus scott/Tiger_scott@dhbackup @./scott-105-4.sql  & 
# ps -ef|grep sqlplus
root     14064  3063  0 14:55 pts/0    00:00:00 grep --color=auto sqlplus
root     29019  3377 10 11月22 pts/2  02:30:19 ./sqlplus                            @./scott-105-1.sql
root     29030  3377 10 11月22 pts/2  02:28:27 ./sqlplus                            @./scott-105-2.sql
root     29031  3377 10 11月22 pts/2  02:28:19 ./sqlplus                            @./scott-105-3.sql
root     29066  3377 10 11月22 pts/2  02:27:13 ./sqlplus                            @./scott-105-4.sql