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,
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-lReceived on Tue Jan 14 2014 - 15:17:01 CET