We are using VB6.0,ADO,COM,COM+ and Oracle9i Back end

The normal assumption we made is stored procedures are faster than direct Sql statements passed from connection or command object. After converting Sql statements to pakages and stored procedures and functions our application perform slower than before.

We have done PINING of packages.Hit ratios are above 99%, have 512MB RAM,SGA instance is 129MB.

The performance before using SP was 10Transactions per second
The performance after using SP is 7Transactions per second.

Can anyone explain how to improve performance,why the SPs are slower in COM,COM+ environment?

Thanks in Advance....