Explain plan in trace file

From: Miha <miha.znidarsic_at_ixtlan-team.si>
Date: 4 Mar 2003 04:34:14 -0800
Message-ID: <8c69a0da.0303040434.3b52c82e@posting.google.com>

Hello.

Does anybody know how order Oracle to put explain plan in trace file when trace file is generated.

Problem is bc we are using Row Level Security and explain plan can change depending on application settings, so if we transform trace file with tkprof using "explain" option, we may get different explain plan than one realy used when sql was executed.

In this moment some sql have explain plan already in trace file and some others not.

Thank you for any advice.
Greetings from Slovenia Received on Tue Mar 04 2003 - 06:34:14 CST