Notes on ‘Expert Oracle’ — No.2: Abstract of the Arch

Database and

Database: Static Contents in Disks

Instance: Processes/Threads and Memory running on a Database

    A Database can only be opened by a single instance.

    An instance can only open a single Database. And it dies when it cloese the Database.

SGA:  A shared memory area by all the processes/threads of an instance


    1.Conenction to a
Dedicated Server: Every connection occupies a exclusive server process. Too many connections may bring the server down.

    2.Conenction to a
Shared Server:

        a. All the connections shared a single server process.(Pooling behind the scene)

        b. Dispatcher + SGA Queues

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.