Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107

    Unanswered: Instance and Database

    Hi,

    All these days i was under the impression that one database is
    one instance. Recently, i came across some information that tells
    that one database can have multiple instances running parallely.
    Can anyone shed some light on this.
    Some information or links would be of great use

    Thanks
    nn

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Instance and Database


  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    It's when you have Oracle Parallel Server or RAC (lately). Two or more instances (SGA + background processes all together) run against the same set ot datafiles, redo log files,etc. (database).

    Each instance have access to the same data - unlike as DB2 and SQL Server, where the data is partitioned (federated clustering).


    Hope that helps,

    clio_usa - OCP - DBA


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •