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

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. Received on Wed Jul 30 2003 - 02:09:41 CDT