RE: Max length of SID in Oracle 8

Once upon a time I heard that the first 4 character of the SID is hashed to determine an address in memory for the SGA.

Ergo it was concommitant that when there is more than one database the difference in names must occur somewhere in the first four characters.

It is concievable that although there is a difference, two different 4 letter combinations can hash to the same address.

Have heard about this actually happening. No matter what the SID the DBA wound up in the same database.

(Urban Legend?)

-----Original Message-----
From: Rachel Carmichael [mailto:carmichr_at_hotmail.com] Sent: Thursday, January 18, 2001 11:08 AM To: Multiple recipients of list ORACLE-L Subject: RE: Max length of SID in Oracle 8

8.1.6 sun solaris 2.6 production database, sid is 8 characters

>From: "Mark Leith" <mark_at_cool-tools.co.uk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Max length of SID in Oracle 8
>Date: Thu, 18 Jan 2001 03:55:20 -0800
>
>I have one with 5, but mine is on Win2K. I do remember though that we also
>had another with 5 on NT before we upgraded. This was on 8.1.6.
>
>I also though that NT could handle long file names? At least sp 5&6 could..
>Whether it makes a difference, who knows, apart from Micro$lop..
Received on Thu Jan 18 2001 - 12:14:58 CST