Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Metadatabase
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: 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