Re: 2 arch and db processes

Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<4048D919.5FE07498_at_remove_spam.peasland.com>...
> > agreed. but now i wanted to know where to set the number of dbwr or
> > arch.. and there is no spfile whatever.
>
> You set this in your initialization file, SPFILE or INIT.ORA. Make sure
> that the INIT.ORA you are modifying is the one that the database is
> actually using.
>
> HTH,
> Brian

i checked through initsid.ora and there are no pfile parameters. i was thinking to do a sql select to confirm whether my oracle parameters are from initsid.ora but couldnt find the necessary ones. but one thing i am very certain is that i changed the value for shared_pool_size for oracle error "ORA-04031: unable to allocate 9712 bytes of shared memory" for it to take effect.

also, i have found out that this parameter determines the number of db_writers i have "DB-WRITERS" i did a grep but also couldnt find files that contain this parameter. my undersatnding is that the default is 1 so it wont be in initsid.ora

advise? Received on Sun Mar 07 2004 - 22:47:05 CST