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

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. Received on Fri Aug 01 2003 - 07:19:37 CDT