Re: Suddenly recompile package become so slow

dominica_at_gmail.com wrote:
> 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.
>

I've also seen issues with pga_aggregate_target somehow causing this if you follow some Oracle recommendations too closely.

Read the docs on what MTS is good for. Development generally isn't it.

jg

-- 
@home.com is bogus.
http://viewfromalabrat.blogspot.com/