Re: app is slow
- From: kyle Hailey <kylelf@xxxxxxxxx>
- To: Brian.Zelli@xxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 3 Jun 2009 09:12:06 -0700
Some options to get started
* Run Statspack
* Look at OEM top activity page
* run DB Optimizer (http://oraclemonitor.com 14 days free)
For statspack, look at top waits and top SQL
For OEM and DB Optimizer will give you top wait, top SQL and top Session
and you can narrow in easily on the time.
See if there are any wait issues, see if there is a SQL that is taking
most of the time, for session if you know the ones having issues, see
what they are executing. All pretty easy with OEM and DB Optimizer.
Do you know the query that's having problems already? Was it ever working?
You can run the query through DB Optimizer and find out if there is a
better execution plan than what's the current execution plan - if so
you probably want to check into why, issues like bind variable
peaking, etc.
DB Optimizer will also look to see if there are missing indexes.
Best Wishes
Kyle Hailey
http://oraclemonitor.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
