10046, Unaccounted for Time, Aix 5.3 -- How to Determine Process Pre-Emption

  • From: "Larry G. Elkins" <elkinsl@xxxxxxxxx>
  • To: "'Oracle-L'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 2 Dec 2009 14:13:08 -0600

Listers,

SA's asking for assistance on how to tell if a process is being impacted and
to what degree by processor pre-emption. AIX 5.3. Asked in the context of
trouble-shooting some significant unaccounted for time issues in 10046 trace
files (e.g. 14 of 16 seconds unaccounted for vendor process, 300 of 700
seconds unaccounted for vendor batch job, etc). SA's have "ruled out"
overhead of writing the trace file so now looking at the pre-emption aspect.
A bit out of my league, and I find plenty of approaches in IBM docs, and
from people on this list (but geared more towards Solaris and other flavors,
not Aix). 9.2.0.8 EE and 10.2.0.4 EE, "static" and dynamic LPAR's, seen on
various boxes and databases.

Larry G. Elkins


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


Other related posts: