Oracle Tips by Burleson Consulting
Introduction to Oracle Concepts
This is a brief
introduction to Oracle Concepts for the DBA. Conceptually, you
can think of an Oracle database as nothing more than a large
electronic filing cabinet, a place to store and retrieve
information. At the computer level, Oracle is a computer program
that manages an electronic filing cabinet.
One reason that
Oracle has become the world dominant database is because it runs on
just about every platform imaginable, from a mainframe to a
Today, most shops run Oracle in UNIX, Linux, and Windows.
Oracle runs on almost every computer ever made, with over 60 diverse
platforms such as Intel (like your PC does), Sun Solaris, old IBM
mainframes, and many, many others.
Conceptually, Oracle is considered the world’s most powerful,
flexible and robust database. Along with this power comes
Oracle has become
the world’s most flexible database and it stores much more than text
and numbers. An Oracle database support video, audio and complex
spatial applications that are used to build jet fighters and
Unlike simpler databases, you can control every aspect of Oracle’s
behavior. You can control how rows are placed on the data blocks and
you can control how Oracle performs hundreds of resource management
Concepts for Automation
However, Oracle can
be simple too! In Oracle 10g, artificial intelligence tools provide
basic management, making Oracle a very simple database. You can
choose to make your Oracle database simple or robust, it’s your
choice. See the book "Easy
Oracle Automation" for details.
As with all software, Oracle must interface with your computer in
order to utilize your hardware. You will find that Oracle is
extremely knowledgeable about how to partake of your processor
power, RAM, and other resources, as we will see in the next
Oracle Database Administration Concepts
Now that we have installed Oracle and created a database, we need to
learn a thing or two about how to manage Oracle. First we will talk
about the Oracle documentation, and then we will talk about how to
startup and shutdown the database. Then we will discuss the data
dictionary and database parameter files, wrapping-up with
administration of the Oracle online redo logs, UNDO segments, and
the administration of Oracle tablespaces.
Oracle Database Documentation
Oracle is a big product, and it is well documented with thousands of
pages of documentation. That much documentation can be really hard
to find your way though, but Oracle does a nice job of helping you.
Oracle provides a web site located at tahiti.oracle.com that has all
the current Oracle documentation and you can also search the Oracle
documentation at search.oracle.com.
Oracle documentation comes in the form of books, each written on
different subjects. There is documentation about Oracle concepts,
database administration, backup and recovery and there is also
reference documentation that contains details on parameters and SQL
The documentation change with almost every release, but the basic
topics remain the same.
These are the books/topics you will be most interested in during
your Oracle DBA career:
* The SQL Reference Guide
* The Oracle Database Reference
* The Oracle Concepts Guide
* The Oracle Administrators Guide
* Oracle Backup and Recovery
We recommend reviewing the Oracle Concepts Guide after you are done
reading this book. It will be a nice second step to becoming an
Oracle Certified Master DBA!