| 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???
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.
-----Original Message-----
Sent: Wednesday, September 03, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
Hello Gurus
I had a weird one to day, all access to Oracle on our oracle database was
suddenly lost....
When you try to connect it says that Oracle is on available.
However the DB has been up for more than 70 days. The other thing the
service was running and the Oracle process and listener was running?
No errors in the logs, nothing.
Server: Win2k, Oracle 817.
Has anyone experienced this before???
TIA
Denham Eva
Oracle DBA
Linux like TeePee... No Windows, No Gates and Apache inside!
--
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 Wed Sep 03 2003 - 10:29:27 CDT
 |
 |