Re: Suddenly recompile package become so slow

Hi Jeremy,

No, I don't think so.
This is really strange.

Today, I found out SYSTEM tablespace is only has 4 Meg left.

And I add another 200M to it , just for test. Since this is a development host, not production.

You know how I come to realize about system tbsp. I saw there is a lot of wait event to wait for SYSTEM tablespace in a
"db file sequential read" status.

But this might NOT be the only problem in that machine. That is also a SQL*NET client wait for a long time.

Just trying to debug.
Since now, every single developers is complaint about the "long compilation of all the packages".

I will keep update on this issue here.
P.S. The interesting thing happen in this particular company is very interesting. I work in a lot of places before and never seen all these STRANGE problems. Good place to learn though.

Thanks,

Dominica

Jeremy wrote:
> In article <1118267118.360271.170660_at_g44g2000cwa.googlegroups.com>,
> dominica_at_gmail.com says...
> > This is very interesting.
> > Suddenly today, one developer come to me and
> > said he recompile all his objects cause 20 minutes+.
> > It used to be like a few minutes.
> >
> >
>
> Does the schema include any java stored procedures?
>
> --
>
> jeremy
Received on Thu Jun 09 2005 - 15:13:13 CDT