回滚段头事务表的大小

Yong Huang

原帖由 sqysl 于 2008-5-29 01:39 发表
谢谢了yonghuang，学习。
草草的看了一遍，没完全看明白，尤其是PERL脚本的部分，为什么用到PERL脚本呢，都用SHELL不可以完成吗？看来SHELL在文件内容的操作上远没PERL方便啊。

If you're willing to manually edit 48 files (actually I used 96 files in total), you don't need to use Perl.

Everyone working on UNIX/Linux should remember this very useful command:

perl -pi -e 's/string1/string2/' filename

It does what these two commands do:

sed -n 's/string1/string2/' filename > tmpfile
mv tmpfile filename

Since you don't have to worry about the middle file, tmpfile, here, the perl command is much easier. The middle file, if you use the sed method, has to be unique, which adds complexity to your shell programming logic.

This command:

perl -pi -e '$x=$.; s/constantstring/$x/' filename

does what UltraEdit vertical line editing does. $. is current line number.

Yong Huang

DINGNING239

太高深了，看不懂，就明白了通过设置隐含参数可以增加事务

sqysl

谢谢YONGHUANG 的答复，有机会认真研究一下PERL

sqysl

yonghuang，俺现在用SHELL编了个脚本(crt_sql_test.sh)完成你的测试脚本的生成：i.sql和test.sh:
$cat crt_sql_test.sh
#!/bin/sh
i=1
while [ i -le 48 ]
do
  echo "set transaction use rollback segment \"_SYSSMU5$\";\ndelete from t where x = $i;">$i.sql
  echo "sqlplus -S yong/yong @$i \&">>test.sh
  i=`expr $i+1`
done
文件都在当前目录下，然后运行：
./test.sh

[ 本帖最后由 sqysl 于 2008-5-31 22:24 编辑 ]

Yong Huang

原帖由 sqysl 于 2008-5-31 08:20 发表
yonghuang，俺现在用SHELL编了个脚本(crt_sql_test.sh)完成你的测试脚本的生成：i.sql和test.sh:
$cat crt_sql_test.sh
#!/bin/sh
i=1
while [ i -le 48 ]
do
  echo "set transaction use rollback segment "_SYSSMU5$";
delete from t where x = $i;">$i.sql
  echo "sqlplus -S yong/yong @$i &">>test.sh
  i=`expr $i+1`
done
文件都在当前目录下，然后运行：
./test.sh

Great! I should have done that too. It's cleaner. Actually, we probably could merge all contents of $i.sql into the single file, test.sh, using here documents.

This kind of trick is useful to create many sessions. There're lots of load testing programs on the Internet. But I don't think they allow you to create sessions and sit there doing nothing like what we do here. Besides, no load testing programs would think of "set transaction use rollback segment".

Yong Huang

sqysl

thanks to yonghuang,but what is your mean for the "Actually, we probably could merge all contents of $i.sql into the single file, test.sh, using here documents",how to put all into the single file?like this:

$cat crt_sql_test.sh
#!/bin/sh
i=1
while [ i -le 48 ]
do
    echo "sqlplus -S yong/yong  set transaction use rollback segment \"_SYSSMU5\$";delete from t where x = $i \&">>test.sh
  i=`expr $i+1`
done

[ 本帖最后由 sqysl 于 2008-6-1 18:14 编辑 ]

Yong Huang

原帖由 sqysl 于 2008-6-1 04:13 发表
thanks to yonghuang,but what is your mean for the "Actually, we probably could merge all contents of $i.sql into the single file, test.sh, using here documents",how to put all into the single file?like this:

$cat crt_sql_test.sh
#!/bin/sh
i=1
while [ i -le 48 ]
do
    echo "sqlplus -S yong/yong  set transaction use rollback segment "_SYSSMU5$";delete from t where x = $i &">>test.sh
  i=`expr $i+1`
done

Instead of having many .sql files, each one called by
sqlplus -s yong/yong @$i.sql &

I can do this:

$ cat test.sql
set transaction use rollback segment "_SYSSMU11$";
delete from t where x = &1;
$ cat test.sh
sqlplus -s yong/yong @test 1  &
sqlplus -s yong/yong @test 2  &
sqlplus -s yong/yong @test 3  &
sqlplus -s yong/yong @test 4  &
sqlplus -s yong/yong @test 5  &
sqlplus -s yong/yong @test 6  &
sqlplus -s yong/yong @test 7  &
sqlplus -s yong/yong @test 8  &
...
$ . ./test.sh

That works. But it's still not ideal. I want to merge the test.sql into test.sh so one single file is enough. I haven't figured that out yet.

By the way, in your script you need to change echo to echo -e, add spaces around + inside expr expression, remove  in front of &, and change "i -le 48" to "$i -le 48". I like the new syntax better: while (( i < 48 )).

Also, you need to run the shell script as a dot script: . ./test.sh, not just ./test.sh.

Yong Huang

sqysl

thanks a lot to YONGHUANG,I haven't tested the scripts,I will test it sometime,then post it.

sqysl

HUANG YONG ,你好：
我在我的环境测试了这个问题，你上次的帖子里说的脚本问题都是对的，我现在我的环境里进行了测试，VM+ENTERPRISE_LINUX4+RAC10_2_1，发现在有以下两个问题：
1.运行脚本用./test.sh，而../test.sh不能运行。
2.在运行脚本期间，查询v$rollstat里没记录，可测试表里的数据确实被删除了。
3.运行完该脚本后，用set transaction...;delete from t...依然可以。
不知道怎末回事情。不知道你测试过这个过程没有，环境是什么环境？

Yong Huang

原帖由 sqysl 于 2008-6-7 20:51 发表
HUANG YONG ,你好：
我在我的环境测试了这个问题，你上次的帖子里说的脚本问题都是对的，我现在我的环境里进行了测试，VM+ENTERPRISE_LINUX4+RAC10_2_1，发现在有以下两个问题：
1.运行脚本用./test.sh，而../test.sh不能运行。
2.在运行脚本期间，查询v$rollstat里没记录，可测试表里的数据确实被删除了。
3.运行完该脚本后，用set transaction...;delete from t...依然可以。
不知道怎末回事情。不知道你测试过这个过程没有，环境是什么环境？

All three problems you reported here are because you did not read my words carefully. You need to run the shell script as a dot script in order to affect the current shell instead of a subshell:
.[space]./test.sh

(Change [space] to an actual space on your keyboard.)

Yong Huang