Home » RDBMS Server » Performance Tuning » AWR Report or ADDM Report? (Oracle 10g - 10.2.0.3.0 on RHEL 64 bit)
AWR Report or ADDM Report? [message #305404] Mon, 10 March 2008 12:12 Go to next message
OraKaran
Messages: 183
Registered: March 2008
Location: United Kingdom
Senior Member
Hi,

I am using Oracle 10g - 10.2.0.3.0 on RHEL 64 bit

If I found some querey was running slow an hour back, what will be the sequence to trace the things?

AWR Report
ADDM Report
v$active_session_history


Since ADDM extracts information from AWR itself which information in ADDM is not available in AWR?

Thanks and Regards,
OraKaran
Re: AWR Report or ADDM Report? [message #305409 is a reply to message #305404] Mon, 10 March 2008 12:47 Go to previous message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Automatic Workload Repository
Automatic Database Diagnostic Monitor

Regards
Michel
Previous Topic: Tunning required
Next Topic: cost in explain plan
Goto Forum:
  


Current Time: Thu Dec 08 04:16:28 CST 2016

Total time taken to generate the page: 0.15450 seconds