| Database performance tuning (merged) [message #678870] |
Sat, 18 January 2020 04:52  |
 |
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  |
John Watson
Messages: 8964
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
