aaa aaa,
( if that's your real name :)
Considering that your page faults are very high, take a look
at the sizes of db_block_buffers, db_block_size, and shared_pool_size
for starters.
512 Meg of RAM isn't exactly an overabundance, but will perform
especially badly if you've allocated all of it ( or more ) to the
shared_pool and/or buffer cache.
Jared
"aaa aaa"
<mccdba@hotmai To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
l.com> cc:
Sent by: Subject: ORACLE 8.1.5 on NT run very slow
??
[EMAIL PROTECTED]
om
10/24/01 09:25
AM
Please respond
to ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
