Oracle-L: RE: Oracle not available???

From: Denham Eva <EvaD_at_TFMC.co.za>
Date: Wed, 03 Sep 2003 22:44:34 -0800
Message-ID: <F001.005CEADC.20030903224434@fatcity.com>

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). Received on Thu Sep 04 2003 - 01:44:34 CDT