Quote:
How to find the execution progress.?
Basically, you can't.
Displaying a progress bar imply that you know the amount of work of the query, but you usually know it only once the job is finished.
Quote:
at select command it takes 2 minutes to complete the querry.
If it takes 2 minutes to complete, it imply that the query need a huge work to complete, chances are that the query can't be optimized by Oracle.
Best hope would be to show that query to see if one can change it to be faster.
[Update]
Be careful both DateTimes are not using the same format.
An index on TEST_DTTM would certainly speed up the query.