On 10/21/19 4:26 PM, Sayan Malakshinov wrote:
Hi Jeffrey,In other words, it kills your system dead. Insert of a few GB into a large table, followed by an equally humongous rollback is a nice prank, if executed on the database owned by somebody else. Alternatively, it's a great way of convincing your boss that you need Exadata. However, that strategy might backfire if you don't work in Dilbert-like environment. That is why there is SQL trace. Tuning advisor sounds like a really, really bad idea in this case.
Yes, as far as I remember it executes DML, but then it executes rollback.