Home » RDBMS Server » Performance Tuning » HTML AWR Report (Red Hat Linux 5.3 and oracle 10g)
HTML AWR Report [message #538897] Tue, 10 January 2012 05:13 Go to next message
morad_dba
Messages: 93
Registered: June 2008
Member

Dear all,

I would like to generate HTML awr report and save it to my local machine.

After running $ORACLE_HOME/rdbms/admin/awrrpt.sql in sqlplus and specifying HTML in (Enter value for report_type: HTML) i hvae get numerous html code in my sqlplus prompt.. I want to save the html report in local machine and open it by double clicking on it.. it will be opened in a browser..

Please help me.

Morad.
Re: HTML AWR Report [message #538898 is a reply to message #538897] Tue, 10 January 2012 05:15 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Spool it intoa file and read it !


Sriram
Re: HTML AWR Report [message #538901 is a reply to message #538898] Tue, 10 January 2012 05:25 Go to previous messageGo to next message
morad_dba
Messages: 93
Registered: June 2008
Member
Dear ramoradba,

I could not understand your post..

should i copy the output and paste into a text file. and run it ?

And I spool the output of awrrpti .. It sopol only the command i passed to the awrrpti.. It did not spooled the html code that has been shown in sqlplus.

help me.

thanks.

[Updated on: Tue, 10 January 2012 05:28]

Report message to a moderator

Re: HTML AWR Report [message #538902 is a reply to message #538901] Tue, 10 January 2012 05:31 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
awrrpt.sql prompts for a file name when run and uses a default, which it'll show on screen, if none is specified. The html output is automatically spooled to that file.
Re: HTML AWR Report [message #538904 is a reply to message #538901] Tue, 10 January 2012 05:34 Go to previous messageGo to next message
Michel Cadot
Messages: 67951
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The script already spool the result in a file pointed by the (substitution) variable "report_name" you can set as you want before executing the script.

Regards
Michel
Re: HTML AWR Report [message #538905 is a reply to message #538902] Tue, 10 January 2012 05:37 Go to previous messageGo to next message
morad_dba
Messages: 93
Registered: June 2008
Member

Dear cookiemonster and ramoradba,

Thanks.. For your valuable answer..

the html file is automatically saved in home location..

Thanks again..

Re: HTML AWR Report [message #538912 is a reply to message #538904] Tue, 10 January 2012 05:47 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
/forum/fa/1606/0/
Re: HTML AWR Report [message #538927 is a reply to message #538904] Tue, 10 January 2012 07:17 Go to previous messageGo to next message
morad_dba
Messages: 93
Registered: June 2008
Member

How to set non-default location using substitution vauiable report_name for awr html report?

is it like

set report_name '/u01/app/oracle' ?

please tell me?

Thanks.
Re: HTML AWR Report [message #538938 is a reply to message #538927] Tue, 10 January 2012 08:03 Go to previous messageGo to next message
Michel Cadot
Messages: 67951
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 10 January 2012 12:34
The script already spool the result in a file pointed by the (substitution) variable "report_name" you can set as you want before executing the script.

Regards
Michel

Re: HTML AWR Report [message #538961 is a reply to message #538938] Tue, 10 January 2012 09:13 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
SQL> @ %ORACLE_HOME%/rdbms/admin/awrrpt.sql

Current Instance
~~~~~~~~~~~~~~~~

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
   80191470 ORCLE11G            1 orcle11g1


Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type: HTML

Type Specified:  html


Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   DB Id     Inst Num DB Name      Instance     Host
------------ -------- ------------ ------------ ------------
* 80191470          1 ORCLE11G     orcle11g1    SANKA-8338B7
                                                ABB

Using   80191470 for database Id
Using          1 for instance number


Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed.  Pressing <return> without
specifying a number lists all completed snapshots.


Enter value for num_days: 2

Listing the last 2 days of Completed Snapshots

                                                        Snap
Instance     DB Name        Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
orcle11g1    ORCLE11G          1586 09 Jan 2012 08:04      1

                               1587 09 Jan 2012 18:52      1
                               1588 09 Jan 2012 19:30      1
                               1589 09 Jan 2012 20:30      1
                               1590 09 Jan 2012 21:30      1
                               1591 09 Jan 2012 22:30      1
                               1592 09 Jan 2012 23:30      1
                               1593 10 Jan 2012 00:30      1
                               1594 10 Jan 2012 01:30      1
                               1595 10 Jan 2012 02:30      1
                               1596 10 Jan 2012 03:30      1
                               1597 10 Jan 2012 04:30      1
                               1598 10 Jan 2012 05:30      1
                               1599 10 Jan 2012 06:30      1

                               1600 10 Jan 2012 20:03      1



Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 1587
Begin Snapshot Id specified: 1587

Enter value for end_snap: 1588
End   Snapshot Id specified: 1588



Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_1587_1588.html.  To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name:<Enter your Location path here>


Previous Topic: Explain Plan
Next Topic: Query running more time
Goto Forum:
  


Current Time: Sun Sep 26 18:03:37 CDT 2021