OS Paging/performance question
- From: Ed <esimmonds@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 21 Sep 2004 09:50:02 -0500
Looking for some advice here.
Windows 2000
Oracle 9.2.0.4
We are running several instances on the machine, but the memory
allocated to them is far under the RAM available. ie. I shouldn't be OS
paging as far as I can tell. I have even shut down instances to reduce
the Oracle memory demands to much less than half the machine's RAM (4
gig total RAM), but I'm still paging like crazy.
Nonetheless, Windows Performance Monitor shows "pages/sec" going as high
as 1500 sometimes when large batch jobs are running against the
database. Jobs that used to run in 4 hours now run over 24 and
sometimes fail.
In addition, I have massive "db file sequential read" wait events in the
database doing the large batch jobs, but my DB Cache Hit Ratios are over
90%. I don't think Oracle's tuning utilities are going to help me
figure this one out. Any ideas? Hopefully I'm just missing something
very obvious.
The OS paging in particular is really bothering me!
Thanks in advance for your time.
Edward Simmonds
--
//www.freelists.org/webpage/oracle-l
Other related posts:
