René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -


Components of a database


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


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.
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.
I have compiled some miscallaneous stuff here
Oracle comes also with oratclsh
Some Oracle Links are here.


Thanks to Tim Allen and David K. Brown who pointed out an error on this page.
July 20th: Carlos A. Calderón Solís finds a broken link and reports it to me.