René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
Oracle | ||
Components of a databaseFiles
After having installed Oracle and created a database, you'll find the following (types of) files on the
server:
Instance
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.
Update
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.
|