Calculating the memory and performance of a oracle query
843859Oct 11 2007 — edited Oct 11 2007Hi,
I am now developing application in java with oracle as a back-end. In my application i require lot of queries to be executed. Hence, the system is getting is slow due to queries.
So, i planned to develop one Stand-alone application in java, that should show the statistics like, memory and performance. for ex:- if i enter one SQL query in the text box, my standalone application should display, the processing time it requires to fetch the values and the memory is used for that query.
Can anybody give ideas, suggestion, etc etc...
Thanks in Advance
Regards,
Rajkumar