Home » RDBMS Server » Performance Tuning » awr report for specific date
awr report for specific date [message #459225] Fri, 04 June 2010 01:24 Go to next message
Riyasbasha
Messages: 25
Registered: March 2010
Junior Member
Hi All

I want to take AWR report at specific date ex(25-05-2010)
how could i make it
can any one help me......

Report message to a moderator

Re: awr report for specific date [message #459226 is a reply to message #459225] Fri, 04 June 2010 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
DBMS_WORKLOAD_REPOSITORY.AWR_REPORT_HTML
See l_bid and l_eid parameters.
To convert date to snap_id query dba_hist_snapshot.

Regards
Michel

[Updated on: Fri, 04 June 2010 01:33]

Report message to a moderator

Re: awr report for specific date [message #459227 is a reply to message #459226] Fri, 04 June 2010 01:32 Go to previous message
Riyasbasha
Messages: 25
Registered: March 2010
Junior Member
thank u michel

Report message to a moderator

Previous Topic: oracleorcl (LOCAL=NO) cpu 100%
Next Topic: Why Elapsed Time Changed while execution plan and stats remains the same?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 07:27:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.