Re: How do we anble multilple database writer processes

In article <8i8sa8$h1h$1_at_nnrp1.deja.com>,   manoj67_at_hotmail.com wrote:
>
>
> Hi,
>
> Could someone please tell me how to enable
> multiple database writers?
>
> I guess there is a initalization parameter that
> needs to be set. I am not sure of the exact method.
>
> thanks,
> Manoj
>
> Here is information about my Oracle Version
> and Operating System.
>
> ORACLE VERSION
> --------------
>
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle7 Server Release 7.3.4.0.0 with the 64-bit option - Produc
> PL/SQL Release 2.3.4.0.0 - Production
> CORE Version 3.5.4.0.0 - Production
> TNS for DEC OSF/1 AXP: Version 2.3.4.0.0 - Production
> NLSRTL Version 3.2.4.0.0 - Production
>
> SQL>
>
> Operating System
> ----------------
>
> Compaq Tru64 UNIX V5.0 (Rev. 910) (Alpha1) (pts/2)
> Digital UNIX V5.0 (Rev. 910); Mon Apr 10 11:33:43 PDT 2000
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

You can either set the 'asynch_io' init.ora parameter to true or you can set the db_writers parameter to the number of DBWR processes you want.

David Fitzjarrell
Oracle Certified DBA

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jun 14 2000 - 00:00:00 CDT