Re: Table that contains the Oracle_SID of the database ?

In article <1993Jun18.030522.24700_at_coulomb.pcc.oz.au>, oracle_at_coulomb.pcc.oz.au (Oracle System Account) writes:
|> Tony,
|>
|> There is no such v$ table storing ORACLE_SID. However, you can still get
|> ORACLE_SID by issuing the following:
|>
|> SQLDBA> show parameter db_name
|>
  The V7 v$database table holds the information you require.

 SQL> desc v$database

 Name                            Null?    Type
 ------------------------------- -------- ----
 NAME                                     VARCHAR2(9)
 CREATED                                  VARCHAR2(20)
 LOG_MODE                                 VARCHAR2(12)
 CHECKPOINT_CHANGE#                       NUMBER
 ARCHIVE_CHANGE#                          NUMBER

SQL> select * from v$database;
Press <ENTER> to continue

NAME CREATED LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE#

--------- -------------------- ------------ ------------------ ---------------
ABMAPSP   05/24/93 10:16:04    NOARCHIVELOG              83237           82984

|>
|> Regards
|>
|>
|> Peng Hu hu_at_coulomb.pcc.oz.au
|> Oracle DBA
|> Prospect Electricity
|> Sydney, Australia
Received on Fri Jun 18 1993 - 16:02:50 CEST