Re: Re: Explain Plan and Security

From: <>
Date: Tue, 19 Jun 2018 10:53:27 +0200 (CEST)
Message-ID: <>

Hi Stefan,

thanks, thats interessting.
I am currently thinking of a much simpler solution though. We could set up a runner job under the Apps User Authority, The Job would receive a statement and bind variables, open the cursor but not fetch the data. Sorry that this is so prosaic.



----Ursprüngliche Nachricht----
Von :
Datum : 19/06/2018 - 10:19 (GMT)
An :, Betreff : Re: Explain Plan and Security

Hey Lothar,
today I had a little bit time to geek out and here is a working test case for what I've mentioned here (,1).

The process aborts with "ORA-03113: end-of-file on communication channel" right before/at fetching the data - so this should exactly fit your needs / security requirements :-)

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website:
Twitter: _at_OracleSK

> "" <> hat am 14. Juni 2018 um 14:36 geschrieben:
> Hi,
> you might know Kerry´s classic blog:
> Normally my work around for explain plan issues is to run the query and use dbms_xplan.display_cursor.
> Now I am working in an environment where I must not run a query, but I can do explain plan.
> But still I think I can not tolerate explain plan weaknesses.
> I think it should be possble to use DBMS_SQL to parse a statement and receive a proper plan without actually running the statement.
> Then use dbms_xplan.display_cursor.
> Before I spent time, has anybody done it already?
> Regards
> Lothar

Received on Tue Jun 19 2018 - 10:53:27 CEST

Original text of this message