Please provide the output of the following:- sar |grep 'Average:' | awk '{print $3 "\t" $4 "\t" $5 "\t" $6 "\t" $7}' On Thu, Apr 17, 2008 at 12:42 AM, Shastry(DBA) <shastry17@xxxxxxxxx> wrote: > Hi Gurus, > > We did upgrade to 10.2.0.3 from 9i and there is a performance degrade. The > CPU looks like below > > last pid: 4118; load averages: 56.40, 59.29, > 58.40 > 12:05:15 > 270 processes: 207 sleeping, 59 running, 1 zombie, 3 on cpu > CPU states: 0.0% idle, 89.0% user, 11.0% kernel, 0.0% iowait, 0.0% swap > Memory: 16G real, 6573M free, 6571M swap in use, 38G swap free > > All the processes are oracle on the top which are running. Any light on > this how we can proceed in tuning/ working around on this as am not much > exposed to PT. > > Thanks, > Ann > > -- Amit Verma Oracle DBA & Unix Admin. "Winning takes talent but it takes character to keep winning"