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?
 
slightwv (䄆 Netminder)Connect With a Mentor 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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.