Oracle DBA Library - Books

SQL and PL/SQL materials are here


If you are just starting to learn the basics of working with Oracle databases, I would recommend the following:


Oracle DBA’s Reference Book

Sam Alapati: Oracle DataBase 11g Administrator’s Guide. The quality of the book is excellent.

This is the book that lay on my desk for quite a long time when server administration was within my competence. Part of the site’s materials are taken from it.

The book may seem quite difficult.


Core

[Jonathan Lewis] Oracle Core. Internal workings for database administrators and developers / trans. from English by A. N. Kiselev – M.: DMK Press, 2015. – 372 p.: ill. ISBN 978-5-97060-169-3


Best books on Oracle Performance Tuning:

  • Jonathan Lewis “Cost Based Optimizer fundamentals”
  • Christian Antognini “Troubleshooting Oracle performance”


Useful books for an Oracle database administrator (in Russian):

  • Oracle 10g administration part 1 (rus)
  • Oracle 10g administration part 2 (rus)


Useful books for an Oracle database administrator (in English):

  • Expert Oracle Database 11g Administration
  • Expert's Voice in Oracle - Kyte T. - Expert Oracle Database Architecture, Second Edition [2010, PDF, ENG]
  • Expert's Voice in Oracle - Alapati S., Kuhn D., Padfield B. - Oracle Database 11g Performance Tuning Recipes. A Problem-Solution Approach [2011, PDF, ENG]


Oracle Classics:

  • Oracle. Database Design (RUS 1999)
  • Tom Kyte - Expert One-on-One Oracle (RUS 2003)


Cost-Based Oracle Fundamentals / Oracle основы стоимостной оптимизации



Links to materials for studying Oracle SQL and PL/SQL are now collected here



Recommend good materials for studying Oracle database, application servers, BI, etc


Copyright holders have become active, search for materials yourself.



~Question (a person works at a company that uses Oracle database servers):

Well, I completed the comprehensive course "Oracle Database 11g Administration" at Specialist.. what's next? I'm still afraid to take on the DB.

~Answer:

You need practice.

If possible, try to set aside a computer and deploy a database on it from some Oracle backups. Or clone an already running one. Maybe one of the DBAs will help. (if possible of course, when I worked I had that opportunity.).

You can also use some standard schemas, but it's better to use something close to real data that you will be working with.

Well, then you should follow all the steps from the Administration 2 course on database recovery, i.e., recovery after losing a control file, after losing a redo log, import/export, backups using RMAN, rollback to a specific date, Upgrade to the next version.


[Offtopic] PostgreSQL Materials


Due to well-known events.


PostgreSQL 15 from the inside https://postgrespro.ru/education/books/internals

PostgreSQL 10 Administration. Configuration and monitoring
https://postgrespro.ru/education/courses/DBA2