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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
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: Sat Nov 23 01:45:49 CST 2024