Database ID

From: Martijn <martijnm.bos_at_gmail.com>
Date: 8 Mar 2006 06:55:42 -0800
Message-ID: <1141829741.994875.166270@i40g2000cwc.googlegroups.com>

Hi all,

Can anybody tell me how the database ID is "generated" SQL> select DBID from v$database;

      DBID

---

2321854517

SQL> I'm just wondering how this number/ID is made up, or what it is composed of.

As you can see below we are on a database 9.2.0.7 (on AIX 5.2) SQL> select banner from v$version;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production PL/SQL Release 9.2.0.7.0 - Production
CORE 9.2.0.7.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production NLSRTL Version 9.2.0.7.0 - Production

SQL> Best Regards,

Martijn Bos Received on Wed Mar 08 2006 - 08:55:42 CST