Hi,
I need to get the time taken by a long running DB query that is called once i click on a button on an oracle applications form. I use oracle nca protocol while scripting in load runner. My doubt is if i start a transaction and include the code like nca_button_press("") and end the transaction, would the response time of the transaction include the time taken by query as well?If not is there any chance of getting it?

Secondly,i had to give some think time after button press. Otherwise the script fails while replay. My understanding is that think time is required in this case to give sufficient time for the second form to open up.
Now if I include think time and subsequent step as well in the transaction, the transaction response time would include the combination of time taken by the query and also the think time which is specified by me.
Either way i wont be able to get the time taken by the query without the user specified think time influencing it. Please let me know if there is any way or do we need to use the oracle tables.