General - If the application is running very slow? At what points you need to go about the database in order t

GeekInterview.com > Interview Questions > Oracle > General

Go To First | Previous Question | Next Question

General | Question 200 of 211

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

Total Answers and Comments: 4

Last Update: May 13, 2007 Asked by: j.w

Sponsored Links

Best Rated Answer

—

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

Is this answer useful? Yes | No

March 12, 2007 05:39:41

Nikhil_4_Oracle

RE: If the application is running very slow? At what p...

Hello Friends

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

Thnax

Nikhil

Is this answer useful? Yes | No

May 13, 2007 00:58:57

Srinivas Ellendula

Member Since: May 2007 Contribution: 3

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.

sudo topas
nmon
vmstat 1 10
sar 1 10

Is this answer useful? Yes | No

May 13, 2007 01:01:57

Srinivas Ellendula

Member Since: May 2007 Contribution: 3

RE: If the application is running very slow? At what p...

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

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank