RE: CPU priority for AIX 5.3 with mixed workload
- From: "Jesse, Rich" <Rich.Jesse@xxxxxx>
- To: <ade.turner@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 5 Dec 2006 16:04:09 -0600
Hey Adrian,
Have you tried turning off SMT on your test system? From what I can
tell, smtctl can change this on-the-fly. If that's the case, perhaps
SMT could be turned off for the duration of your batch job.
Probably overly simplistic, but maybe worth a shot. And now to ask my
SA about SMT... :)
GL!
Rich
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Adrian
Sent: Tuesday, December 05, 2006 2:36 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: CPU priority for AIX 5.3 with mixed workload
Hi,
My customer is running a 10.2.0.2 database on AIX5.3, p590 with 14 Power
5
CPUs and SMT enabled.
The day workload is 8000 dedicated user connections plus 5 or so
concurrent
long running reports.
They have an overnight batch job that is CPU bound and taking 8+ hours
to
run.
On an unladen identical test system the same batch job completes in 2.5
hours.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
