Re: source of package invalidation
From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Sun, 15 Mar 2009 21:25:56 +0900
Message-ID: <5e3048620903150525g4969bf75r59edfada3327193d_at_mail.gmail.com>
>
>
> (IMHO it is a weakness of PL/SQL that it won't let the two versions of a
> package run in parallel until all sessions using the old version have gone
> away. Of course that can get complicated very quickly if someone really is
> recompiling the package, and if the sessions are long lasting, like in a
> connection pool).
>
> Regards Nigel
>
>
Well...maybe... just maybe...something might be coming along to help out in that respect
Date: Sun, 15 Mar 2009 21:25:56 +0900
Message-ID: <5e3048620903150525g4969bf75r59edfada3327193d_at_mail.gmail.com>
>
>
> (IMHO it is a weakness of PL/SQL that it won't let the two versions of a
> package run in parallel until all sessions using the old version have gone
> away. Of course that can get complicated very quickly if someone really is
> recompiling the package, and if the sessions are long lasting, like in a
> connection pool).
>
> Regards Nigel
>
>
Well...maybe... just maybe...something might be coming along to help out in that respect
-- Connor McDonald =========================== email: connor_mcdonald_at_yahoo.com web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat" -- http://www.freelists.org/webpage/oracle-lReceived on Sun Mar 15 2009 - 07:25:56 CDT