| HTML AWR Report [message #538897] |
Tue, 10 January 2012 05:13  |
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 #538901 is a reply to message #538898] |
Tue, 10 January 2012 05:25  |
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 |
cookiemonster
Messages: 13965
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 #538927 is a reply to message #538904] |
Tue, 10 January 2012 07:17 |
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 #538961 is a reply to message #538938] |
Tue, 10 January 2012 09:13 |
 |
ramoradba
Messages: 2457
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>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
