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: [EMAIL PROTECTED] 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:
[EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
