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

From: <sybrandb_at_yahoo.com>
Date: 30 Jul 2003 06:04:21 -0700
Message-ID: <a1d154f4.0307300504.3f174a28@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,
> İ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 Received on Wed Jul 30 2003 - 08:04:21 CDT