Hi Team,
There is a long running query which is used for automation testing. But this query is using the main transaction tables.
This query is running from 21 hours and still its continuing. If i see the actual rows in the Oracle SQL monitoring tab of Oracle enterprise Manager it shows around 1950K records.
Still the query is running and actual rows count is increasing.
my questions are:
1) Does this query impact any other queries as this query is on main transaction table.
2) If the query is decreasing the performance of other queries, how to check it.
Regards
Vinod