Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Suddenly recompile package become so slow
Hi Joel/Jeremy,
Thanks for all your help/suggestion.
Guess what?
I think the system tablespace is filling up and
it is doing auto-extend and it is really slow.
After I add more space to it.
Suddenly, all the developers could compile all their object
very very fast now.
In addition to this problem, there is also a big SWAPPNIG going
on. So I am going to reduce the MTS server from 30 to 15, there
only 12 developers.
And I am going to reduce the shared pool's size and
db_block_buffer's size.
Since there is not enough memory and whole machine is swapping.
Thanks,
Dom Received on Thu Jun 09 2005 - 17:57:53 CDT