RE: Max length of SID in Oracle 8

How about this

$ ps -fe | grep lgwr

  oracle   957     1  0 13:16:52 ?        1:03 ora_lgwr_simplydb
  oracle   653     1  0 11:55:30 ?        0:23 ora_lgwr_feeddb
  oracle  2276   502  0 10:43:56 pts/2    0:00 grep lgwr
  oracle  2268     1  0 10:41:35 ?        0:11 ora_lgwr_feedmx

Vadim Gorbounov
Oracle DBA

-----Original Message-----
From: Denny Koovakattu [mailto:denny_vk_at_yahoo.com] Sent: Thursday, January 18, 2001 2:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: Max length of SID in Oracle 8

Hi,

  Both ORACLE_SID and ORACLE_HOME are part of the hash algorithm. Different SID's hashing to the same memory location is no urban legend. I had this problem with 8.1.5 and 8.1.6 on HP. Either change the SID or change the location of ORACLE_HOME to fix it.

Regards
Denny

• "ODell, Charles" <odellc_at_spawar.navy.mil> wrote:
  > 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?)
  

  ---

--
Denny Koovakattu
denny.koovakattu_at_oneco.net
http://oneco.net/

__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Denny Koovakattu
  INET: denny_vk_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may