| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle not available???
YOur network guys may have turned off access to ports 1521 or 1575 if you
are using onames to stop the spread of the worm.
I used to DBA 30 some instances on several windows boxes. Both NT and 2k.
Pretty much made a point of rebooting at least once a week. Did cold backups so database was down anyway and adding a reboot was easy.
One box we did not reboot regularly and it would eventually crash or lose its mind. I don't think we had a windows box up for more than 120 days on windows. (patching, crashes, memory leaks, hardware failure etc...)
These were canned apps and they tended to have lots of extra crap installed on the DB server so rebooting was a prudent to prevent business hours downtime.
One box was rebooted nightly due to poorly designed interface between a phone switch and a database.
-----Original Message-----
Sent: Thursday, September 04, 2003 1:45 AM
To: Multiple recipients of list ORACLE-L
Thanks Patrice,
I'll look into this, however I find it way strange that the server has been running no problems for almost three months. Maybe a suggestion from one of the other listers is very pertinant - reboot bi-weekly perhaps. However I hear from my virus admin that we were attacked by another worm yesterday and also that it was not only my system that lost connections, the other system was a SQLserver machine. So makes me wonder. Anyway Patrice, I'll look into your suggestion, purely because I was did not know of it before, and thanks for the info.
PS when you mention mem utilization stats - are thinking of the ones generated by the windows monitoring utility?
Best Regards
Denham
Check in Task Manager, Performance Tab...
upper right corner, Physical Memory (K) Total = lower left corner, Commit Charge (K) Peak =
Commit Charge Peak should be less than half physical RAM, otherwise users may not be able to connect.
Oracle can't be swapped to disk in Windows because it updates the data block and other headers regularly, and it's too fast for the Windows virtual memory manager. I don't know if this is the case only for busy databases, but I bumped into that here.
Windows splits memory equally between kernel and user processes, that means you get to use about half the available RAM on your machine.
User sessions can usually be swapped to disk (I think), if they are inactive.
I would be curious to hear what memory utilization stats you have on the machine.
Patrice.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Denham Eva
INET: EvaD_at_TFMC.co.za
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Sep 04 2003 - 10:24:41 CDT
 |
 |