Re: Proc Compilation Issues

Mahesh Hardikar wrote:
> Hello ,
>
> Oracle9i Enterprise Edition Release 9.0.1.0.0 - 64bit Production
> PL/SQL Release 9.0.1.0.0 - Production
> CORE 9.0.1.0.0 Production
> TNS for HPUX: Version 9.0.1.0.0 - Production
> NLSRTL Version 9.0.1.0.0 - Production
>
> HP-UX 11.11
>
> On this system we are encountering problems when we try to compile
> procedures.
> All those procedures were getting compiled till last week. All of a
> sudden OS got rebooted giving a Panic . Then I restarted Oracle.
>
> Now some procedures take a long time to compile.
>
> SQL> _at_/home/oracle/tp_trmv1_sp_uihuummsh.sql;
> 512
>
>
> What is this ? Same procedure gets compiled on other Test instance
> which runs on NT ....
>
> Alert file shows nothing
>
> Any help is kindly appreciated .....
>
> Regards ,
> Mahesh Hardikar

Check if other (dependent) procedures are invalid, too. These will get compiled to satisfy the depenencies, and this may take a while.
If -due to the panic- procedures stay invalid, you will go throught that loop every time you compile...

-- 
Regards, Frank van Bortel