What to do as the only Oracle DBA in the company

Sounds like they have to keep you if you're the only Oracle qualified person! So...first take a breath and don't worry! Take a look at the following link: http://www.dbatoolbox.com/WP2001/beginners/DBA_Checklist.pdf. It's a paper called "DBA Checklist" written by Thomas B. Cox, with Christine Choi. It gives details for performing daily, weekly and monthly checks of the status of your Oracle databases. All the SQL and PL/SQL code for the listed checks is also provided. This might help you get organized a bit for starters.

I'd also suggest that you do a bit of Web searching (starting with this site) and I think you can find tons of good sites that can give you more info, sample scripts to help you out, etc. Good luck!

For More Information

• Dozens more answers to tough Oracle questions from Karen Morton are available.
• The Best Oracle Web Links: tips, tutorials, scripts, and more.
• Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
• Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
• Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.