Re: Basic Scripts for Database Administration

John.

I am curious ¿why did you write "stay away from anything Burleson"?

Can you explain why?

HSR

"John Hurley" <johnbhurley@xxxxxxxxxxxxx> escribió en el mensaje
news:38d8c4eb-5760-454b-b504-3228f9943f25@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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. ... servers and range in version from 9i, ... tablespaces, log monitoring, load monitoring, statspack, Data Guard ...
    (comp.databases.oracle.server)
  • 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)
  • 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)
  • Re: SAN (NetApp SnapMirror) replicated Exchange databases usability
    ... to stage Exchange 2007 servers at siteB with SG's and databases that are ... This is achieved by having Exchange ...
    (microsoft.public.exchange.design)
  • Re: Best way to updat TNSNames.ora in all servers
    ... We have many unix servers running Oracle ... that be the case then I would still work to consolidate the databases ...
    (comp.databases.oracle.server)