using alter xx.xxx recompile to reset packages in other sessions

From: Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com>
Date: Tue, 14 Jan 2014 10:17:01 -0400
Message-ID: <CAGYrQyu-wDbc2cv1MvEzqP6VjDme1U718JxrTz1D-ubMUbYReg_at_mail.gmail.com>



Hello,

alter package xx.yy recompile;

This force other session to reconnect or reload.

The question is: "Is this a reasonable solution in 11g and upwards", because I remember from 11g the way Oracle decompile process had been optimized."
Or this could cause problems.

The explanation:

I have a package where I set the date in a package variable, to improve performance.

I need to reset that variables after I close de day, this means advance +1 the date..

The only way I found is to issue the alter compile.

Thank you.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 14 2014 - 15:17:01 CET

Original text of this message