Database that spans over multiple computers

From: Dino Hsu <dino1_nospam_at_ms1.hinet.net>
Date: Tue, 22 May 2001 12:21:30 +0800
Message-ID: <03ojgt401ts7vunj7c9ncbt2pdalsvjof4@4ax.com>

Dear all,

In a help page about Databse Identification by Service Name, it explains the reason why service name is used instead of SID (Oracle System Identifier) is that the former doesn't distinguish services from instances (an SGA, thus instance, was also identified by an SID). This implies that a database can provide multiple (different kinds of?) services to the clients within the same instance. Can anyone give a real example about this?

It continues with this:
"In Oracle 8i, a new naming schema has been implemented. Because a database can span multiple computers, both the service as a whole and each of its instances are specified."
Why can a database span multiple computers, this really beats me.

Any comments? Thanks in advance.

Dino Received on Mon May 21 2001 - 23:21:30 CDT