Hi DBAs, Is there any way to get the same execution statistics between the finished sql statement and interrupted sql statement?
Supposed table A have ten million rows. If select A.a, A.b from A where ..., in sqlplus session, actually the returned could be millions. I could not wait for all the selected rows coming out. I have to interrupte it in the process. Could I still get the same execution statistics in trace file? The same happened to "set autotrace on" in sqlplus session. I could only see the execution plan at the end of execution. Thanks in advance, Chuan
Unless otherwise stated, this e-mail does not represent the views of TransACT Communications Pty Limited. This text and any attachments of this e-mail are confidential and may be legally privileged. This email is for the use of the intended recipient only. If you are not the intended recipient do not take any action in relation to this email, other than to notify TransACT Communications by replying to this e-mail and destroying the original communication. Except as required by law, TransACT Communications does not represent that this transmission is free of errors, viruses or interference.
