Performance of Stored Procedure
When I run a batch of sql statements seperately it takes around 2 minutes to complete. When I convert that into a stored procedure, it takes time more than 15 minutes and eventually complete. Is there any server setting that needs to be done ? Is there anything to do with auto commit option ?
FYI:The insert and update statements in the batch has around 200000 records, and I have around 50 update statements. Any information will be helpful, as I am converting Sybase Stored procedure to oracle, and I am new to the oracle arena.