| Query Profiler tool [message #295686] |
Wed, 23 January 2008 01:47  |
|
|
Hi All,
I am having Java application using Oracle 10g database.
I want to check the time taken by the application to execute the queries.
For example -
1. start Time.
2. Query Submitted.
3. output got from Database server.
4. End time.
Can any body suggest me the tool required to make such type of profiling.
With Regards
Amit Nanote
|
|
|
|
|
|
| Re: Query Profiler tool [message #295698 is a reply to message #295693] |
Wed, 23 January 2008 02:21  |
|
|
Hi,
Sorry to say that I am not supposed to hear such answers from here.
I know that how to get output on Java console.
I have clearly mentioned about tool, which is required to make arrangement for the all the queries used in application code.
I have mentioned about db profiler tool. No need to explicitly specification of System.out.println and also provide the environment of loads of queries to be fired to database.
With Regards
Amit Nanote
|
|
|
|
|
|
| Re: Query Profiler tool [message #295703 is a reply to message #295700] |
Wed, 23 January 2008 02:31 |
|
|
Thats not the case .. I dont meant like that. I found this forum always helpful... thats why. If any body including me try to provide such things here really disappoints.. It may be possible that I havnt looked in that way you have answered first.
I am sorry .. for that. Please excuse me.
With regards
Amit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
