MTS & Oracle database

[praveenkumar]

Hi,

I am using MTS for middle tier where my DLLs are running. These DLLs insert
data into oracle database with help of PL/SQL procedures. The data transfer
is going pretty slow between MTS and Oracle database.

Does anybody know any kind of tool through which I can find the byte transfer
rate between these two tiers and thus find out the reason for this slowness ?

Thanks
Praveen

Hello,

Try to make Insert Through SQL DML

and use OLE/DB provider for ORACLE, with ADO. Some thing like this

Conn.BeginTrans
Conn.Execute("Insert into TAble Values(" ")")
conn.commitTrans

it'll automatically get faster.
beceause if u are using PL/SQL Stored Procedure, u'r Component has to make request to u'r ORACLE Server and Receive The Result.
So try to do it directly.
if u'r problem is not solved by this solution then acknowledge be at:

singh_vs@hotmail.com



Best of Luck

Bye

Vivek Singh