Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

This could include:

  • Books worth reading;
  • Tools worth having;
  • etc.
share

locked by HopelessN00b Dec 5 at 6:21

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center.

3  
...pills worth taking, asylums to retreat to when it gets to be too much... :-) –  Paul Tomblin May 2 '09 at 17:27
    
This should be a community wiki –  scheibk May 2 '09 at 18:09

7 Answers 7

Books:

Optimising Oracle Performance - Cary Millsap

Pretty much everything by Thomas Kyte (http://asktom.oracle.com)

Cost-Based Oracle Fundamentals (Jonathan Lewis)

Web sites (if you are dealing with Oracle on Linux):

http://www.puschitz.com - installing oracle on Linux, Linux performance tuning tips

http://www.oaktable.net

...and the oracle websites, metalink etc.

share

I'll take it to a bit different direction.

The top 5 things every Oracle DBA should know and practice regularly:

  1. Backup and Recovery
  2. Basic Performance Diagnostics / Tuning
  3. Backup and Recovery
  4. Basic database security
  5. Backup and Recovery (seriously)

Also, reading Oracle documentation and trying things out is critical. Be curious. If you work with other DBAs, ask them questions and try to learn from their experience and share your own learning. But don't take everything you read or hear for granted - try to understand to logic and learn to test everything yourself.

Be curious about operating systems, storage, networking etc. Learn to establish good relationships with these teams in your organization. Know what's there are working on - it will affect you.

Also, learn to work with developers, understand their pains and educate them about how to properly work with a database. For example, bind variables - good. For example, grant DBA to every developer - bad. Be patient - there are many programmers and a few DBAs, so this is never-ending.

Also, learn to work well with Oracle Support. It is a skill that needs practicing. While you are at metalink, learn your way around and try some of the new stuff there.

Hmm... it is enough DBA zen for now :)

share

For the documentation and the blogs alone, you gotta start with http://www.ToadWorld.com.

share

Whenever possible, know the manual way of doing something, as opposed to using a GUI. For example, know how to create a physical standby database using OS commands and utilities; or clone a database by creating an RMAN script and running it command line vs. using Enterprise Manager screens.

share

I really liked this article.

share

Blog from SQL guru Steven Feuerstein

share

Not the answer you're looking for? Browse other questions tagged or ask your own question.