awr report

vangogpeter
vangogpeter used Ask the Experts™
on
awr report scrolled up.
in aix console

any way to spool or get the text format in a single file please
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
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
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
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.

http://www.experts-exchange.com/Database/Oracle/Q_28419538.html


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

Author

Commented:
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
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
I do not understand what you are asking.

Let's try this:
In sqlplus you can spool anything that shows up on the screen to an output file.

You start capturing the output with:  spool some_file_name

You end capturing the output with: spool off

Anything you do in between will be captured.

I suggest you read up about spool in the docs:
http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve043.htm#SQPUG126

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial