What did Oracle consultant told you as a reason for setting this hidden parameters?
On 9/6/06, amonte <ax.mount@xxxxxxxxx> wrote: > > Hi > > I have been suggested by some Oracle Consultant to set 20 Database > Writer in a 12 CPU HP-UX Server. > > Does anyone know what are the side effects of having excessive DBWR? I > detected a higher CPU usage (between, 1% to 2%) not sure if its due to the > number of Database Writer. Because when I increased the number of DBWR at > init.ora I also changed these parameters > > _row_cache_cursors = 60 > _kgl_latch_count = 59 > _kghdsidx_count = 4 > statistics_level = basic > > again suugested by this guy. > > TIA > > Alex > >