Oracle 11g rac, compiled package not current.

we a 3 node rac cluster oracle 11g. when i compile a package, is it possible that one of the instance might still be holding an older version of the package executable? how can i check?
Rao_SAsked:
Who is Participating?
 
EikromanCommented:
No, that is impossible.
Package creation is a DDL statement. When DDL is performed on the package, the package will be locked until the operation is performed.
If the package (procedure/function) is executing on any RAC instances, you'll be unable to compile a new version of a package until it terminates.

If you still wish to verify it manually, to have a peace of mind then:
1)Connect directly to different instances as sysdba
2)Query dba_source.
Example:
select * from dba_source where owner = 'MYSCHEMA' AND NAME = 'MY_PACKAGE' AND TYPE='PACKAGE BODY';

Open in new window

3)Compare output

-----

If you need more "evidence", create a very long running procedure. Run it on one instance, and try to make changes to the package on another instance at the same time. It won't be possible.
0
 
Rao_SAuthor Commented:
than you eikroman, you are correct..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.