Oracle

After having installed Oracle and created a database, you'll find the following (types of) files on the server:

• control file
• init.ora
  (At least up to 8i, that is. With 9i, it could also be a spfile
• data files
  Those are actually the files that keep the data in the database. After all, it is a database.
• online redo log
  

Additionally, when the instance is started, there will be some Oracle processes and some memory allocated. The memory is called sga.

An Oracle server consists of an Oracle database and an Oracle instance. If you don't want technical terms, you can think of an instance as the software, and the database as the data that said software operates on. More technically, the instance is the combination of background processes and memory buffers (or SGA).

SQL allows to interact with the database.

PL/SQL

SQL*PLUS

Here are some notes that I made and still am making while I am descovering new features about Oracle.

Ever wondered how Oracle would execute an SQL stetement? Let Oracle explain it.

How to manually create an Oracle database on Windows

I have compiled some miscallaneous stuff here

Oracle comes also with oratclsh

Some Oracle Links are here.