Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: About instances and database

    Hello there DBAs, i'm new to oracle, and wanted some advices and explanation.
    Thank you in advance

    As stated in one of blogs i found it says,
    A database is a set of files stored on disk.
    An instance is a collection of Oracle background processes and shared memory.

    * An instance can mount and open one and only one database.
    * A database may be mounted and opened by one or more instances.

    If i were to have applications , do i need to create each 1 instance, or should i just create 1 instance that can cater all applications and dumb all databases in that 1 instance. Does it kill the effective design in oracle.
    Please advice

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    Depending on your actual requirements you can go either or both ways.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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