Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Suddenly recompile package become so slow

Re: Suddenly recompile package become so slow

From: <dominica_at_gmail.com>
Date: 9 Jun 2005 15:57:53 -0700
Message-ID: <1118357873.312773.261570@g47g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US