RE: Oracle Tuning Advisor for insert statement

You run it on any insert statement, but you won't get anything useful unless you have an "insert as select". I've done this many times with no adverse effects to data in tables.

Thanks,

Jeremy

Always be yourself, express yourself, have faith in yourself. Do not go out and look for a successful personality and duplicate it - Bruce Lee

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom Sent: Monday, December 18, 2017 12:18 PM To: oracle-l-freelist <oracle-l_at_freelists.org> Subject: Oracle Tuning Advisor for insert statement

CAUTION - EXTERNAL EMAIL In the past, I have only run the advisor for a select statement. Can it be run for an Insert statement? I have always hesitated running it on one since when evaluating the effectiveness of the statement the advisor tries to execute it.

Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

--
http://www.freelists.org/webpage/oracle-l