Re: dbwr and lgwr don't shutdown

On Thu, 31 Mar 2005 18:10:22 GMT, netcomradeNSPAM_at_bookexchange.net (NetComrade) wrote:

>This is a weird issue.
>
>We have a machine (v880/solaris8/latest recommended patch cluster),
>where a particular Standard Edition 9.2.0.5 database shuts down
>'cleanly' yet leaves two processes behind, which we cannot kill unless
>reboot. The same database (storage attached to multiple machines) on a
>solaris7/e4500 machine comes up/shuts down fine. (i tiried to shutdown
>the rest with aborts, as you can see from the logs, didn't help)
>
>Any idea?
>here's a log from shutdown on v880

The issue has been narrowed down to DISK_ASYNCH_IO=true When set to false, it works, however, disk performance degrades 4-5X It has been further narrowed down to QIO feature of Veritas. When QIO is turned off, shutdown also works, but performance still degrades 4-5x.

Veritas analyzed savecores and suggested to upgrade to supported version (3.5+) and see what happens..

We can live with performance degration for now, since this is an OLTP db (99%+ memory reads)

We'll look for proper upgrade paths...

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Mon Apr 04 2005 - 17:05:01 CDT