Re: 8i (8.1.7.4.2) hangs on SHUTDOWN ABORT (WIN2000,SP3)

I won't deny that Unix is be a better choice for 24x7, but we run W2K with 8174 in 24x7 mode and I have no problem keeping my databases up for 1 month.

-- 
Terry Dykstra
Canadian Forest Oil Ltd.
"fatih" <fatih.dokmeci_at_arcelik.com> wrote in message
news:20ba4576.0308010419.351c2376_at_posting.google.com...


> sybrandb_at_yahoo.com wrote in message

news:<a1d154f4.0307300504.3f174a28_at_posting.google.com>...


> > fatih.dokmeci_at_arcelik.com (fatih) wrote in message

news:<20ba4576.0307292309.6fca3c2_at_posting.google.com>...


> > > Thanks for your helps (Anyone)

> > > We reduced the SGA to 1.1GB and

> > > added 'Alter system checkpoint' before 'Shutdown abort'.

> > > Yesterday the server did not hang during all day and we could shutdown

> > > abort first time after 3 weeks:).

> > > Step by step we will decrease

> > > Prosess  to 500

> > > Sort_area_size to 1MB

> > > open_cursor  to 1024

> > > By this way it seems that the DB can be alive few days without a

> > > shutdown.

> > > Thank again for your helps.

> > >

> > > fatih.

> > >

> > > A new question,

> > > &#304;s that possible and the way for make the DB alive on Win2000 for

> > > 7*24hrs,without any shutdown for 1 month as example.How the db should

> > > be configured so that this can be achived without any performance

> > > decrease?

> > >

> > > fatih.

> >

> >

> > Yes, it is possible, on a *REAL* O/S.

> >

> > Sybrand Bakker

> > Senior Oracle DBA

>


> After reducing

> SGA             = 1.2

> SORT_AREA_SIZE  = 1MB

> OPEN_CURSOR     = 1024

> PROCESS         = 500

>


> Our system is alive more then 5 days without any crash,but decided to

> reboot the server each nigth to garantee availability in working days.

> Really I'm not satisfied that Oracle can work on NT 7x24.

> Thanks for all helped me.

>


> fatih.