Re: Problem while compiling packages

Hi Venkatesh

If the problem seems to be related to archivelog, you should look in your alert<sid>.log for any 'cannot allocate log archival required' messages. If your online redo logs are small ( < 5M), and you have a burst of changes, you will fill ALL your archive logs in one sweep, and the database will just hang! until it did archive those files. In noarchivelog they will simply be overwritten.
I have seen frequent problems when packages are mutual dependent of each other. I have never been able to proof dead-lock on the data dictionary, though that is the most likely explanation. There is a package named DBMS_APPLICATION_INFO, which is very useful to see what is happening. It's output will appear in the client_info column of v$session. This package is Oracle-provided and it's source should be located in $ORACLE_HOME/rdbms/admin (I don't know the exact name of the file, but a grep will probably do).
If you decide to recompile that manually be aware most packages have an accompanying prvt<package abbrev>.plb that also needs to be reapplied. If there is an error validating that file, you should post the exact error message.

Hth,
--
Sybrand Bakker, Oracle DBA
Venkatesh Kumar <vkumar_at_fundu.com> wrote in message news:37F63AB7.FA335F37_at_fundu.com...
> Hi guys,
> An additional thingthat I found. We had this problem when we are running
> the database in the Archive Log mode. When we run it in the noarchive
> mode, it seems to be fine. Any ideas wh it behaves like that in Archivelog
> mode. If that is the normal behaviour, how does one makes updates to
> packages in a production environment ?
>
> Thanks
> venkatesh
>
> Venkatesh Kumar wrote:
>
> > Hi guys,
> > We are running Oracle 87.0.5 on a Sun Solaris. We have about 40
> > different packages. Some times when we recompile a pcakge, it compiles
> > the packahe definition and comes to package body and just hangs. The
> > database just hangs and the only way to fix this is to bounce the
> > database. It happens once in a while and only with certain packages.
> > Couple of times I have waited to see what happends and it comes back
> > with a Time out error on a DBMS_APPLICATION table. Any ideas on what
> > this table does or is for ?
> >
> > Thanks
> > venkatesh
>
Received on Sat Oct 02 1999 - 15:20:43 CDT