RE: DB Response Is Very Slow

RE: DB Response Is Very Slow

 

  

Hi Irfan,
Michael is quite right that its really not easy everytime to solve slow db response time.
If you are confirm that its not from app side or any network issues are not there .

I think already you checked hit ratio,Library cache hit ratio, if those reflects quite alright then
you might go for query tuning for the application using Explain plan,then Tkprof, on session basis or by enabling autotrace .
whether your DB's are facing RC/RM or not you can check there also as that can also be area for slow response time.
As there are so many reasons.you can go for, so its not a single issue.
So you have to be specific whats are happening there what are exactly happening.

Use your server perf monitor.

Thanks & Regards,
Santanu Majumdar|Software Engineer| M P H A S I S an EDS Company |
Kshema Dhama, #1 Global Village, Bangalore 560 059 | Tel: +91 80 2860 3600 | Extn :3020 |Mobile:(+91)990.103.3179|Fax: +91 80 28603372/73| www.mphasis.com <file://www.mphasis.com/>

________________________________

From: michael [mailto:oracledba-ezmlmshield-x31203901.[Email address protected]
Sent: Thu 3/29/2007 2:53 PM
To: LazyDBA Discussion
Subject: RE: DB Response Is Very Slow



Hi Irfan,

Slow response time is not always an easy thing to solve. It could be any
number of things. It might not be either your app or database. You
need to eliminate:

1. Mardy users. We expect our machines to be blisteringly fast all the
time. As our workstations age, they appear slow, in comparison with the
shiny new PCs in the shop. Make sure there really is a problem first.
Sounds trite, but it can happen, and you can waste a lot of time on a
wild goose chase just because someone's a whinger.

2. Network problems. Are response times consistent throughout your
organisation? Are you using all of your available bandwidth? If only
part of your organisation is affected, take a look at the network
topology to look for bottlenecks. Your network guys should be able to
help you with this. Look at usage over the working day.

Done that and there's still a problem? OK, next:

3. Get someone (in fact get several people independently) to show you
what the problem looks like. See what else is running on their
workstations. It could be that their machines are running out of puff.
If it's a database problem, you might see some actions taking a long
time and some being reasonably quick. You can then look into those
transactions. Also, check the time against your network usage figures
from step 2. Do they coincide?


If you can narrow it down like this, you should be able to identify
where to start tuning.

Regards,
Mike

-----Original Message-----
From: Irfan Ahmad
[mailto:oracledba-ezmlmshield-x53136415.[Email address protected]
Sent: Thursday, March 29, 2007 9:41 AM
To: LazyDBA Discussion
Subject: DB Response Is Very Slow

Dear friends, i am using oracle 9i v.1 and forms 6i with window 2000
server from previous 4-years. Now a days its creating problem for my
users. They are complaining about their slow speed. Please suggest me
how to find, what is the problem? Either this problem is rising from os
or db ?

Request for quick response.

Irfan Ahmad


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page