Kates Plaqyground Vids

L ' ABC


work with Oracle for a couple of years and almost got in a head that big will the DBA, yes! :-D

Like anyone approaching for the first time to a new topic, I immediately searched the documentation that would clarify the various aspects of Oracle.
In my experience, the main sources from which to draw information: *

colleagues (very useful to directly ask those who know more) * books (the old print media is always a good starting point) * Internet

after breaking up a few boxes just not willing connects with all my questions (forgive me) and seeing that the role DBA increasingly fascinated me, I started to browse through literally hundreds of pages in pdf format on many different subjects that revolve around this RDBMS, subscribe to forums, mailing lists, groups on Facebook, etc.. All this has allowed me from time to time, to solve problems of various kinds, for example relating to the installation of Oracle Database Server, or the backup management, or execution of SQL queries to generate reports, and so away, but I always felt that I lacked a more orderly way (from the standpoint of DBA, as always) like this:

BASES FOR ORACLE -> Install DBMS -> DB CREATION -> Backup Manager - -> PERFORMANCE TUNING

Unfortunately, this led me to having to take back many times the same things maybe because I discovered not to have them studied and thorough enough before, or they may discover a document that I should study before losing, in fact, long .

With this post I intend to csotruire a sort of primer (see image at the beginning of post) useful for an orderly approach to Oracle and its documentation.
1) BASIS OF ORACLE: Oracle Database Concepts

Oracle is the official document that explains the foundations of the popular RDBMS

2) INSTALLATION: in this case comes to rescue an entire section Oracle documentation team (version 10.2 of the DBMS). It is not necessary to read all the documents proposed (I have a lot), but simply choose the suitable one according to its platform hw (32/64 bit) and SW (Microsoft Windows, FNU / Linux, Solaris, etc.)

3) CREATING DB: the essential guide to reference (and even more technical), is known
Administrator's Guide


4) MANAGEMENT BACKUP: You can find the section (Backup and Recovery) in the homepage of the Documentation for Oracle Database
Server 10.2 through the tab "Administration"

5) PERFORMANCE TUNING: topic
the "Performance Tuning Guide"
on how to configure and monitor the performance of Oracle Database Server


points made above are, in my view, the wealth of knowledge that should be right of the figure and from which the DBA before interested in other aspects of this complex and powerful RDBMS.
Happy reading!