lr测试数据库性能

$Ea@4l+N9u+fV0目的：loadrunner测试oracle数据库性能；51Testing软件测试网[;i;F1?7W(M

*yNa ^&vo/?0环境：oracle安装在linux系统下，loadrunner载本机PC上；51Testing软件测试网H5Oc-WeT8Un

8xc$uy%QN'eZ+zf0方法：使用web service协议，用lr提供的函数写脚本完成测试；51Testing软件测试网8O8P*a7l~G$t

3~|8d+a{0 script：

o.G+lk^tN]]U A0第一种：测试通过

;vZ1X$S\Og0//建立数据库连接
~T L'z*b/h,S)V0    lr_db_connect("StepName=DatabaseConnection",
!OOH3K ]&`
NG~0                  "ConnectionString=Driver={Microsoft ODBC for Oracle};"51Testing软件测试网 Mg0p@+yXw"K9L.g
                                   "Server=192.168.xxx.xxx:1521/SID;"51Testing软件测试网*KN!i%{h9KfumO
                                   "Uid=xxxxxx;"51Testing软件测试网%Mrz4UL8k!k
                                   "Pwd=xxxxxx",
7r,m'M L0SM,k0                  "ConnectionName=db1",
sQF3w'`4`
P"K0                  "ConnectionType=ODBC",
R8C%ZrhT3Q8K(C+p0                  LAST);51Testing软件测试网fI8Y#}3OE

N!j)^$AP%I"l%U0安装oracle客户端，选择440M模式的安装，不然找不到Microsoft ODBC for Oracle驱动

第二种：测试通过

.C5MM%|4IL0~0  lr_db_connect("StepName=Connect to DB",
)KC6Xl5}&A0   "ConnectionName=DB",51Testing软件测试网9\ Gx8I$CPi
   "ConnectionString=Provider=OraOLEDB.Oracle.1;Data Source=192.168.xxx.xxx:1521/SID;Password=xxx;User ID=xxxxx",
K#K|&s.?*Xa0   "ConnectionType=OLEDB",
*c3{+vN:v0   LAST);51Testing软件测试网1|{ys$g.}HQF

EB c.n9[2MG)^ eT0测试完整代码如下：

+D ?#@m7tN^:}oC0   //建立数据库连接
2c4NXzjXg}l0    lr_db_connect("StepName=DatabaseConnection",
1r,k#ED&mQu5r+s2Y0                  "ConnectionString=Driver={Microsoft ODBC for Oracle};"51Testing软件测试网I3EE2mz{l"U
                                   "Server=192.168.xxx.xxx:1521/SID;"51Testing软件测试网}Z0yO)N u1V
                                   "Uid=xxxxxx;"
{#rJ"y8dj0                                   "Pwd=xxxxxx",51Testing软件测试网*pVnMRw7J(x
                  "ConnectionName=db1",
tSs}/w0                  "ConnectionType=ODBC",51Testing软件测试网2a/~(L0bI!Og
                  LAST);51Testing软件测试网IK&K|V)oM

51Testing软件测试网Ze,S{sG&a
 lr_start_transaction("sql start");

)N*xLW [\x"k0     //执行SQL语句
#^'m@.Rd]}\BK0     NumRows = lr_db_executeSQLStatement("StepName=PerformQuery",51Testing软件测试网&G*f
x1fG f6D7m+|
                                          "ConnectionName=db1",51Testing软件测试网*C(Xq_k$I9PW
                                          "SQLStatement=select distinct channel  from ty_downflow",51Testing软件测试网+X^:_%H.q.Q&n
                                          "DatasetName=select",
"i'c c6T B0                                          LAST);51Testing软件测试网(yfHLf3DX
 
u2G q[h"A/i:WK0 lr_end_transaction("sql start", LR_AUTO);

&[4Q/Yy1S3z0        //释放结果51Testing软件测试网2WF9ZW8^i)|[&S
         lr_db_dataset_action("StepName=RemoveDataset",51Testing软件测试网K!h'~5k1W_B7j
                            "DatasetName=select",51Testing软件测试网.j-DOa*bG(j!o`
                            "Action=REMOVE",51Testing软件测试网^9d0a,St?
                            LAST);

Cb6?/c"c/F{'vO051Testing软件测试网N:Ipa @
     //断开数据库连接51Testing软件测试网[(KU)b5MRd
      lr_db_disconnect("StepName=Disconnect",
"X({%J]e/u0                       "ConnectionName=db1",
\#sj_+vk1AR0                       LAST);51Testing软件测试网qbR\\;~?