We have HP server with NT 4.0 installed. This server dedicate for ORACLE
use. The ORACLE version is 8.1.5 (no patch installed). we found the
performance NOT really good. I turn on the "performance monitor" and found
the "memory page fault" and "memory pages/sec" are very high while SQL
statement running (even only one user running). The Server have following
configurations:
HP LH 3000
2 CPU
500 Mhz
512 MB RAM
1200 swap space on C:
ORACLE software and NT on C: (9GB, 7200RPM??)
ORACLE data on d: (8 X 9GB RAID 5, 7200RPM??)
ORACLE SGA 250MB
Can anyone give me some hints why:
1. page fault very high?
2. SQL statement run very slow (I turn on TKPROF to trace and found
it is NOT ORACLE SQL statement inefficient problem)?
Thanks.
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: aaa aaa
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
