8,028
社区成员
发帖
与我相关
我的任务
分享
command = conn.CreateCommand();
command.Parameters.Add(new OracleParameter(":intkey1", OracleDbType.Int32));
command.Parameters.Add(new OracleParameter(":strkey1", OracleDbType.Varchar2, 30));
command.Parameters.Add(new OracleParameter(":strkey2", OracleDbType.Varchar2, 30));
command.Parameters.Add(new OracleParameter(":strkey3", OracleDbType.Varchar2, 30));
command.Parameters.Add(new OracleParameter(":strkey4", OracleDbType.Varchar2, 30));
command.Parameters.Add(new OracleParameter(":strkey5", OracleDbType.Varchar2, 30));
command.Parameters.Add(new OracleParameter(":strkey6", OracleDbType.Varchar2, 30));
command.Parameters.Add(new OracleParameter(":strkey7", OracleDbType.Varchar2, 30));
command.Parameters.Add(new OracleParameter(":strkey8", OracleDbType.Varchar2, 30));
command.Parameters.Add(new OracleParameter(":strkey9", OracleDbType.Varchar2, 30));
command.Parameters.Add(new OracleParameter(":strkey10", OracleDbType.Varchar2, 30));
for (int i = 0; i < 10000; i++)
{
try
{
sql = "insert into TestXN values (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11)";
command.CommandText = sql;
command.Parameters[0].Value = i;
for (int j = 0; j < 10; j++)
{
command.Parameters[j + 1].Value = "aaaaaaaaaaaaaaaaaaaaaaaaaa";
}
command.ExecuteNonQuery();
}
catch (OracleException ex)
{
Console.WriteLine(ex.Message);
}
}
create table TestXN
(
intkey int,
strkey1 varchar(30),
strkey2 varchar(30),
strkey3 varchar(30),
strkey4 varchar(30),
strkey5 varchar(30),
strkey6 varchar(30),
strkey7 varchar(30),
strkey8 varchar(30),
strkey9 varchar(30),
strkey10 varchar(30)
)
DS_CHECKPOINTS=0
PERM_ALLOCATED_SIZE=655360
PERM_IN_USE_SIZE=18202
PERM_IN_USE_HIGH_WATER=18202
TEMP_ALLOCATED_SIZE=65536
TEMP_IN_USE_SIZE=16385
TEMP_IN_USE_HIGH_WATER=17334
XACT_COMMITS=10024
XACT_D_COMMITS=0
CMD_PREPARES=25
CMD_REPREPARES=0
LOG_BUFFER_WAITS=0
PermSize:640
TempSize:64
CkptFrequency: 0(disable checkpoint)
CkptLogVolume: 0 (disable checkpoint)
LogBufMB : 256
LogFileSize: 260
LogBufParallelism: 4
LogFlushMethod: 2
Isolation: 0
其他项采用了默认设置。