I'll throw in my *very expensive free* comments...
<expensive free comments>
This begins to create the corporate metadata and architecture as Peter mentions. We are on this road, and there are several tools that can do *auto discovery*. There are some very nice tools on the market for asset discovery. They have *exit points* where one could write some basic code to access those assets(sql getting v$ info and store in your metadata?).
We have built an enterprise repository to maintain infrastructure data, application, servers, network devices, and transport layers. And now we are going down the *yellow brick road* to begin the data acquisition process.
We too, will also define and assign accountability to those elements within our repository.
</expensive free comments>
greg
-----Original Message-----
From: Robson, Peter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 30, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: DBA Support Database
Just a quick reply to this.
You are, in fact, formulating the sort of request which would be input to a
corporate data architecture. We have built such a thing, and it includes the
issues you refer to. More importantly, we have identified who is responsible
for every single piece of data in the system. The management of an attribute
in a table can in fact be traced right back up to that level of senior
management where they don't even know how to spell 'Oracle'...
peter
edinburgh
> -----Original Message-----
> From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 30, 2003 3:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: DBA Support Database
>
>
> I was thinking about putting together a database that
> contains a list of
> DBAs, servers, databases, and applications. The database
> would be used
> by the Helpdesk and Management to see who is responsible for a given
> application or database when problems occur.
>
> I thought I would check first and see if anyone has already designed
> such a database and might be willing to share it.
>
> Thanks!
> Ron Smith
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Smith, Ron L.
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>
*********************************************************************
This e-mail message, and any files transmitted with it, are
confidential and intended solely for the use of the addressee. If
this message was not addressed to you, you have received it in error
and any copying, distribution or other use of any part of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not necessarily represent those of the British
Geological Survey. The security of e-mail communication cannot be
guaranteed and the BGS accepts no liability for claims arising as a
result of the use of this medium to transmit messages from or to the
BGS. . http://www.bgs.ac.uk
*********************************************************************
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robson, Peter
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
