Re: Basic Scripts for Database Administration

On Jun 24, 8:35 pm, exazonk <exaz...@xxxxxxxxx> wrote:

snip

I guess there are many ways to skin a cat, but there are probably only
a few that are the most efficient.

It is interesting finding out how people admin their databases as each
DBA probably thinks that they have the best method.

I'm just wondering if there are any good sites that focus on
production DBA stuff on a large amount of databases spread out over a
lot of servers.

There's a bunch bunch of oracle DBA related sites but the work is
sifting thru the good stuff from the not so good stuff and the crud.
My recommendation is to stay away from anything Burleson related.

If you just got a new job in which you inherited 10 servers, with 10
databases on each server, and no administration for the databases
existed yet, what approach would you take to providing DBA support?
Assume the databases are equally divided among windows and unix
servers and range in version from 9i, 10g to 11g.

Is that what happened to you or are you posing theoreticals?

Hire someone immediately with appropriate skills and experience if you
don't have that set of knowledge would be my 1st recommendation.

Health checks would obviously be needed for things like disk space,
tablespaces, log monitoring, load monitoring, statspack, Data Guard
etc.

Dude this whole area has been discussed time after time after time in
this newsgroup.

If you want to locate old relevant discussions here you can use the
google groups interface and search the old postings.



.

Relevant Pages

  • Re: Basic Scripts for Database Administration
    ... It is interesting finding out how people admin their databases as each ... DBA probably thinks that they have the best method. ... My recommendation is to stay away from anything Burleson related. ... servers and range in version from 9i, ...
    (comp.databases.oracle.server)
  • Re: Performance goals for DBAs
    ... I have as some stretch goals? ... I should preface this by saying that I'm not a DBA, ... manages a number of production databases. ... party apps, and if those apps make silly queries or have bad data ...
    (comp.databases.oracle.server)
  • Re: Switching ODBC Oracle databases
    ... I believe your DBA should be able to create an "alias" for 9 of the ... databases in the 10th and then you would only have to create the single ODBC ... connection to that one. ... to switch between them based on the value in a combo box. ...
    (microsoft.public.access.externaldata)
  • Re: Mapped and memory based data files
    ... > I have researched a few SQL type database applications but can not ... being able to handle relational databases widens the domain ... happening, now or in the future, within the RDB packages. ... of the time had to wait for a DBA to do for them, ...
    (comp.lang.apl)
  • Re: SQL active - active cluster hardware design?
    ... if you can find TPC-C benchmarks to be better on Itanium, ... For x64 vs IA-64, as I said it depends a lot on how the system vendors make ... x64 servers may be sufficient. ... You will need to know number of users and databases. ...
    (microsoft.public.sqlserver.clustering)