| 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?
Hi,
As shipment my file report.txt, generated with statspack to www.oraperf.com?
That steps should carry out ?
Thanks,
Leonard F.
"Browett, Darren" <dbrowett_at_city.coquitlam.bc.ca>@fatcity.com on 14/03/2001 11:36:21 AM
Please respond to ORACLE-L_at_fatcity.com
Sent by: root_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
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.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: danamn2000_at_yahoo.com 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-LReceived on Wed Mar 14 2001 - 16:02:29 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: dbrowett_at_city.coquitlam.bc.ca 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leonardo Fernandez INET: lfernand_at_cmsenergy.com 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).
 |
 |