STATSPACK or equivalent for 8.0.X databases?

From: dana <danamn2000_at_yahoo.com>
Date: Wed, 14 Mar 2001 07:50:48 -0800
Message-ID: <F001.002CC37C.20010314063124@fatcity.com>

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.

Dana

Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/

-- 
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-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 - 09:50:48 CST