Home » RDBMS Server » Enterprise Manager » AWR and ADDM - Does anybody use these? (Oracle 10g and 11g)
AWR and ADDM - Does anybody use these? [message #351436] Tue, 30 September 2008 18:15 Go to next message
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 #351476 is a reply to message #351436] Wed, 01 October 2008 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Does anybody use these features provided by Oracle?

Yes but the package not in OEM.

Quote:
have you found any shortcomings with them?

No, better than Statspack report.

Regards
Michel

Re: AWR and ADDM - Does anybody use these? [message #351522 is a reply to message #351436] Wed, 01 October 2008 05:55 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
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 #352227 is a reply to message #351436] Mon, 06 October 2008 13:06 Go to previous messageGo to next message
efachim
Messages: 42
Registered: July 2008
Member
Does the data dictionary table dba_hist_active_session_history store all the cumulative wait data from the first time the database is created?
Re: AWR and ADDM - Does anybody use these? [message #352606 is a reply to message #351522] Wed, 08 October 2008 09:49 Go to previous messageGo to next message
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 #352609 is a reply to message #352606] Wed, 08 October 2008 10:12 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Yes, there is still an additional license required for these components with 11g.
Re: AWR and ADDM - Does anybody use these? [message #352610 is a reply to message #352227] Wed, 08 October 2008 10:14 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
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.
Re: AWR and ADDM - Does anybody use these? [message #353673 is a reply to message #352610] Tue, 14 October 2008 10:00 Go to previous message
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.

Previous Topic: Network requirement between Management Agent and Management Server
Next Topic: OEM Hangs
Goto Forum:
  


Current Time: Thu Mar 28 03:28:21 CDT 2024