Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Khairul_1
Frequent Advisor

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

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
2 REPLIES
Jeeshan
Honored Contributor

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

Hi

Check this query in oracle database

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

while backup operation going on.
a warrior never quits
Adan Lopez Peña
Occasional Visitor

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

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.