| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: STATSPACK or equivalent for 8.0.X databases?
Try http://www.oracle.com/oramag/oracle/00-Mar/statspack-other.html
It outlines the steps to install adn run statspack within 8.0.x.
I haven't run it myself as of yet, but it looks straight forward.
-----Original Message-----
Sent: March 14, 2001 6:31 AM
To: Multiple recipients of list ORACLE-L
Will statspack ever be available, in a supported version, for Oracle 8.0.X? We'll be upgrading the machine I'm concerned about to 8.1.X eventually (next six months or so); But for now, I'd like to have access to a more sophisticated tuning-data gathering tool than bstat/estat.
I find it appalling that bstat/estat can't collect, compare, and contrast multiple sets of tuning data over time; that it can't calculate db buffer cache hit ratios, etc.
We've purchased Spotlight on Oracle from Quest; But come to find out (someone else did the research and made the purchase recommendation before I became involved), Spotlight is merely a real-time monitor and can't save tuning data. I thought about writing something to retrieve data from the Spotlight tables, or modifying bstat/estat to make it do what I want, but statspack seems to do everything I want - and who wants to reinvent the wheel?
Any good tuning data gathering freeware out there (with statspack-like functionality) for use with 8.0.X databases?
Thanks very much.
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Mar 14 2001 - 12:34:48 CST
 |
 |