| Performance Monitor looked ugly [message #630998] |
Wed, 07 January 2015 09:20  |
bvo65
Messages: 25
Registered: November 2009
Location: US
|
Junior Member |
|
|
OEM has not run for quiet long, once I started (I just started this job) it and noticed the query is causing all this spiking. There's an index but somehow it not using it. Consulted with developer and pulled the query out. We created another index but still couldn't help the cpu usage. It looked fine for a few minutes and jumped back up more than maximum CPU. this spiking is impacting production performance. Do you know why it causes the problem and how to fix it? Is there a way to get the actual values that were entered, instead of the substitution variables?
thanks in advance.
BN
|
|
|
|
|
|
| Re: Performance Monitor looked ugly [message #631002 is a reply to message #631001] |
Wed, 07 January 2015 09:48  |
 |
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
|
Senior Member |
|
|
Do some internet searches and you will find information on how to get bind variable values. You can start here if you like.
There is no simple advice to help you tune as tuning requires knowledge and to some degree experience doing it. Since you think you have a SQL Tuning problem, here is the promotional chapter of my book on SQL Tuning. I have attached the free promotional chapter and the free scripts from the book. This is the complete first chapter and it will teach you about the role of Cardinality in query plan generation and give you some tools to make tuning a little easier. This chapter and the scripts are free and you do NOT need to buy the book in order to use them and share them with others so please do so. If you do decide you want the book, then for the new year, I have reduced the price of the book on Amazon by 40% which if Amazon does its typical 16% discount will provide the cheapest price possible while still retaining free shipping.
Good Reading. Kevin
[Updated on: Wed, 07 January 2015 09:50] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Performance Monitor looked ugly [message #634394 is a reply to message #631002] |
Mon, 09 March 2015 07:42 |
 |
paolfili
Messages: 6
Registered: March 2015
Location: Italy
|
Junior Member |
|
|
Hello Kevin.
IMHO your book it's ,by far, the BEST book on SQL Tuning ever written.
A top class DBA (as you are) can have a relevant knowledge in some areas of the Oracle's ocean.
Anyone can read Lewis,Poder,Antognini,and the other "classics" on Oracle Performance Tuning subject.
But a different matter is explain,and focus so deeply on the process of explaining, complex concepts in a so fascinating way.
Thanks Kevin for your valuable gift to the Oracle community.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
