Re: Max length of SID in Oracle 8

If I remember correctly, the reason it was limited to four and later just recommend that only 4 be used, was because of OS considerations. If you had SIDs over 4 characters, it was possible for the OS to hash the SIDs to the sname value especially if the first 4 where the same. Since OSs have improved, and since most people don't use SIDs that are the same in the first 4 chars, this is no longer true.

Terry

jkstill_at_cybcon.com wrote:

> Hmmm...
>
> We have at least two databases with 8 character SID's.
>
> Oracle has always recommended that SID's be 4 characters,
> but the maximum length has been 8 for some years.
>
> Could be that the docs are wrong.
>
> Wouldn't be the first time. :)
>
> Jared
>
> On Wed, 17 Jan 2001, Cale, Rick T (Richard) wrote:
>
> > I found it in the "Getting Started" book. Max length is still 4.
> >
> > Rick
> >
> > > -----Original Message-----
> > > From: Cale, Rick T (Richard) [SMTP:RICHARD.T.CALE_at_saic.com]
> > > Sent: Wednesday, January 17, 2001 2:34 PM
> > > To: ORACLE-L_at_fatcity.com; oracledba_at_quickdoc.co.uk
> > > Subject: Max length of SID in Oracle 8
> > >
> > > Hi DBAs,
> > >
> > > I cannot seem to find what the max length of SID is. Is it still 4? I was
> > > thinking in one of the newer version
> > > it increased in size.
> > >
> > > Thanks
> > > Rick Cale, Science Applications International Corp.
> > > Phone:865-481-2198, fax:865-481-8555
> > > e-mail: caler_at_saic.com
Received on Thu Jan 18 2001 - 12:24:44 CST