Posts

Difference between database and instance:

Difference between database and instance: A database is a collection of files but an instance is a software (or process+memory) which helps in performing operations in the database like reading, writing, bringing DB into the open state and mounting it. A database can be operated by multiple instance (Oracle RAC) but an instance can only open just one database. P.S. Comments are welcome to refine this post so that we can have more accurate information and help knowledge seekers.
Recent posts