Welcome to my blog which contains anything and everything I feel is worthwhile sharing......

Tuesday, April 27, 2010

What is an ORACLE INSTANCE???

The collection of allocated memory(the SGA) and the running processes( PMON,SMON,LGWR etc) on the server is called an "instance".

NOTE:Unless you are using Real Application Clusters (RAC), only one instance can attach itself to a database

"database" is the collection of datafiles on disk. These datafiles belong to your tablespaces. They are also the online redo log files, the parameter file, the password file, and the control files (Refers the Storage structure of the database)