| AWR and ADDM - Does anybody use these? [message #351436] |
Tue, 30 September 2008 18:15  |
efachim
Messages: 42
Registered: July 2008
|
Member |
|
|
Hi folks,
Does anybody use these features provided by Oracle? If so, have you found any shortcomings with them? ie, Are there features that you would have liked to see, or analyses, that Oracle has not provided?
rgds, Efachim
|
|
|
|
|
|
|
|
|
|
| Re: AWR and ADDM - Does anybody use these? [message #352606 is a reply to message #351522] |
Wed, 08 October 2008 09:49  |
efachim
Messages: 42
Registered: July 2008
|
Member |
|
|
Hi Ebrian,
Do you know whether you need an additional license for AWR and ADDM for Oracle 11g? I know that is the case for Oracle 10g...
| ebrian wrote on Wed, 01 October 2008 04:55 | | efachim wrote on Tue, 30 September 2008 19:15 |
Does anybody use these features provided by Oracle? If so, have you found any shortcomings with them? ie, Are there features that you would have liked to see, or analyses, that Oracle has not provided?
|
Definitely use them, however the fact that they are an additional cost option, most folks can't use those tools without violating their license agreement.
|
|
|
|
|
|
|
|
|
| Re: AWR and ADDM - Does anybody use these? [message #353673 is a reply to message #352610] |
Tue, 14 October 2008 10:00 |
efachim
Messages: 42
Registered: July 2008
|
Member |
|
|
Thanks Ebrian.
| ebrian wrote on Wed, 08 October 2008 09:14 | | efachim wrote on Mon, 06 October 2008 14:06 | Does the data dictionary table dba_hist_active_session_history store all the cumulative wait data from the first time the database is created?
|
The data is maintained in DBA_HIST_ACTIVE_SESS_HISTORY for 7 days by default. This can be modified if need be.
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
