Re: tuning advisor for an insert statement

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 21 Oct 2019 23:41:41 -0400

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


Other related posts: