Re: tuning advisor for an insert statement
Date: Mon, 21 Oct 2019 23:41:41 -0400
Message-ID: <e750979d-1a16-9214-f8f6-a235bcf51523_at_gmail.com>
On 10/21/19 4:26 PM, Sayan Malakshinov wrote:
> Hi Jeffrey,
>
> Yes, as far as I remember it executes DML, but then it executes rollback.
>
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.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 22 2019 - 05:41:41 CEST