tag:blogger.com,1999:blog-3747175925363126905.post5543272233041759373..comments2023-11-01T17:30:27.638+05:30Comments on Technology & Management Journal: One way for Avoiding SQLEXEC usuageAnoop Saviohttp://www.blogger.com/profile/18084681245929178872noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3747175925363126905.post-63927060237602601172010-02-04T21:00:24.724+05:302010-02-04T21:00:24.724+05:30Hi
I tried this out in a test, running the same q...Hi<br /><br />I tried this out in a test, running the same query 10,000 times again and again with the same input (this means that oracle took almost no time to give the response because the data would be cached in the buffer pool).<br /><br />For me, it takes 20 seconds for the sqlexecs to complete and it takes 40 seconds for the rowset fills to completeSouveekhttps://www.blogger.com/profile/13750099914264289431noreply@blogger.com