Re: Database practices/operations evaluations.

From: <lyxx09_at_gmail.com>
Date: Mon, 6 Apr 2009 18:17:39 -0700 (PDT)
Message-ID: <fd2c4afb-64f8-4947-9b0a-3d16e4be6f93_at_v19g2000yqn.googlegroups.com>


From: "lyxx09_at_gmail.com" <lyxx09_at_gmail.com> Newsgroups: comp.databases.oracle.server Subject: Re: Database practices/operations evaluations. Date: Mon, 6 Apr 2009 18:17:39 -0700 (PDT) Organization: http://groups.google.com
Lines: 25
Message-ID: <fd2c4afb-64f8-4947-9b0a-3d16e4be6f93_at_v19g2000yqn.googlegroups.com> References: <a11cc163-a214-46d5-a7a7-69784933cddc_at_w9g2000yqa.googlegroups.com>

<976164b5-85e7-42ed-8ab5-b6fcd7f2a55f_at_n17g2000vba.googlegroups.com>
<7EtCl.211519$IC4.18525_at_newsfe13.ams2> <00aa7272-880f-48ae-83e7-175bb0ca0146_at_y7g2000yqa.googlegroups.com>
NNTP-Posting-Host: 24.125.244.232
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1239067060 32161 127.0.0.1 (7 Apr 2009 01:17:40 GMT) X-Complaints-To: groups-abuse_at_google.com NNTP-Posting-Date: Tue, 7 Apr 2009 01:17:40 +0000 (UTC) Complaints-To: groups-abuse_at_google.com Injection-Info: v19g2000yqn.googlegroups.com; posting-host=24.125.244.232;

        posting-account=Y4aVpgoAAAAGm4TjPjd9yulpH6-q27MQ User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.8)

        Gecko/2009032609 Firefox/3.0.8 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe) Xref: textnews.cambrium.nl comp.databases.oracle.server:84785

All -

I just realized that I did not provide sufficient information. We have one project where 12 DBAs are working 24*7 to support 250 databases. RAC and Replication are also in uses. Most of the databases are being used for 3 tier applications.

They got OLAP/OLTP and few DSS instance also. It is a 24*7 support for almost all the DBA tasks from installation to manage RAC/Replication and troubleshooting.

I do not know what all other information I need to include here. I work for a diff. project and has been asked to evaluate this project based on best database practices and processes.

If this were to work technically fix one or two problem I could have done this or I would have feel confident. But this type of task I have never done before. I know it required to be there for some time to understand the environment and implemented practices.

I just thought to put this question for some suggestions who already had done this kind of job.

Regards,
Lyxx Received on Mon Apr 06 2009 - 20:17:39 CDT

Original text of this message