RE: CPU priority for AIX 5.3 with mixed workload

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Adrian Sent: Tuesday, December 05, 2006 2:36 PM To: oracle-l_at_freelists.org
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.

--
http://www.freelists.org/webpage/oracle-l