RE: Metadatabase

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Fri, 18 May 2001 03:07:44 -0700
Message-ID: <F001.003074D0.20010518031033@fatcity.com>

Arie

I suppose this depends on the stats that you are trying to collect - If it is just growth reports on data, this could probably be easily achieved with a single script and table. Run the script or schedule it once every X-n (X-integer, n-timespan), and populate your table with the data returned. If there are only a few metrics you would like to keep track of this would save you the cost of a tool.

If you are looking at getting full performance stats such as throughput, performance, growth etc. (Things like hit ratios per day on buffer_cache, DD_cache, user details (how many, what were they doing, what resources have they taken up), monitoring SQL) - in general the whole shabang - and want to go back to a point in time to review those stats then maybe you could look at Precise SQL - as this has historical stores and a fairly low footprint - but be prepared to pay the bucks!!

Then there are the mid tier tools such as the ones we supply (NORAD), that have a repository store. We don't store to a database as yet - but to files, which can be exported to Excel or a similar reporting tool.

What kind of things do you actually want to collect? Is it just performance/growth stats - or do you want to store info on changes in the database etc.?

Regards

Mark

-----Original Message-----
Sent: Friday, May 18, 2001 10:26
To: Multiple recipients of list ORACLE-L

Hi All,

I am looking for an application or software which helps me doing my job as a DBA. I want to set up a what we call a metadatabase, which gets and holds data about the databases I administer as a DBA. I want to keep data in the metadatabase as for example the growth of data in a database for which I as DBA am responsible. I think OEM can help, but is doesnot keep track of the history. Any ideas?

TIA,
Arie Koster.

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arie Koster INET: oracle_arie_at_hotmail.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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

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 Fri May 18 2001 - 05:07:44 CDT