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
Oracle Database

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon
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
slightwv (䄆 Netminder)

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.
Wasim Akram Shaik

--->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/Database/Oracle/Q_28419538.html


But the best thing is to regenerate it with the options steve suggested.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
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
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question