topic HP-UX 11i v2 Oracle 9i Database trace file size incresing in Operating System - HP-UX

HP-UX 11i v2 Oracle 9i Database trace file size incresing

Khairul_1 — Tue, 02 Sep 2008 03:00:12 GMT

Hi
we have Oracle 9i (9.2.0.8) Online Database on rx5670 Server and OS HP-UX 11i v2.
We are getting following message on trace file
orau5_dbw0_24052.trc which is at /u01/oracle/admin/orau5/bdump:

ksfvquery: slave process did not start, error 0

Can any one help us how we can solve or stop the message or reduce the trace file?

Thanks
Khairul
Bangladesh

Re: HP-UX 11i v2 Oracle 9i Database trace file size incresing

Jeeshan — Tue, 02 Sep 2008 11:15:36 GMT

Hi

Check this query in oracle database

SQL>select * from v $ sgastat where pool = 'large pool';

while backup operation going on.

Re: HP-UX 11i v2 Oracle 9i Database trace file size incresing

Adan Lopez Peña — Wed, 24 Sep 2008 22:58:10 GMT

Hi Khairul,

It looks like some misconfiguration between your DISK_ASYNC_IO and DBWR_IO_SLAVES parameters. Try setting DBWR_IO_SLAVES=0.

Regards,

Adan.