No best answer available. Please pick the good answer available or submit your answer.
August 02, 2006 13:38:23
suren
RE: If the application is running very slow? At what p...
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
RE: If the application is running very slow? At what p...
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.
