Re: What Instance means ?

Dictionary <no_at_email.edu> wrote (in <36D48FB7.EA86F023_at_email.edu>)...

| "Instance" means "Server" almost every time you see it.
|
| The word "instance" came into use because of it's more precise meaning:
| a specific collection of processes acting like a single server. Hence a
| "Parallel Server" has more than one "instance", each instance acting
| independently, but cooperatively on more than one system.
|
| Hope that helps,
| Ryan :)

And running two completely separate Oracle 'instances' (one development' and one live) on one physical 'hardware server' is?

Also, there is a 'Parallel Server' Oracle accessing many 'instances' on different 'hardware servers'.

I think that an Oracle 'instance' as being the processes and data files on a physical server is the most appropriate way to think about it. Obviously, there can be many 'Oracle instances' on any 'hardware' server.

I agree it gets confusing when trying to map it to other manufacturers idea of a 'database'. Normally that maps onto an Oracle 'schema' quite well. Yes, it is not an exact mapping (to put it mildly)!

graham Received on Sat Feb 27 1999 - 12:31:21 CST