Re: slow sql question

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Fri, 06 May 2011 09:26:49 +0300
Message-id: <4DC394A9.7000802_at_inter.net.il>

#2 - just do:
spool awr_report.html
Select * from table(dbms.workload_repository_html(parameters));

parameters:

1) Dbid from dba_hist_database_instance.
2) Instance number from dba_hist_database_instance.
3) Starting snapshot from dba_hist_snapshot.
4) Ending snapshot from dba_hist_snapshot.
5) 0.

and view it with a browser.

Yechiel Adar
Israel

On 05/05/2011 04:57, Ram Raman wrote:
> #2 Is there a way to automate the generation of reports without
> having to type all the information, if we want to generate them for a
> period of time.
> Thanks.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 06 2011 - 01:26:49 CDT