RE: Metadatabase

Hi Arie,

OEM does have Capacity Planner available which will automatically log, summarise and purge data via the data gatherer. The data can be stored anywhere and can be accessed via inbuilt graphs / charts or via ODBC (table structure is actually published for these tables).

However, Capacity Planner is not part of the base OEM but part of the additionally licensed Diagnostics Pack.

As Mark suggested, depends what you're trying to log and how much money / time you have to devote to it.

Regards,
Bruce

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

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.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

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).