Link to home
Start Free TrialLog in
Avatar of vangogpeter
vangogpeter

asked on

awr report

awr report scrolled up.
in aix console

any way to spool or get the text format in a single file please
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

What do you mean it "scrolled up"?

If you mean you ran it from sqlplus and the buffer didn't contain it all then issue a spool command before you run the report and a spool off after.

for example:
spool myreport.txt
--generate the report
spool off


Then everything displayed to the screen is in the file myreport.txt
As far as text vs html goes:  how are you generating the report?

If you are running awrrpt.sql then you have an option for text.

It's all in the online docs:
http://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF94203

5.3.6.1 Generating an AWR Report

The awrrpt.sql SQL script generates an HTML or text report that displays statistics for a range of snapshot IDs.
--->awr report scrolled up. in aix console

Seems like a similar one with one of your previous questions .
As suggested in below question, increase the lines of scrollback to some large value such as 200000, then you can `scroll back` and view entire thing.

https://www.experts-exchange.com/questions/28419538/sql-in-aix.html


But the best thing is to regenerate it with the options steve suggested.
Avatar of vangogpeter

ASKER

slightvv

if we give this
c--generate the report
spool off


do we need to give myreport.txt on
or just give

spool myreport.txt
--generate the report
spool off
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial