Hello
I'm trying to apply an SQL Break for long running queries, but seems I can't make it work.I've a long running query which retrieves 375000 rows an includes an order by clause. The whole query takes about 75 seconds before it starts bringing data (all these in SQL PLus) and about 1.5 hours to fetch the last row. So through a demo app I place a TOracleSession and a TOracleDataSet. Using a button I activate my DataSet and in 1 or 2 seconds through another button or keyboard combination I run the OracleSession.BreakExecution.Unfortunatelly nothing happens; my query is still running.
Does anyone has any idea of what should I do ?
Thanks in advance for your reply
MYTSKIDIS GEORGIOS
MYTSKIDIS_G@GI-NET.GR
------------------
I'm trying to apply an SQL Break for long running queries, but seems I can't make it work.I've a long running query which retrieves 375000 rows an includes an order by clause. The whole query takes about 75 seconds before it starts bringing data (all these in SQL PLus) and about 1.5 hours to fetch the last row. So through a demo app I place a TOracleSession and a TOracleDataSet. Using a button I activate my DataSet and in 1 or 2 seconds through another button or keyboard combination I run the OracleSession.BreakExecution.Unfortunatelly nothing happens; my query is still running.
Does anyone has any idea of what should I do ?
Thanks in advance for your reply
MYTSKIDIS GEORGIOS
MYTSKIDIS_G@GI-NET.GR
------------------
