Database performance tuning (merged) [message #678870] |
Sat, 18 January 2020 04:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/26321248ba7ef541a18bf7c7bae396cc?s=64&d=mm&r=g) |
mha2020
Messages: 2 Registered: January 2020
|
Junior Member |
|
|
i am relatively new to the database tuning, kindly advise which books or manuals to read in order to efficiently tune the datAbase.
i had a word with few DBA'S and the took awr report but i cannot understand anything .
Kindly advice.
|
|
|
|
|
Re: Database performance tuning (merged) [message #678874 is a reply to message #678870] |
Sat, 18 January 2020 06:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8932 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I wouldn't focus on AWR or ADDM reports. Tuning has to be aimed at a business problem (a report takes ten minutes and you need it in 30 seconds, a screen refresh is too slow, the overnight batch jobs don't finish until lunchtime - that sort of thing) and an AWR report does not help you unless you have already defined that problem. Also, many sites have not paid for the licence you need to use it.
|
|
|