suren

• Aug 2nd, 2006

 

hai

for improving performance, we  need  to  check  the  sql  statement blocks , because for  every  sql  satement execution transfor  to  sql  engine and  come back  to  plsql engine that process takes more  time to  process the  plsql block

Nikhil_4_Oracle

• Mar 12th, 2007

 

Hello Friends,

Do the Normalization ,
Its very Heavy formulated procedure but works...

Thnax,

Nikhil

Srinivas Ellendula

 Profile Answers by Srinivas Ellendula 

• May 13th, 2007

 

First  of all check the process running on that server...if the idle process is 0, look  if there are any run away processes taking most of the CPU and find exactly what it is doing... you can find the server process by typing the below command in solaries/AIX servers.

sudo topas
nmon
vmstat 1 10
sar 1 10

Srinivas Ellendula

 Profile Answers by Srinivas Ellendula 

• May 13th, 2007

 

Check is there any high CPU using , u can find the infomartion by using below commands in SOLARIES/AIX servers.

nmon
sudo topas
vmstat 1 10
sar 1 10
top

Regards
Srinivas Ellendula