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 210

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