oracle 11 statspack

can I get statspack to create an html report instead of a txt report in oracle 11
LVL 1
bkreynolds48Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
I haven't used statspack for many years but I do not remember a way to tell spreport to generate html nor can I find documentation on it showing such an option.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slightwv (䄆 Netminder) Commented:
I suppose I should have added:
If you are on 11g, you should start migrating what you use for tuning to AWR.  That has an html report option.  You can also view things live using Grid Control.  With the web GUI you can drill down and look around pretty much real-time.  You have some performance metrics available through the local DBConsole but I'm not sure exactly what all is available.  I don't have any 11g left to see.

https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027
0
Geert GOracle dbaCommented:
i'm pleased i don't use statspack (a free solution), or a paying solution like AWR.
we built our own solution, which doesn't store performance data inside the database, which additionally needs cleanup

the only draw back
we can't see stuff real time, it's always 5 minutes later

monitoring even works across database moves and upgrades.

i guess i'll have to cleanup some of our monitor's data of 5 years and older.
my server is running out of disk space.
0
bkreynolds48Author Commented:
can't use awr on these servers/databases because we don't have a license for it
0
bkreynolds48Author Commented:
thanks for trying
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
HTML

From novice to tech pro — start learning today.